Leadership Dashboard

Project Overview

Challenge

In support of a global change management initiative, my organization (made up of 45 international teams) needed to report key product development metrics weekly. Originally managed through shared Excel spreadsheets, the manual process quickly became overwhelming, error prone, and unsustainable as both scale and complexity grew.

Goal

Design a scalable, automated dashboard for leadership to view team metrics, eliminate reporting inefficiencies, and enable data driven decisions across a global transformation program.

Role: Project Owner

Team: Design, Data Science, Data Engineering, Product Management

Tools: Excel, Tableau, SQL, Miro, Confluence, Figma

Background

At first reporting was manageable. A small number of teams and a simple Excel form. But as the pilot grew, so did:

• Data complexity: More KPIs, across more domains

• Cognitive load: Stakeholders struggled to extract insights from dense reports

• Time drain: Manual entry and formatting pulled time away from core work

  
  

I validated this pain point by reaching out to peers in other departments and discovered it was a company wide issue affecting multiple organization.

Discovery

I initiated a self driven discovery phase by:

• Interviewing other organization leaders handling similar reports

• Auditing reporting workflows to map out inefficiencies

• Meeting with internal data teams to understand source systems and reporting gaps

Analysis

• Reporting requirements weren’t standardized

• Leaders needed quick glance visibility, not raw spreadsheets

• Leadership wanted the ability to compare trends across time and teams

Solution

A dashboard that would automate and centralize weekly reports and provide visualizations of the transformation program's progress.

Design Priorities:

• Clean, accessible visualizations

• Drill down capabilities by team or organization

• Exportable views for executive presentations

• Scalable layout that could grow with added metrics

Delivery

• Partnered with data engineers to integrate backend data sources

• Designed the user interface and interaction model of the dashboard, focusing on usability for non technical leadership

• Aligned the dashboard to reflect common workflows and KPIs across orgs

• Worked iteratively, running weekly reviews with leadership and data teams

Impact & Outcomes

After rollout and adoption by my organization:

• Leadership reported major time savings and improved clarity in decision making

• The dashboard was scaled to 15 additional organizations impacting 6,000+ employees globally

• Reduced reporting effort from hours to minutes weekly

• Enabled data consistency across pilot teams and central leadership

• What started as a solution for one organization became a company wide standard

Reflection

This project taught me that great design isn't just about the interface, it is about reducing friction and enabling momentum at scale.

• I learned to bridge design with data, making abstract information actionable

• Built trust with cross functional teams through iterative communication and transparency

• Demonstrated how design thinking could drive process innovation, not just product design