Pivot tables, charts and the one-page dashboard

Module 04 / 5 · 65 min

Summarize the clean data with pivot tables, choose honest charts and lay out a one-page branch dashboard that has been checked against the books.

In this module you will learn to

Build pivot tables that summarize deposits, loans and channel activity
Choose and calculate the few KPIs that answer the manager's questions
Select the right chart for a comparison, a trend or a share
Lay out a one-page dashboard and reconcile it to the general ledger before sharing

Built on

Erudite Africa course specification: 4.e Data Analytics and Digital Literacy, Level 1 (October 2026)
Erudite Africa: Training Module, Ethiopian Context, programme overview and regulatory register (October 2026)
NBE directives as listed in the lessons: SBB/87/2024, SBB/90/2024, SBB/95/2025; FCP/01/2020 and CRB/02/2019 (as reported)
Personal Data Protection Proclamation No. 1321/2024, Electronic Transaction Proclamation No. 1205/2020, Computer Crime Proclamation No. 958/2016 and National ID Proclamation No. 1284/2023 (as reported)
Course worked example: the fictional Hawassa Tabor branch data set

Examples and organizations are fictional. Apply your own organization's approved policies.