Colorado School District Visualization – Dashboard

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

Using the data from The Colorado Department of Education here are some demographic visualizations built using InfoCaptor dashboard

In this dashboard, we just use the enrollment data and try to extract some key observations.

We will build a series of dashboards and try to see if there are any patterns emerging.

Here is the link to the Dashboard

https://my.infocaptor.com/dash/mt.php?pa=rename_new_50ecb02915527

Image

The first graphic is a simple bar chart showing the highly populated school districts in descending order.

The bar chart queries the excel file and dynamically generates the total student population for each school district and then selects only the top 20 in the list. The reason we limit to 20 is because it is not possible to visualize all the school districts at once.

When you click on any school district bar, the pie chart drill down will show the ethnicity split percentage for each school district.

NOTE: The data is available at the school level but we are just showing information at a higher level. If it makes sense we can build a similar dashboard at the school level.

The pie chart shows the student population split for American Indian, White, Black, Asian, Hispanic, Pacific Islander and other ethnicity students.

Image

The green bar chart shows the number of schools for each school district in the first chart.

Image

The third chart shows the student school density (ratio of total students/total schools in that district)

So just by looking at the three charts we quickly see the following points

  • Jefferson County has the highest student population = 86000.
  • Denver County has the highest number of schools = 164
  • Cherry Creek district has the highest student density per school = 907

Now we will try to add more information to our dashboard.

We try to see which school district has the highest population for each ethnicity.

We show them as simple Grids/table list

Image

Based on the above we observe

  1. Jefferson County has the highest student population = 86000.
  2. Denver County has the highest number of schools = 164
  3. Cherry Creek district has the highest student density per school = 907
  4. Montezuma-Cortez Re-1 has the highest American Indian population = 730
  5. Jefferson County has the highest White population = 58295
  6. Denver County has the highest black population = 11452
  7. Cherry Creek has the highest Asian population = 4270
  8. Denver county has the highest hispanic population = 47109
  9. Adams-Aprapahoe has the highest Hawaiian population =178

Custom Reports and Dashboards

We will build you a set of custom reports and dashboards
Best Offer

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH