April 2023 Data Snapshot
April 2023 Data Snapshot
State Agency Officials
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!
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.
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.
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.
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.