← Case Studies Business intelligence

Dashboard for tracking Learning hours

Built a Dashboard for the People Managers to track their direct and in-direct reportees Learning hours

At a glance

  1. 01 Problem

    People Managers had no quick way to see learning hours across their direct and indirect reportees.

  2. 02 Constraint

    Built for managers without advanced filtering skills, and with limited data resources available.

  3. 03 Approach

    A Power BI dashboard that aggregates across reporting layers, shows monthly progress, and flags teams behind target.

  4. 04 Outcome

    Managers can spot lagging teams at a glance instead of filtering and interpreting manual reports.

Overview

Organizations often encourage employees to complete a minimum number of learning hours every month. However, tracking this across multiple teams can become difficult, especially when managers must monitor both direct and indirect reportees.

To solve this, I built a Power BI dashboard that allows People Managers to track learning hours across their teams and identify performance gaps quickly.

The dashboard provides clear monthly insights, team comparisons, and an easy-to-use interface, enabling managers to make data-driven decisions without needing advanced reporting skills.


Problem

People Managers needed a way to:

  • Track learning hours completed by employees
  • Monitor both direct and indirect reportees
  • Identify teams falling behind the target learning hours
  • View insights without needing to use complex filters or manual reports

Existing reports required manual filtering and interpretation, which made it difficult for managers to quickly understand the performance of their teams.


Solution

I designed and implemented an interactive Power BI dashboard that simplifies learning analytics for managers.

The dashboard provides:

  • Monthly learning hour tracking
  • Team-level performance comparison
  • Identification of teams lagging behind targets
  • Interactive visuals for quick insights

The design focused on usability and clarity, allowing managers to navigate insights even without experience using advanced filters or analytics tools.


Key Features

1. Team Learning Performance Monitoring

Managers can instantly see which teams are meeting the learning hour targets and which ones are falling behind.

2. Direct & Indirect Reportee Tracking

The dashboard aggregates data across multiple reporting layers, making it easier for senior managers to monitor their entire hierarchy.

3. Monthly Insights

Provides a clear view of monthly progress and performance trends, enabling managers to take corrective action early.

4. User-Friendly Interface

The UI was designed so that managers can:

  • Interact with visual elements
  • Gain insights without using advanced filters
  • Quickly understand performance metrics

5. Resource Optimized Design

Despite working with limited data resources, the dashboard was optimized to produce high-quality insights and clear visualizations.


Technologies & Tools

  • Power BI – Dashboard creation and data visualization
  • Power Query – Data transformation and cleaning
  • Microsoft Excel – Data source and preprocessing

Impact

This dashboard helped managers:

  • Quickly identify teams lagging behind learning targets
  • Improve visibility of employee learning progress
  • Reduce the need for manual report analysis
  • Make faster, data-driven decisions

Recognition

This dashboard won a Vodafone Stars Award (July 2025), recognising the Learning Hours dashboard for HR Services and its people-manager-level views for service leads.


Key Skills Demonstrated

  • Business Intelligence Dashboard Design
  • Data Transformation with Power Query
  • Data Visualization & Reporting
  • Stakeholder-Oriented UI Design
  • Insight Generation from Limited Data Sources