December 2023 Data Snapshot

New On-Demand Course

There is a new on-demand course available on the data & insights training portal to learn how to build queries with the Exploration Canvas in order to create and power new views of your data.

Enroll in the on-demand course

Using oData

Every dataset and view published on the enterprise and open data platforms whether private or public can be accessed via oData. This enables further analysis of datasets and views using Microsoft Excel, PowerBI, Tableau and other oData-compatible analytics tools.

For private assets, users will need to leverage an API key and secret for basic authentication as we rely on single-sign on.

More on Using oData, and generating API Keys.

Validating Data in Spreadsheets

Many state employees utilize spreadsheets to capture information about state programs. Both Google Sheets and Microsoft Excel support creating data validation rules that prevent users from entering incorrect data, ensures consistency, and controls user input. All of which better prepare your data for analysis. Below are a couple resources to get started:

Data Spotlight

City Budget Explorer

Department of Management

The City Budget Explorer is an interactive budget providing line item detail for revenue and expenses associated with city budgets in Iowa. It an ongoing commitment to improving fiscal transparency. This website allows you to explore the budgets of every city in Iowa through highly interactive charts, graphs, and tables.

View Asset

December Online Live Data Skills Training

All courses are 60 to 90 minutes in length. Go to the data & insights training portal to sign up for the following courses as well as on-demand training.