Official State of Iowa Website Here is how you know
Iowa Department of Management

April 2023 Data Snapshot

April 2023 Data Snapshot

DATE
Tuesday, April 4, 2023
ATTENTION

State Agency Officials

CONTACT
Image of help video block

This month, we highlight new quick start videos to teach users the basics of interacting with data on data.iowa.gov. We provide you with an updated procedure for publishing new views that incorporates functionality available in the new exploration canvas. We also introduce a new playbook for calculating a running total using data published on the data platform, and introduce new functionality for downloading data directly from stories making data on the data platform even more accessible to users.

Be sure to check out upcoming live training sessions to improve your data skills, and as always explore the on-demand training options.


News, Updates & Tips

New Quick Start Videos

data.iowa.gov

Need a little help getting started with the tools and features on data.iowa.gov? A collection of short videos designed to teach you the basics of interacting with datasets, visualizations, and more are now available. Check it out!

Access Videos

Updated Procedure: Publishing a New View

This updated document walks through the process of creating and publishing a new view that filters, aggregates, joins, and/or reorganizes data utilizing visual query editor and Socrata query (SoQL) editor within the exploration canvas.

Open Procedure

New Playbook: Calculating a Running Total

This playbook walks a user through calculating a running total using the SoQL editor in the exploration canvas. A running total is the sum total of values associated with the current and previous time periods. A common use case for calculating a running total is to present a backlog over time. The backlog would be the running total of the difference between the number of cases opened less the number closed for a specific time period.

Open Playbook

Exporting Data from Stories

support.socrata.com

Users can now download data from any chart or map within a story. Previously, this was only available on table visualizations. This enhancement removes barriers by allowing user to access the data they need. Exports include a date informing users when the data was exported, since the data can change over time.

View Support Article

Upcoming Live Training

Get trained! The table below highlights upcoming live training available to state employees with an account on Iowa Data.

Date Start Time Course
April 10 10 AM Transform Data with Socrata Query Language
April 10 3 PM Explore Data with Charts
April 12 10 AM Map Your Data
April 14 12 PM Create Performance Measures
April 17 10 AM Tell a Story with Perspectives
April 19 3 PM Collaborate with Enterprise Data
April 21 12 PM Data Analysis Tools and Connections
April 24 12 PM Create and Manage Your Dataset
April 26 3 PM Shape & Join Data in the Exploration Canvas
April 28 12 PM Tell a Story with Perspectives
May 1 10 AM Clean and Tidy Data
May 3 3 PM Clean and Manage Your Dataset
May 5 3 PM Transform Data with Socrata Query Language
May 8 10 AM Explore Data with Charts
May 10 3 PM Map Your Data
May 12 10 AM Create Performance Measures
May 15 10 AM Tell a Story with Perspectives
May 15 3 PM Collaborate with Enterprise Data
May 23 12:30 PM Tell a Story with Perspectives - Cohort 2023
May 24 10 AM Create and Manage YOur Dataset
May 24 3 PM Shape & Join Data in the Exploration Canvas
May 26 12 PM Tell a Story with Perspectives
May 30 12:30 PM Tell a Story with Perspectives - Cohort 2023
May 30 3:30 PM Tell a Story with Perspectives - Cohort 2023

View on demand training & access the training portal (Log-in Required).


Data Assets

Browse the catalog on data.iowa.gov. The catalog allows for searching, filtering, and sorting of available data assets, which is important as the number of assets available to the public continues to grow. Learn how to use the catalog.


Questions or Issues?

Please complete the Data Portal Question & Issue Form


How do you like this Month's Snapshot?

Help make this newsletter better; provide your feedback.


Follow Us on Twitter

We are known to tweet. Follow us at @IowaData on Twitter.