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

December 2023 Data Snapshot Report

December 2023 Data Snapshot Report

DATE
Friday, December 1, 2023
ATTENTION

State Employees

CONTACT
Image shows how to access oData on a dataset and view.

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 Here

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:

 

City Budget Explorer

Department of Management

View Asset

 

 

 

Online Training

Checkout December Training

View Schedule

On-demand also available!