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
Sales dashboardIllustration
Sales4.8M
Profit1.6M
Units132k
AllQ1Q2Q3
Sales by month
By channel
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
- 01Agreed the questions the dashboard must answer on a single page.
- 02Built the data model and wrote the measures for sales, cost, profit and units.
- 03Designed the page in the client’s brand palette: headline cards first, trends next, breakdowns last.
- 04Added slicers so management can move between periods and regions without asking for a new report.
- 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.
