Management dashboard in Power BI
We define each key metric, assign it an owner and bring them together in a single Power BI view. For Ammega, we built dashboards and an app.
We developed Power BI dashboards and a Power BI app for management, planning and finance at Ammega
Working closely with stakeholders across the organisation, we developed dashboards tailored to each department’s information needs, bringing everything together in one Power BI app.
Why does each department bring a different figure to the management team?
Finance, sales and operations each report from their own systems, using their own definitions. A management dashboard brings key metrics together in one place, with a shared definition, so discussions focus on decisions rather than figures.
A handful of key metrics on one screen, with departmental figures underneath
One definition per KPI
For each key metric, the calculation, source and owner are clearly defined.
Drill down to department figures
Go from the overview to the figures for finance, sales or operations without opening another report.
Everything in one app
For Ammega, we brought management, planning and finance dashboards together in a Power BI app.
Targets alongside actuals
See the target and trend for each key metric, so you can spot deviations before the quarter ends.
First, we work with the management team to decide which figures matter
-
Choose key metrics
Work with senior leadership and the management team to identify the decisions that guide the organisation, with one metric and one owner for each decision.
-
Define the metrics
Document the calculation and source for each metric, checking the figures with the department that currently reports them.
-
Overview and routine
Use the dashboard in management team meetings, with a set refresh schedule and someone responsible for the model.
How many KPIs belong on a management dashboard?
A good fit if
The management team receives figures from several departments and systems, there is debate about which figures are correct, and someone puts together a summary each month.
Not a good fit if
All the key metrics come from one system and its standard report is sufficient. In that case, building your own model would take more work than it is worth.
What determines the scope
How many sources are involved, how much the definitions currently differ, whether each department has its own targets, and who will manage the model afterwards.
Won’t it become one big screen full of charts?
Not if we choose what to show in advance. The overview contains only the figures the management team uses to make decisions; the rest is one click away in each department’s section.
A monthly report, separate departmental dashboards or one KPI dashboard for the management team?
A monthly report
Choose this if the management team makes decisions once a month and the figures come from a single source. A standard report is clear enough in that case.
Separate departmental dashboards
Choose this if each department mainly manages its own performance. The management team then looks at each department separately, with the risk of differing definitions.
One KPI dashboard
Choose this if the management team makes decisions across departments. Our advice: start with a handful of metrics and only add more when someone uses them to make a decision.
We build management overviews around the needs of the departments that report to them
Data Science Lab has been building data platforms and dashboards since 2016, as a Microsoft Partner and Databricks Partner. For Ammega, we developed Power BI dashboards for management, planning and finance.

The latest management team meeting is a good starting point for our first conversation
Stef Stoelwinder
Business DevelopmentStef is your point of contact. In our first conversation, we’ll discuss what guides the management team’s decisions and where the figures currently come from.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
Which metrics does your management team want to use to guide decisions?
Tell us which departments and systems you have and how you currently put together the management overview. We’ll reply by email or arrange an initial conversation.
Message sent
Thanks for your message. We’ll be in touch as soon as possible.
Frequently asked questions
A single overview of the figures that senior leadership and the management team use to make decisions, bringing together data from every department. Each figure shows its definition, target and trend, and you can click through to the department’s figures.
Read how we start every dashboard with a decision in mind on our Power BI dashboards page.
Often, there is none: both show the figures used to guide decisions. We use management dashboard for the management team’s overview across departments. A KPI dashboard can also serve a single team or department.
For Fokker Services Group, we built a central application with all the key KPIs, at every level of the organisation.
The management team decides that, not us. Typically, it includes a few from finance, such as revenue and margin, as well as sales, operations and HR. The question for each figure is: what decision will we make if it deviates from the target?
For the underlying financial detail, read about the financial dashboard.
From the systems the departments already use: accounting, CRM, ERP, planning and HR. We bring the data together in one data model, so each figure is calculated only once.
For the sales and HR detail, read about the sales dashboard and the HR dashboard.
By agreeing on the definitions together and building departmental reports on the same model. That way, the figure seen by the management team and the department comes from the same calculation.
Anyone who wants to change a definition does so through the person responsible for that figure.
Yes. Power BI has a mobile app, and we can create a separate mobile view showing only the most important figures. The same access permissions apply as on a laptop.
Read how we set up and secure Power BI on our Power BI consultant page.
As often as the management team needs them and the source systems allow. For a weekly meeting, a daily refresh is enough; operational figures may need refreshing more often.
The dashboard always shows when the data was last updated.
When the source systems are not yet in order and every figure first needs manual correction. In that case, data quality is the first step.
If the management team does not yet know which figures it wants to use to guide decisions, we would also rather start with that conversation.