Skip to content

Project dashboard in Power BI

We compare hours, costs and progress for each project against the budget in a single Power BI model. For Agro Care, we built a data platform that feeds BI.

For Agro Care, we’re building a data platform that stores all data in one place and makes it available for BI

Agro Care wanted a scalable, stable data environment. We’re building a data platform with a data warehouse, bringing all data together and making it easy to access for BI and data science.

Read the case study

Which project is overrunning, and do we only spot it once the invoice has been sent?

Hours are in the time-tracking system, costs and invoices in the accounting system, and the schedule in another tool. A project dashboard shows them alongside the budget for each project, so the project manager can make adjustments while work is under way, not afterwards.

Book a meeting

See hours, costs, progress and margin for each project in one view

Discuss your project figures

Budget versus actuals

Budgeted hours and costs for each phase alongside what has been recorded to date, with the projected total at completion.

Work in progress

Work completed but not yet invoiced, by project and client, so finance and project managers see the same figure.

Capacity across projects

Who is assigned to each project and how many hours each team has available in the coming period.

One source for all reports

As we do for Agro Care by storing data centrally for BI, we bring hours, costs and planning together in one place.

Projects get a single definition before any charts are created

  1. What counts as a project

    Align project numbers, phases and budgets across all sources, with agreed rules for additional and omitted work.

  2. First projects checked

    Check the figures for a handful of ongoing projects with the project managers until the dashboard matches their own records.

  3. All projects and ongoing management

    The entire portfolio in the model, access permissions for each project manager, and a fixed refresh schedule with someone responsible for it.

Do we need our own project dashboard, or is our project management software enough?

Talk it through with us

A good fit if

Hours, costs and schedules sit in different systems, you want to compare projects across offices or companies, or the finance team and project managers each work from their own list.

Not a good fit if

All your projects run in one system with good standard reports, and no one needs to compare projects. In that case, your own model adds little.

What determines the scope

How many sources are involved, how budgets are currently recorded, whether you need historical data from completed projects, and who will manage the model.

What if project managers record things differently?

That’s the most common reason people don’t trust a dashboard. So we first agree together how hours and costs are assigned to project phases, then show where they’re still recorded differently.

Reports in the project software, an Excel overview or a Power BI model?

Reports in the software

Choose this if all your project data is in one software package and its standard reports answer your questions. You won’t need a separate place for reporting.

An Excel overview

Choose this if you have only a few projects and one person maintains the overview. Each reporting period, copying and checking the figures remains manual work.

A Power BI model

Choose this if you need to bring together data from multiple sources or companies. Our advice: record budget and actuals by phase and refresh the data daily.

Bringing separate systems together in one place for BI is what we do every day

Data Science Lab has been building data platforms, models and dashboards since 2016, as a Microsoft Partner and Databricks Partner. For Agro Care, we’re building a data platform with a data warehouse.

Book an introductory meeting

The first conversation starts with the projects now slipping out of sight

Stef Stoelwinder

Stef Stoelwinder

Business Development

Stef is your point of contact. In our first conversation, we’ll discuss your project portfolios, how budgets are currently committed and what your project managers are missing.

Which systems do you currently use to track hours, costs and schedules?

Tell us how many projects are running at the same time and where the data is stored. We’ll reply by email or arrange an initial meeting.

Enter a valid email address.

Let us know how we can help you.

Frequently asked questions

For each project, it shows budgeted and recorded hours and costs, progress by phase or milestone, what has been invoiced and what remains in progress, and the expected margin. It also gives you an overview of all projects, so you can see which ones need attention.

For more on why every dashboard starts with the decision someone needs to make using it, see Power BI dashboards.

Usually, the data comes from time tracking, financial accounts or an ERP system, a planning tool and sometimes a CRM for the contract value. Each system has its own project number or code. The work lies in matching those codes so that a project is identified consistently across all systems.

The options for accessing the data differ by supplier; we check this for each source.

By adding an estimate of the remaining work to what has already been recorded. The estimate can be entered by the project manager or calculated from progress to date. You can show both side by side to see the difference.

We agree on the calculation method in advance and show it on the dashboard, so no one misreads the figure.

An approved change gets its own dated entry, so the original budget remains visible alongside the current one. This lets you see whether a project is running over budget or the scope of the work has grown.

Without that agreement, a project can appear on track even though the budget has quietly been increased.

A financial dashboard looks at the organisation as a whole: revenue, margin, cash flow and budget by cost centre. A project dashboard looks at individual assignments, helping project managers adjust course.

Both often use the same financial records. Putting them in one model prevents them from showing different figures.

Yes, if the schedule records who is assigned to each project. You can then see planned hours against available hours for each team. Leave and absence usually come from HR; you can read more about this under HR dashboard.

We set role-based permissions to control who can see each person's data.

Usually daily, sometimes more often if project managers need to make adjustments during the day. We save a snapshot of closed periods so that last month's figures do not change unnoticed.

We configure refreshes, the gateway and permissions as described under Power BI consultant.

If hours and costs are not yet recorded by project or phase. In that case, the dashboard will mainly show what is missing, and data quality is the first step. If you have only a few projects a year in a single system, a separate model is often unnecessary. We will tell you when that is the case. If you track projects by client in SuperOffice, take a look at the SuperOffice Power BI dashboard.