PPM reporting

A project portfolio dashboard that scores every project from the data

Read-only access to your PM tool, plus the spreadsheets finance already keeps. One screen for portfolio health that refreshes itself.

  • Your PM tool (Jira, Asana, Monday, Smartsheet and others)
  • Excel and SharePoint
  • Power BI or a dashboard of your own
Project portfolio dashboard showing portfolio health, spend against plan, and a project table where the owner reported green and the data shows red
Sample dataOne screen for leadership, with a portfolio health score for every project.

Where it starts

A spreadsheet, updated once a month

At one large national distributor, the leadership dashboard ran on Power BI over a shared spreadsheet, and it was only updated once a month. Each project's RAG status was whatever its owner chose. More on monthly reports built by hand.

Before: project owners type status into a shared spreadsheet, someone rebuilds the Power BI report, leadership sees owner-picked RAG colors. After: the PM tool and finance spreadsheets refresh nightly into a portfolio health score and a leadership dashboard
Empty conference room with a long white table and a wall screen

Photo: Craig Lovelidge on Unsplash.

From our calls

None of us are Power BI gurus.

Branch operations director at an MRO and renovation distributor, August 2026 call

Where the numbers live

  • Your PM tool
  • Excel and SharePoint
  • Power BI
  • ERP
  • HR system

Portfolio health

Three signals, one score

Schedule variance, burn rate and blockers combine into one portfolio health score of 48 out of 100, shown next to the green the owner reported

The rules are written down and the same for every project, so two owners with the same numbers get the same RAG status.

Reported vs. data

When the owner and the data disagree

The dashboard shows both: the status the owner reported and the status the data supports. Leadership sees the gap and asks about it. Nothing gets overwritten.

Status review board with what each owner reported on the left and what the PM tool and the budget show on the right, with gaps flagged

Buy or build

An add-on or a build?

Comparison: a PM tool add-on is enough when everything lives in one system, a build makes sense when the numbers live in the PM tool, spreadsheets, an ERP and an HR system

Questions

Common questions

Can our PM tool make a portfolio dashboard on its own?

Most PM tools show their own data. When leadership also needs budget or headcount from spreadsheets or other systems, that has to be joined in somewhere else.

Do we need a separate PPM suite?

Not for this. The dashboard reads the projects you already keep in your PM tool.

What access do you need?

Read-only access to your PM tool and read access to the spreadsheets that feed the report.

Where does it run?

In your own environment. It reads from your PM tool with read-only access.

Talk to us about your dashboard

If your PMO report still starts with someone updating a spreadsheet, we'd like to hear how it works today.

You work directly with Scott Hanson, who scopes the first version with your team and builds it. Based in Austin.