Back to the work
BI

The first executive dashboard

One view across 12 business areas, on a shared data model that every production report uses.

See it working

Open the dashboardA working rebuild with made-up data. The real one is internal.Open

The problem

The company had no executive dashboard. Senior leadership had no single view of the business.

Different departments could report different numbers for the same metric.

What I did

Built the company’s first executive dashboard, covering 12 business areas.

Designed the production data model in SQL and Microsoft Fabric (Microsoft’s data platform), on ERP data, the company’s core business records.

Set standard metric names and shared business definitions, with model documentation that writes itself.

The result

Senior leadership has one view across 12 business areas.

Every production report now uses the shared model, so each metric is defined once.

Conflicting numbers between departments ended.

Tools

  • Power BI
  • DAX
  • SQL Server
  • Microsoft Fabric
  • Star schema modelling
  • Power Query