GCCS Dashboard | Interactive Data Dashboard by David White

GCCS-exterior-opt (1 of 1).jpg

The Client

Global Community Charter School (GCCS) is an independent, inquiry-based public charter school located in Harlem, NY. GCCS serves 450 students in Kindergarten through 5th Grade.

The Problem

Global Community Charter School needed a data dashboard in order to comply with state regulations and to facilitate board governance and oversight.

The Solution

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.


The Process

Preparation

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

Execution

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.

Testimonials from stakeholders at Global Community Charter School: