Case Study 015. Harlem Link Data Suite - School Operations: Step 1

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.

Harlem Link Data Suite - School Operations: Step 1

Harlem Link Data Suite - School Operations: Step 1

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.

↤ BACK TO: Case Study 015. Harlem Link Data Suite: Operations
Read More

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

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.

Harlem Link Data Suite - School Operations: Step 2

Harlem Link Data Suite - School Operations: Step 2

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.

↤ BACK TO: Case Study 015. Harlem Link Data Suite: Operations
Read More

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

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.

Harlem Link Data Suite - School Operations: Step 3

Harlem Link Data Suite - School Operations: Step 3

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.

↤ BACK TO: Case Study 015. Harlem Link Data Suite: Operations
Read More

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

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.

Harlem Link Data Suite - School Operations: Step 4

Harlem Link Data Suite - School Operations: Step 4

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.

↤ BACK TO: Case Study 015. Harlem Link Data Suite: Operations
Read More

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

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.

Harlem Link Data Suite - School Operations: Step 5

Harlem Link Data Suite - School Operations: Step 5

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.

↤ BACK TO: Case Study 015. Harlem Link Data Suite: Operations
Read More