Case Study 017. Harlem Link Data Suite - Academics: 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 - Academics: Step 1

Harlem Link Data Suite - Academics: 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.

Read More

Case Study 017. Harlem Link Data Suite - Academics: 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 - Academics: Step 2

Harlem Link Data Suite - Academics: 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.

Read More

Case Study 017. Harlem Link Data Suite - Academics: 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 - Academics: Step 3

Harlem Link Data Suite - Academics: 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.

Read More

Case Study 017. Harlem Link Data Suite - Academics: 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 - Academics: Step 4

Harlem Link Data Suite - Academics: 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.

Read More

Case Study 017. Harlem Link Data Suite - Academics: 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 review the data prior to their team meetings and arrive prepared to contribute to the group discussion.

Harlem Link Data Suite - Academics: Step 5

Harlem Link Data Suite - Academics: 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 review the data prior to their team meetings and arrive prepared to contribute to the group discussion.

Read More

Case Study 016. Harlem Link Data Suite - Social Emotional Learning: Step 1

Step 1 - Discovery

To begin the process of creating the data report, 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 final report and what raw data needed to be gathered.

Harlem Link Data Suite - Social Emotional Learning: Step 1

Harlem Link Data Suite - Social Emotional Learning: Step 1

Step 1 - Discovery

To begin the process of creating the data report, 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 final report and what raw data needed to be gathered.

Read More

Case Study 016. Harlem Link Data Suite - Social Emotional Learning: 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 - Social Emotional Learning: Step 2

Harlem Link Data Suite - Social Emotional Learning: 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.

Read More

Case Study 016. Harlem Link Data Suite - Social Emotional Learning: 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 - Social Emotional Learning: Step 3

Harlem Link Data Suite - Social Emotional Learning: 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.

Read More

Case Study 016. Harlem Link Data Suite - Social Emotional Learning: 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 report inside of Data Studio.

Harlem Link Data Suite - Social Emotional Learning: Step 4

Harlem Link Data Suite - Social Emotional Learning: 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 report inside of Data Studio.

Read More

Case Study 016. Harlem Link Data Suite - Social Emotional Learning: Step 5

Step 5 - Publish

I published the finished report to the cloud using Google Data Studio and I shared them with all stakeholders. Since the document was based online, all members of the team could review the data prior to the data meeting and arrive prepared to contribute to the group discussion.

Harlem Link Data Suite - Social Emotional Learning: Step 5

Harlem Link Data Suite - Social Emotional Learning: Step 5

Step 5 - Publish

I published the finished report to the cloud using Google Data Studio and I shared them with all stakeholders. Since the document was based online, all members of the team could review the data prior to the data meeting and arrive prepared to contribute to the group discussion.

Read More

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.

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.

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.

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.

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.

Read More