All products
Power BI for planners

Power BI Starter Kit

Turn a P6 XER export into a progress dashboard in under an hour.

Instant download · Secure checkout with Payhip · Single-user licence

8 sample tablesXER Power QueryDAX measure library
Cover of Power BI Starter Kit
Look inside

See the real pages before you buy.

5 pages and screens from the product itself. Click any page to read it at full size.

What you get

In the download.

Every file, ready to use.

Sample data

Eight CSV tables and an Excel workbook to build with straight away.

Power Query (M)

Functions that read activity and relationship tables from XER files.

DAX measures

Progress, SPI, performance factor and more, with calculated columns.

Theme and background

A report theme and a 1920×1080 background.

Build guide

Step-by-step instructions with a preview of the finished dashboard.

Contents

Everything that is inside.

The full table of contents, so you know exactly what you are buying.

Files19
  1. Power_BI_Starter_Kit_Build_Guide.pdf
  2. 01_Sample_Data/Planning_Dashboard_Sample_Data.xlsx
  3. 01_Sample_Data/dim_Activity.csv
  4. 01_Sample_Data/dim_Area.csv
  5. 01_Sample_Data/dim_Budget.csv
  6. 01_Sample_Data/dim_Date.csv
  7. 01_Sample_Data/dim_Discipline.csv
  8. 01_Sample_Data/fact_Manpower.csv
  9. 01_Sample_Data/fact_ProgressWeekly.csv
  10. 01_Sample_Data/fact_TestPacks.csv
  11. 02_Power_Query_M/Activities_from_XER.pq
  12. 02_Power_Query_M/Progress_from_Excel_tracker.pq
  13. 02_Power_Query_M/Relationships_from_XER.pq
  14. 02_Power_Query_M/fnXerTable.pq
  15. 03_DAX_Measures/Calculated_Columns.dax
  16. 03_DAX_Measures/Measures.dax
  17. 04_Theme_and_Background/Background_Industrial_1920x1080.png
  18. 04_Theme_and_Background/PPC_Industrial_Theme.json
  19. 05_Dashboard_Preview/Dashboard_Preview.png
Who it is for

Made for working planners.

Save 30%

Also in the Complete Bundle

Power BI Starter Kit comes with the book, the schedule library, the trackers, the Power BI kit and the interview bank for $129 instead of $185.

See the bundle →
Questions

Before you buy.

What format is it?

Digital files: PDF guides, and Excel, Word or PowerPoint files where the product includes them. You get a download link straight after checkout, and by email.

Can I use it at work?

Yes. The single-user licence covers your own work, including on your employer's and your clients' projects. For a team licence, contact us through the Payhip store.

Which software do I need?

A PDF reader for the guides. Excel, Word or PowerPoint (or compatible software) for the templates. Primavera P6 or Microsoft Project for schedule files.

Is the sample data real?

No. All sample projects, names, dates and figures are fictitious and are there to show how each file works.

You may also need

Related products.

KitNew

Monthly Progress Report Kit

A Word report, a PowerPoint management summary and an Excel workbook that feed each other, so the monthly report takes hours, not days.

$25Look inside →
Tool

Excel Planning Trackers

Six ready-to-use workbooks, built the way project controls teams work. Formulas only, no macros.

$29Look inside →
Bundle

The Complete Bundle

The Complete Guide and the five core tools in one download: the book, P6 schedule library, Excel trackers, Power BI kit and interview bank.

$129Look inside →
Power BI Starter Kit

Ready when you are.

$29 Power BI Starter KitBuy now