January 2020 Data Snapshot
In the January 2020 data snapshot, you will find information on:
- Creating Formatted Tables for Stories
- Assessing Dataset Quality
- Removing Data Assets
- Data Assets
- Portal Accounts
- State Data Plan
News, Updates & Tips
Creating Formatted Tables for Stories
Tables provide fast and efficient readability, and make it easy to compare pairs of related values. In stories you have the ability to embed filtered views, and even datasets, and apply on display filtering to those embeds. However, there may be instances where you need to apply more complex calculations within your table than may possible within a filtered view, or just want a table that is more nicely formatted. This new playbook walks you through the process of setting up and embedding a formatted table to summarize information in a story using a dataset (or filtered view) published on the State Data Portal and Google Sheets.
Assessing Dataset Quality
While we are still wanting to add new datasets to the portal - especially from agencies who have yet to contribute, our focus is shifting to improving the quality of datasets published. We want to ensure that datasets published on the State Data Portal are of high value to potential users of the data. As a means to provide improvement recommendations to agencies, we are putting together an assessment process. We would like your thoughts and comments on the dataset quality rubric which will serve as the foundation for the assessment. Anyone with the link can comment. Your feedback is greatly appreciated.
Open Draft Dataset Quality Rubric
Removing Data Assets
While we are still very much focused on adding high value data assets and improving existing ones, there are times we may need to remove an asset. The Data Portal Governance Guideline provides methods and resources related to planning, publishing data assets, and creating visualization, measures and stories. However, no guidance is available on identifying and removing data assets that are no longer of value. If you have thoughts on this topic, please contact Scott Vander Hart with your ideas (email scott.vanderhart@iowa.gov).
Data Assets
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 |
|---|---|
| Datasets | 289 |
| Geospatial Datasets | 154 |
| External References | 156 |
| Documents | 260 |
| Filtered Views | 256 |
| Charts | 144 |
| Maps | 56 |
| Measures | 65 |
| Stories/Dashboards | 6 |
| DataLens Pages | 15 |
| Total Assets | 1,401 |
View All Executive Branch/Non-Elected Agency Public Data Asset Counts
Browse the Public Catalog on data.iowa.gov
New Public Assets
The following are public datasets, external resources, geospatial data, stories and documents that were recently created and published:
- Annual Personal Income for State of Iowa by County (Dataset)
- Quarterly Personal Income for State of Iowa (Dataset)
Portal Users
Total User Accounts: 131
Active Users: 26 (19.8% of total)
Note: Active Users have logged in the data portal at least once in the past month.
Data Plan
The State Data Plan identifies actions Executive Branch State Agencies (non-elected) intend to implement.
Access the State Data Plan on dom.iowa.gov
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 | Transparency
|
|---|---|
| Fiscal Year | 2020
|
| Topic(s) | Data Snapshot
|