Skip to content
All projects

Management Dashboard in Power BI

An executive dashboard requested by management: the headline numbers, monthly trends, sales split and a regional view on one Power BI page, with slicers for period and region.

Dec 2024Client: Healthcare servicesPower BIData modelingDAX measures
Client work. The client’s files and figures are private: the screen on this page is an original illustration with invented data.

1Problem

Management needed one place to follow performance. The numbers existed, but reaching them meant opening several reports and asking for an update each time a question came up.

2Data

  • The questions management asks every month, agreed before any design work.
  • The client’s brand colors and layout preferences.
  • Client data stays private. The illustration on this page uses invented figures.

3Approach

  1. 01Agreed the questions the dashboard must answer on a single page.
  2. 02Built the data model and wrote the measures for sales, cost, profit and units.
  3. 03Designed the page in the client’s brand palette: headline cards first, trends next, breakdowns last.
  4. 04Added slicers so management can move between periods and regions without asking for a new report.
  5. 05Reviewed the page with management and refined it.

4What was built

  • Headline cards: sales, profit and units
  • Best month callouts for sales and cost
  • Monthly sales and cost trends
  • Sales split by channel and by product group
  • Regional table with totals
  • Period and region slicers

5Result

  • Management follows performance from one page instead of several reports.
  • Questions about a period or a region are answered with a click.
  • A consistent, branded view that is ready for management meetings.
Chat on WhatsApp