Skip to content

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.

Read the case study

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.

Book a meeting

A handful of key metrics on one screen, with departmental figures underneath

Discuss your key metrics

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

  1. 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.

  2. Define the metrics

    Document the calculation and source for each metric, checking the figures with the department that currently reports them.

  3. 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?

Talk it through with us

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.

Book an introductory meeting

The latest management team meeting is a good starting point for our first conversation

Stef Stoelwinder

Stef Stoelwinder

Business Development

Stef 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.

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.

Enter a valid email address.

Let us know how we can help you.

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.