Advanced Data Analytics in Project Controls using Power BI

Turn Primavera data into
dashboards that drive decisions.

Master Microsoft Power BI for project planning & controls

A hands-on course for project managers, planning engineers and project controls professionals: connect Primavera P6 and Excel, model your data, and publish interactive progress, cost and resource dashboards your managers will actually use.

20 days · computer-based workshopsOnline or classroomP6 · Excel · Power BI
EDGE Project Controls Power BI executive status dashboard built in the course
6Curriculum sections
11Practical techniques
20Days
P6 → BIPrimavera auto-link

Sample Power BI dashboards

The dashboards covered in the course.

Ten report pages from one Power BI model, built on a demo high-rise project with data exported from Primavera P6 and Excel. Choose a page to see it.

Power BI dashboard: Executive Status
Executive StatusContract start and finish, forecast finish, delay, variance and SPI, with planned vs actual gauges, floor-wise progress and the delay trend.
Power BI dashboard: Progress Curve – Manhours
Progress Curve – ManhoursPlanned, actual and early labour units by month, filtered by trade, area and floor.
Power BI dashboard: Progress Curve – Cost
Progress Curve – CostMonthly and cumulative cost % against actual progress, with trade, area and floor slicers.
Power BI dashboard: Activity Progress Trend
Activity Progress TrendMonthly earned value with cumulative actual cost and cumulative earned value.
Power BI dashboard: Earned Value Analysis
Earned Value AnalysisA decomposition tree drilling earned value down through zone, floor, area and trade.
Power BI dashboard: Cost Variance Breakdown
Cost Variance BreakdownA treemap of cost variance by CSI division and building zone.
Power BI dashboard: Delay Trends
Delay TrendsProject delay in days across every data date.
Power BI dashboard: Resource Histogram
Resource HistogramMonthly resources by trade with a date-range slider and resource slicers.
Power BI dashboard: Weightage Distribution
Weightage DistributionCost by CSI division, area, trade and description, and labour units by floor.
Power BI dashboard: 3D View
3D ViewA 3D building model linked to floor-wise progress, alongside contract and forecast dates.

Why Power BI?

A game-changer for data visualisation and analysis.

Power BI is used across projects, programmes, portfolios and entire organisations. It connects large datasets and turns them into interactive, insightful dashboards.

01

Real-world application

Learn how Power BI is used in the construction industry, on project data you recognise.

02

Best practices

Practical, time-saving techniques you can use on Monday morning.

03

Regular updates

Stay ahead with the latest Power BI tools and features.

What you’ll learn

Step by step, on a demo project.

Getting startedDownload and install the free version of Power BI
Your accountCreate an account, even without a company domain
From P6Export project data from Primavera to Excel and bring it into Power BI

Practical, time-saving techniques

01

Data integration

Connect Primavera and Excel with Power BI

02

Power Query

Edit and transform data efficiently

03

DAX & date tables

Build relationships between datasets

04

Cash flow & S-curve

Export and visualise financial data

05

Resource management

Apply Unpivot to organise data in dashboards

06

Filters & relationships

Master filtering techniques and data connections

07

Progress tracking

Display updated schedules and interactive progress images

08

Issue resolution

Solve common Power BI challenges

09

Synoptic panel

Integrate AutoCAD layouts to track project status

10

KPI dashboards

Use key performance indicators for better insight

11

Sharing & collaboration

Publish and share dashboards online with managers

Try it

Click a slicer. Watch the dashboard respond.

This is the kind of interactive filtering you will build in Power BI. Pick a package to filter the KPIs and progress bars.

Package

Planned
31.8%
Actual
28.4%
SPI
0.89
CPI
0.95
Substructure
62%
Superstructure
48%
MEP
30%
Finishes
14%

Sample training data for illustration

Curriculum

Six sections, from installation to auto-linked dashboards.

1Introduction to Power BI DesktopSection 1
  • Installation and set-up of Power BI Desktop
  • Overview of the interface and features
  • Key concepts: reports, dashboards and dataflows
  • Basic navigation and your first Power BI report
2Preparing and adjusting the databaseSection 2
  • Connecting to data sources such as Excel
  • Cleaning and transforming data with Power Query
  • Managing and appending queries
  • Understanding and resolving data quality issues
3Creating and adjusting data models and relationshipsSection 3
  • Why data modelling matters in Power BI
  • Creating relationships between tables
  • Cardinality and cross-filter direction
  • Calculated columns and measures
  • Optimising performance with star schema modelling
