February 2020 Data Snapshot
In the February 2020 data snapshot, you will find information on:
- We Have Economic Data
- Tell Me a Story
- Creating a Filtered View
- View the Most Recent Time Period
- Data Assets
- Portal Accounts
- State Data Plan
News, Updates & Tips
We Have Economic Data
We are now automatically importing the following datasets into the state data portal using the U.S. Department of Commerce, Bureau of Economic Analysis' web services. As new data is made available by BEA, these datasets will automatically be updated. Additional variables that were not included in this first iteration will be available soon.
- Annual and Quarterly Gross and Real Gross Domestic Product for State of Iowa
- Annual Personal Consumption Expenditures for State of Iowa
- Quarterly Personal Income for State of Iowa
- Annual Personal Income for State of Iowa
- Annual Personal Income for State of Iowa by County
Tell Me a Story
On the state data portal, agency staff are now able to create stories that provide a more meaningful way to for you to explain and the public to explore your data. The following new stories were created in February:
- Iowa Economic Indicators
- Iowa Executive Branch Employees
- Iowa Campaign Contribution Report
- Iowa Per Capita Personal Income
- Iowa's Gross Domestic Product
Reach out if you want to learn more about this tool, or if you have an idea for your agency.
Creating a Filtered View
Many times it is necessary to filter or aggregate a dataset, or highlight specific records within a dataset to help answer more specific questions related to data, and/or hide columns and change column labels and descriptions in preparation to making the data public. You can do all of these things using filtered views. This playbook walks through the process of creating a filtered view.
View the Most Recent Time Period
As dashboards are built on the state data portal, there are many instances where a chart or map needs to present data from the most recent time period reported. While visualizations have relative date filtering capability (e.g. last month, last year, etc.), they oftentimes will result in visualizations not rendering correctly due to delays in data reporting. This new playbook walks through the process of creating a filtered view that presents data for the most recent time period. Charts and maps created based on this filtered view will always sync up with the measures using the last value period type to account for delays in data reporting.
The table below reports the number of public data assets published on the state data portal by asset type for the portal as a whole.
|Data Asset Type||Public Assets|
Total User Accounts: 132
Active Users: 18 (13.6% of total)
Note: Active Users have logged in the data portal at least once in the past month.
The State Data Plan identifies actions Executive Branch State Agencies (non-elected) intend to implement.
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.
|Program Area|| |
|Fiscal Year|| |