GCCS Dashboard | Interactive Data Dashboard by David White
Global Community Charter School needed a data dashboard in order to comply with state regulations and to facilitate board governance and oversight.
I created the following data presentation to address the school’s needs:
Key Features & Benefits:
Critical information from several different sources is gathered in one place and presented here clearly and succinctly.
The dashboard is accessible online. This allows stakeholders who are off-site to access needed school information quickly and easily.
In order to prepare the materials needed for this project, I completed the following steps:
☑ Talked to board members and school leaders in order to gain a clear understanding of their needs and concerns
☑ Gathered raw data in.csv format from the school information system (SIS) and other sources
☑ Checked the raw data for errors and inconsistencies; wrangled the data into a consistent and uniform tidy data format
☑ Applied calculations and array formulas to the data set in order to calculate totals and averages by category
☑ Drew insights and initial conclusions from the calculations in an effort to inform and shape the design of the final data presentation
Having gathered and edited all needed materials, I then used Tableau software to create a suite of data visualizations which I then organized into a comprehensive data dashboard. I maintained the dashboard and updated it monthly. It was presented at each meeting of the school’s board of trustees and was used by the board to facilitate conversations with school leaders and to inform their decision-making in regard to school governance.