4Visualising data with Power BI visualsSection 4
  • Charts, tables, slicers and KPIs
  • Formatting and interactivity
  • Hierarchies and drill-throughs
  • Bookmarks and buttons for navigation
  • Custom visuals from the marketplace
5Case study — building interactive dashboardsSection 5
  • Designing user-friendly layouts and themes
  • Real-time dashboards using streaming data
  • Step-by-step build of an interactive dashboard
  • Analysing data and drawing insights
  • Best practice for sharing with stakeholders
6Publishing online — mobile app, Primavera and Power BI auto-linkSection 6
  • Publishing reports and dashboards to the Power BI Service
  • The Power BI Mobile App for on-the-go analysis
  • Auto-refresh for real-time updates
  • Integrating Primavera data for advanced reporting
  • The Power BI and Primavera auto-link feature

Learning outcomes

What you will be able to do.

By the end of the course you will confidently use Power BI to analyse project data, track progress and create interactive dashboards that drive informed decisions.

Data modelling

Structure data, define relationships, and use star and snowflake schemas

Data acquisition

Connect to Excel, databases, APIs and cloud services

Data transformation

Filter, sort, clean and create calculated columns

Data visualisation

Charts, graphs and maps that communicate insight

Report design

Interactive reports with filters, slicers and drill-downs

Dashboard creation

Combine visuals into a holistic KPI view

Collaboration

Share reports and dashboards for feedback and decisions

Benefits of learning Power BI

Why it is worth your time.

Better decisions

Real-time insight into current trends on your projects

Data literacy

A deeper understanding of how to analyse and interpret complex data

Career advancement

Power BI skills are in high demand across project organisations

Cost-effective

A user-friendly platform at a relatively affordable price point

Cross-functional

Share data and collaborate across departments

Scalable

Handles large volumes of data and grows with your needs

Who can do this course?

For planners, managers and data people.

  • Planning managers and construction managers
  • Planning and scheduling engineers
  • Civil, electrical, mechanical engineers and architects
  • Fresh engineering graduates
  • Construction management professionals
  • Those who want to work as planning engineers on EPC projects
  • Data analysts, data scientists and business intelligence users

Course delivery

Hands-on, at your computer.

Mode

Online or in the classroom, based on your requirements

Format

Computer-based workshops

Software

Primavera, Excel and Power BI

Material

A customised training manual

Certificate

An EDGE certificate employers can verify.

A certificate of completion is issued to those who attend and complete the programme requirements.

  • Unique URLYour own link to your certificate and digital badge
  • Digital verificationVerified at the click of a button
  • Unique QR codeRecruiters scan your certificate to verify it instantly
  • LinkedIn enabledShowcase it on LinkedIn and share it on other platforms
  • Personal brandingAdd it to job portals, email signatures or your website
EDGE PC ACADEMY Contact Details:Website: www.projectcontrolsedge.aeEmail: contact@projectcontrolsedge.aePhone (UAE): +971 505052387 EDGE ACADEMY CERTIFICATE OF COMPLETION This is to certify that Participant Full Name has successfully completed Advanced Data Analytics in ProjectControls using Power BITraining Program This training program covered Power BI Desktop, Power Query, datamodelling and relationships, DAX and date tables, cash flow and S-curves,interactive dashboards, synoptic panels, Primavera P6 integration andpublishing to the Power BI Service. Completion Date:YYYY-MM-DD Zubair Sheriff Manager of Training xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx Certificate ID EDGE PC SAMPLE
Sample certificate in the EDGE PC Academy format · illustration only

FAQ

Questions, answered.

Is the course online or in the classroom?
Both. The course is offered online and in the classroom, based on your requirements.
Do I need to buy Power BI?
No. The course shows you how to download and install the free version, and how to create an account even without a company domain.
Will I use my own Primavera data?
You learn on a demo project, exporting data from Primavera P6 to Excel and integrating it with Power BI — the same steps you will use on your own projects.
What will I receive?
A customised training manual during the course and an EDGE certificate of completion after completing the programme requirements.
How do I ask about fees?
For course fees, contact us on +971 507461753, or WhatsApp +971 505052387.

Let’s get started

Transform the way you report and manage projects.

Talk to an advisor about the next batch, delivery mode and fees.

Tel / WhatsApp +971 505052387contact@projectcontrolsedge.aeC1 Building, Ajman FZE, UAE