Skip to main content
MDI · Project Analytics

Project Analytics

By the time a delay shows up in the project status report, you're already three weeks behind. The data to catch it earlier exists — it's just not being used in real time.

What we hear from operators

The problems we solve

01

Portfolio visibility requires a day of manual consolidation

Project managers each maintain their own status in their own format — some in MS Project, some in Smartsheet, some in spreadsheets. The PMO spends every Monday morning copying and pasting into a portfolio template. The consolidated view is outdated before it's finished. Executive dashboards show a picture of last week, presented as if it were today.

02

Schedule slippage is reported after it's happened

The Gantt shows red when tasks are late. It doesn't show amber when tasks are tracking late — when the resource loading says the timeline isn't achievable, when the critical path dependencies haven't started. Early warning requires looking at leading indicators, not just completion dates.

03

Resource allocation is managed by who shouts loudest

Most project-driven organisations we work with don't have live visibility of resource utilisation across the portfolio. Project managers fight for resources based on relationships and urgency. The result is critical projects under-resourced while lower-priority work absorbs available capacity.

Who this is for

Who project analytics is built for

The roles that feel the problem first — and what we build for each of them.

PMO / Project Director

The problem

Every Monday morning is spent copying MS Project, Smartsheet and spreadsheets into a portfolio template that is outdated before it is finished.

What we build

An automated portfolio model in Microsoft Fabric feeding a RAG-status dashboard in Power BI, refreshed overnight through Power Automate.

Portfolio status refreshed overnight, not compiled by hand

Commercial Manager

The problem

The Gantt shows red only after a task is late. There is no amber warning when resource loading says the timeline is no longer achievable.

What we build

A three-week lookahead and risk-weighted EAC in Power BI over Microsoft Fabric, flagging milestones at risk on current progress velocity.

3-week lookahead alerts before milestones slip

Operations Director

The problem

Resource allocation is managed by whoever shouts loudest, with no live view of utilisation across the portfolio — so critical projects run under-resourced.

What we build

A live utilisation dashboard by team and project in Power BI, drawing from Jira and MS Project through the Microsoft Fabric portfolio model.

Over-allocation resolved before it hits delivery

CFO / Financial Controller

The problem

There is no risk-weighted view of portfolio cost and timeline — the board sees last week's status presented as though it were today.

What we build

Risk-weighted cost and timeline forecasting in Power BI on Microsoft Fabric, refreshed from the source systems rather than manually compiled.

Board sees a live portfolio, not a week-old snapshot

Measurable outcomes

What changes after implementation

Specific shifts from delivered project analytics work — the before, and the after.

Portfolio status compilation: 1 day manual → automated overnight refresh

PMO teams get Monday morning portfolio views without spending Monday morning building them. Project data feeds automatically from the source systems.

Schedule early warning: retrospective reporting → 3-week lookahead alerts

Projects flagged as at-risk before milestones are missed, not after. PMO intervention happens when it can still make a difference.

Resource visibility: anecdotal → live utilisation dashboard by team and project

Resource allocation decisions made from data. Over-allocation identified and resolved before it impacts delivery.

By market

Project Analytics — market-specific pages

Each page below covers what project analytics looks like specifically in that market — the local ERP landscape, compliance context, and the operational patterns we actually see there.

Technology stack

Microsoft ProjectPrimavera P6SmartsheetJiraMicrosoft FabricPower BIPower AutomateSharePointAzure DevOps

Start with a conversation, not a proposal

First call is 30 minutes with Amit. We ask about your systems, your team, and your most pressing operational problem. You get a clear view of where the gap is and what closing it looks like. No slides. No pitch deck. No obligation to proceed.