Wavumbuzi Dashboards ✅

Beginning in the second instance of Wavumbuzi Kenya, with many operational and post-challenge reporting norms now in place, it naturally became a desire to shorten the time-frame between measurement and inspection of data. The next step was to find a solution to live analytics which in-country teams could use to make decisions and sharpen tactics on-the-go. Here was born the era of Wavumbuzi Dashboards.

Among several comparable tools, Google Data Studio became the dashboard tool of choice due to it's user friendliness and ease of integration with the Google Suite.

Over the period leading up to the time of writing this (November 2021) the technical set up and operational use of dashboards evolved significantly, to the point that weekly Team meetings for Wavumbuzi Rwanda 2021 began with a dashboard review and discussion.

Given the technical nature and dependence on visual material of the dashboarding exercise, a screen-recorded video approach has been taken to document:

• Strategic approach Wavumbuzi dashboards

• Technical introduction to the Data Studio tool-suite

• Comprehensive review of existing dashboards and how they are set up and maintained

• Discussions around opportunities for future improvements

• How to custody the Team's usage of dashboards to nurture a culture of data-driven decision making

Video Documentation ✅

These documentation videos simultaneously served the purpose of handover sessions with the AGGP M&E Team, so each video takes the format of a Zoom call in which the documentation process unfolds with instructions and questions being addressed along the way. The series consists of five videos, stored in the M&E folder of the Jasiri Loom Account, and listed below:

Dashboards Handover Session 1

Description: Overview & Registration Snapshot Page

Video Length: 00:46:47

• 00:01:00 Recap of conversation previously had about Dashboard

• 00:03:28 Overview of Dashboard and its Content

• 00:05:39 Looking behind the scenes

• 00:06:24 Explaining the Data Sources

• 00:20:06 Providing clarity on how the submissions log and various entries work

• 00:27:00 Explaining submisions Dashboard

• 00:31:15 Explaining hidden pieces of the registration process and the data collected

• 00:32:57 How the day-to-day teacher registration chart works

• 00:36:34 Other learner counts used on the dashboard

• 00:39:09 Looking at the "Under Construction" timetable

Dashboards Handover Session 2

Description: Engagement Snapshot & DB User Table

Video Length: 01:04:53

• 00:00:09 Recap of previous video

• 00:01:00 Explaining how the Engagement snapshot Dashboard works

• 00:04:44 Explaining chart showing challenge submissions by learners.

• 00:08:11 Explaining the last two graphs in the learner engagement snapshot

• 00:11:30 Taking a deeper look into learner engagement data

• 00:16:27 Deeper look into the data behind the "Challenge Submissions Count" graph

• 00:30:44 Deeper look into the data of the "Learner last login distribution" graph

• 00:35:48 Understanding the user table and its components

Dashboard Handover Session 3

Description: Quests, Schools Leaderboard, SCRs, & Presenting Dashboards to the Team

Video Length: 1:20:37

• 00:00:10 Recap

• 00:03:33 Overview of the Quest Breakdown Dashboard

• 00:06:02 Components within Quest Breakdown Dashboard

• 00:25:59 School Leaderboard Dashboard Breakdown

• 00:49:59 Looking at the School Join Request Dashboard

• 01:12:08 Presentation element of the Dashboard

Dashboard Handover Session 4

Description: Secondary Dashboards & Corresponding Database Tables

Video Length: 01:02:07

• 00:00:27 General Queries about the Dashboard

• 00:29:43 Issue with new schools added on Dashboard data

• 00:32:17 Determining how many challenges a student has completed

• 00:33:50 Attending to issues with system Surveys

Dashboard Handover Session 5

Description: Troubleshooting Data Incongruencies, Q&A, and Data Blending

• Video Length: 00:52:28

• 00:00:10 Recap

• 00:01:41 Issue identified in the Rwanda Dashboard

• 00:12:12 First question by Rafiki about numbers going down

• 00:14:39 Second Question by Rafiki: Issue Identified on Dashboard report vs actual data

• 00:36:21 Rafiki Question on Kenyan Dashboard

• 00:41:50 Rafiki Question related to surveys

• 00:48:15 Rafiki Question on Blending data

Video Documentation Resources ✅

To follow along with (or cross-reference) the dashboards reviewed in the videos above, you may use the following links:

• Kenya 2021 Snapshot Dashboards

• Rwanda 2021 Snapshot Dashboards (note that this dashboard has been under development since the time of writing)

To request edit access to any of the above please contact phumlanin@jasiri.org, allank@jasiri.org, or rafikim@jasiri.org