Project Dashboard Template for Tableau — PMO Status, Budget & On-Time KPIs, Bring Your Own CSV

You point it at your own project CSV; 8 calculated fields surface every overdue task and budget overrun before your sponsor sees the steering deck — the ones a raw…

How it works
  1. Read below what is included.
  2. Open the parts you need directly on this page.
  3. A question? Use the question box at the bottom of the page.

You point it at your own project CSV; 8 calculated fields surface every overdue task and budget overrun before your sponsor sees the steering deck — the ones a raw export hides.

Calculated fields included (8)

Schedule Status

Formula: IF [Status] = "Complete" THEN "Done" ELSEIF [Due Date] < TODAY() THEN "Overdue" ELSE "On Track" END

Uses: Status, Due Date

Completion Rate

Formula: SUM(IF [Status] = "Complete" THEN 1 ELSE 0 END) / COUNT([Task])

Uses: Status, Task

Budget Variance

Formula: SUM([Actual Cost]) - SUM([Budget])

Uses: Actual Cost, Budget

Budget Utilization

Formula: ZN(SUM([Actual Cost])) / SUM([Budget])

Uses: Actual Cost, Budget

On-Time Delivery Rate

Formula: SUM(IF [Finish Date] <= [Due Date] THEN 1 ELSE 0 END) / SUM(IF [Status] = "Complete" THEN 1 ELSE 0 END)

Uses: Finish Date, Due Date, Status

Days Past Due

Formula: IF [Status] = "Complete" THEN 0 ELSE DATEDIFF('day', [Due Date], TODAY()) END

Uses: Status, Due Date

Hours Variance

Formula: SUM([Actual Hours]) - SUM([Planned Hours])

Uses: Actual Hours, Planned Hours

Effort Efficiency

Formula: ZN(SUM([Planned Hours])) / SUM([Actual Hours])

Uses: Planned Hours, Actual Hours

Columns your CSV must have (12)

ColumnTypeRole
Projectstringdimension
Taskstringdimension
Ownerstringdimension
Statusstringdimension
Prioritystringdimension
Start Datedatedimension
Due Datedatedimension
Finish Datedatedimension
Budgetrealmeasure
Actual Costrealmeasure
Planned Hoursrealmeasure
Actual Hoursrealmeasure

CSV header row

Project,Task,Owner,Status,Priority,Start Date,Due Date,Finish Date,Budget,Actual Cost,Planned Hours,Actual Hours

File you connect: project_tasks.csv

Worksheets (5)

Dashboards (1)

Get the full version $69

Your team already pays $14 per user/month for Power BI Pro (Microsoft list price effective 1 April 2025) and it still opens on an empty canvas. Point this at your cost report, your P6/MS Pro

This page is the free working part. The full version is sent to your inbox.

Microsoft's published list price is $14 per user/month for Power BI Pro and $24 per user/month for Premium Per User, both effective 1 April 2025. The licence is already bought — what is missing is the model that sits on it. This t

Send it to me

Need more than this one? ReadyStack Pass opens all 679 files and 561 full versions — $29/month or $199/year. See the Pass →

ENDEJAESPT

Find a tool

Email me this result
A copy of what you see above, in your inbox — the tool stays free, nothing here is locked.

Questions and answers

What does this page do?

You point it at your own project CSV; 8 calculated fields surface every overdue task and budget overrun before your sponsor sees the steering deck — the ones a raw export hides.

Is it free?

The preview on this page is free.

How do I use it?

1. Read below what is included. 2. Open the parts you need directly on this page. 3. A question? Use the question box at the bottom of the page.

Ask about this tool

One question, answered by the person who built it. Your email only if you want the answer sent.

Privacy: your e-mail is used only to send you the answer. A question appears on this page only after it is answered, without your e-mail.

For a team or company: for an invoice with your company details, a quote or several licences, write to [email protected].

More in Planners & spreadsheets See all →