Data Visualizations

Peer Analysis


Interactive dashboard

The 2018 City AFR Data Dashboard allows you to explore the 2018 Annual Financial Report data for all cities in Iowa. The dashboard allows for filtering by map, and graph. This tool is meant to be useful for you to do statewide, regional, and peer to peer comparisons, and explore trends impacting the fiscal health of your community.

The following scenario will be helpful to guide you through the steps. It is intended to be a demonstration of how to use the dashboard and familiarize you with the interactive features. We also recommend that you open the dashboard using the Google Chrome or Mozilla Firefox web browsers. 

  1. Make sure that you see the entire state in your map view, use the zoom out button found at the bottom left corner of the map if necessary.
  2. Click the green bar for the Rural, 500-2,499 category of the Population Category graph. The map will filter to show only cities with a 2018 population between 500-2,499.  In the Population Change 2000-2018 graph, we can now see that there are 228 cities with a population between 500-2,499 people that have had a  population decrease between the years of 2000-2018, and 79 cities with a population increase for the same time period.
  3. Click on the green bar for the Population Increase category. The map will filter to show the cities within the Rural, 500-2,499 population category and have a population increase between 2000-2018.
  4. Using the arrow buttons on your keyboard or your mouse, scroll down on the list of graphs on the right side of the page (make sure your mouse is in that section of the page, and not in the map section). Notice that the green bars are representing the data that you have filtered, and the gray bars are representing the data for all cities.
  5. Scroll to the bottom on the graphs and click on the green bar to the far left in the Capacity graph, and click on the zoom button that appears.
  6. Click and drag your mouse to select a capacity range between 103-249.
  7. Now, scroll back up to the Per-Capita Property Tax Revenue graph. You can see that many of the cities between the 500-2,499 population range with an increasing population and a high fiscal capacity are at the higher end of the per-capita property tax revenue graph. Also, on the map we can see these cities are clustered around the Cedar Falls/Waterloo area, Cedar Rapids/Iowa City area, Quad cities, and the Council Bluffs area.
  8. Zoom in to one of these areas on the map, and click on the point to see the city name. Also, notice that the graphs have again filtered to show only the cities on the map