CSY-015. Cloud-based data reports that put timely information at your fingertips.

PROJECT COMPLETED: October 2019

Harlem Link Data Suite: School Operations | Data Pipeline and Reporting System by David White

THE STORY OF THIS PROJECT

Stakeholder’s Problem: “We need a way to connect the data we have stored in various locations and assemble all of it into a usable form.”

Harlem Link Charter School is a tuition-free, independent charter school located in New York City. It serves 450 children in Pre-Kindergarten through Grade 5. Harlem Link is committed to equitable programming, inclusiveness and serving all children in its community (Harlem and Washington Heights).

The school’s normal daily operations produce a large volume of data that needs to be collected, crunched and reported on in real time. In order to meet that challenge, I took the following steps:

Featured
Case Study 015. Harlem Link Data Suite - School Operations: Step 1
CSY-015., Harlem Link Charter School
CSY-015., Harlem Link Charter School

Step 1 - Discovery

To begin the process of creating the data reports, I met with the school’s teachers and administrators. I listened to the concerns they had and the challenges they were facing. I began to form an idea of what information needed to be included in the data reports and what raw data needed to be gathered.

CSY-015., Harlem Link Charter School
Case Study 015. Harlem Link Data Suite - School Operations: Step 2
CSY-015., Harlem Link Charter School
CSY-015., Harlem Link Charter School

Step 2 - Sketch

Next, I made a rough sketch of what the reports would look like and what information would go where on the screen.

CSY-015., Harlem Link Charter School
Case Study 015. Harlem Link Data Suite - School Operations: Step 3
CSY-015., Harlem Link Charter School
CSY-015., Harlem Link Charter School

Step 3 - Prep Data

To complete this step, I took the following actions:

  1. I identified exactly what data needed to be displayed.

  2. I identified sources for each of those data points.

  3. I exported that data from school information systems (or requested a data export from an outside source).

  4. I cleaned up and organized the data exports.

  5. I compiled the data into Google Sheets.

CSY-015., Harlem Link Charter School
Case Study 015. Harlem Link Data Suite - School Operations: Step 4
CSY-015., Harlem Link Charter School
CSY-015., Harlem Link Charter School

Step 4 - Build

Next, I took the Google Sheets datasources I’d just compiled and I connected them to Google Data Studio. I began to build out the reports inside of Data Studio.

CSY-015., Harlem Link Charter School
Case Study 015. Harlem Link Data Suite - School Operations: Step 5
CSY-015., Harlem Link Charter School
CSY-015., Harlem Link Charter School

Step 5 - Publish

I published the finished reports to the cloud using Google Data Studio and I shared them with all stakeholders. Since the documents were based online, all members of the team could access them throughout the day whenever they needed to.

CSY-015., Harlem Link Charter School

Final Results:

—HARLEM LINK DATA SUITE: OPERATIONS—

2CSY-015 Hero-Image Mockup-HL-Data-Suite-Operations-72dpi.jpg
 
case studies, data visualizationDavid WhiteJazzfuel.com, dashboard, Google Data Studio

3. Work Samples - Content | Work samples of data visualizations, data dashboards, websites, infographics, publication-quality reports, slide decks and visual presentations I've created (detailed)