Jefferson County (CO.) Public Schools - Jeffco Public Schools is the largest school district in Colorado with more than 84,000 students and approximately 12,000 employees.

As with most school districts, Jeffco is required to submit yearly statistical reports to the Colorado Department of Education (CDE) that tracks the population breakdown of each school. There are over 200 Human Resource data elements and definitions that need to be tracked.

Problem: The Jeffco Human Resources department needed an easy way to view statistics based on a specific school. By default, the data returned from the CDE is contained within an Excel Spreadsheet that contained over 25,000 rows.

Solution: I built a "Dashboard" front end that allows users to display data in an easy to read format. Users can select a specific school or sort schools by type. To see a sample of data returned for a single school, go here. Please note that the data presented is not factual.