This month, we spotlight a highly interactive report providing information on reported crashes in the State of Iowa. We also provide a short checklist to ensure datasets that support monitoring performance provide a good foundation for the creation and publication of private, internal or public dashboards.

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

News, Updates & Tips

Monthly Spotlight: Iowa Crashes

Iowa Crashes is a highly interactive report providing information on reported crashes in Iowa. In this report you can find information on:

• Number of crashes by month and year.
• Property damage caused by crashes.
• Major causes of crashes, and drug/alcohol influence.
• Conditions at time of crash.
• Roadway characteristics and contributions.
• Crashes by month of year, day of week and time of day.
• Location of fatal crashes.

The report is filterable by date of crash, county, city, crash severity, major cause, drug or alcohol, or any combination.

View Interactive Report

Monitoring Performance

In Iowa Data, state agencies have the ability to create and publish private, internal and public data stories/dashboards containing metrics and visualizations to monitor performance. However, the key to publishing a high quality dashboard is starting with a dataset that supports monitoring critical characteristics for the system being monitored, see the following SIPOC model.

The following checklist will ensure your dataset provides a good foundation:

1. Dataset represents a single system or process.
2. Dataset includes variables for key system dates necessary to monitor timeliness (e.g., input received, process start, process end, output delivered, etc.).
3. Dataset includes variables that help categorize and segment performance (e.g., input type, output type, demographics, spatial characteristics, status, etc.).
4. Dataset is granular so that each record in the dataset is associated with an individual output (e.g. a permit, license, investigation, case, complaint, grant, etc.).
5. Dataset includes variables providing facts, measurements or observations related to critical characteristics.
6. Dataset includes variables that serve as record identifiers to facilitate updating and possibly joining data.
7. Dataset includes codes (e.g., county numbers, GNIS, FIPS, NAICS, SOC, etc.) that faciliate joining data.

Good luck! Let us know how we can help!

Live Training in December

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

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

Data Assets

The table below reports the number of public data assets published on Iowa Data by asset type. Please note that not all public data assets are included in the public catalog.

View All Executive Branch/Non-Elected Agency Public Data Asset Counts

Catalog

Browse the Public Catalog on data.iowa.gov

User Accounts

Total User Accounts: 135
Active Users: 20 (14.8% of total)

Note: Active Users have logged in the data portal at least once in the past month.

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.

• love it
• meh
• hate it

Follow Us on Twitter

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