ONLINE COURSES LIVE COHORTS REVIEWS

Become the Power BI Expert Every Project Team Needs

In just 7 days, you'll learn how to build executive dashboards, automate project reporting, and turn complex project data into insights that drive better decisions. Learn to analyze schedules, costs, earned value, financial data, and project performance using Power BI—the same techniques used by leading project controls and PMO teams.

Get Lifetime Access for $99
Start Free Preview

Why This Course?

Most Power BI courses teach charts.This course teaches PROJECT ANALYTICS.

Instead of working with generic sales data, you'll learn how to build dashboards using real project information including:
  • Primavera P6 schedules
  • Project cost reports
  • Earned Value Management
  • Forecasting data
  • Resource utilization
  • Financial performance
  • Executive KPIs
After completing this course you'll be able to:
  • Build professional Power BI dashboards
  • Automate project reporting
  • Analyze project performance
  • Present executive dashboards
  • Improve decision making
  • Add a portfolio project to your resume
  • Prepare for Power BI and Project Analytics interviews
 By the end of the course, you'll know how to answer questions like:
  • Are we ahead or behind schedule?
  • Which projects are over budget?
  • What is our CPI and SPI?
  • Which activities are causing delays?
  • Where are our biggest project risks?
  • What are Project Overall and Year-to-Date Actuals compared to established budgets?
You'll gain skills like:

✔Power BI ✔Power Query ✔Data Modeling ✔Data Integration ✔DAX ✔Data Visualization ✔Data Storytelling ✔Executive Reporting ✔Schedule Analytics ✔Cost Analytics ✔Earned Value Management ✔Resource Analytics ✔KPI Development ✔Dashboard Design ✔Project Controls Analytics ✔Power BI Service

GET LIFETIME ACCESS FOR $99 (50% OFF)

Meet Your Instructor

Learn Power BI from Clement Boateng, an Analytics Consultant, Power BI Developer, and Project Management Professional with extensive experience in Data Analytics, Business Intelligence, and Project Controls Reporting. Clement has worked extensively with Power BI, Microsoft Fabric, Power Query, and DAX, helping organizations turn complex data into meaningful insights and executive-level reports. As an experienced project controls, data professional and educator, he brings real-world analytics experience into the classroom, focusing on practical skills, hands-on projects, and the techniques professionals use to build effective Power BI solutions.

WHAT YOU WILL LEARN

7-DAY POWER BI FOR PROJECT ANALYTICS

  1. DAY 1: COURSE INTRODUCTION

    5 lessons
    1. 1.0 Welcome & Course Intro
    2. 1.1: Course Roadmap
    3. 1.2: The Project Analytics Framework
    4. 1.3: The Data Analyst Mindset
    5. 1.4: Software Installation & Ecosystem

  2. DAY 2: SOURCING & CONNECTING PROJECT DATA

    6 lessons
    1. 2.0: Intro to Data Connection
    2. 2.1: Connecting to Flat Files (Excel & Project Exports)
    3. 2.2: Working with Web Data, SharePoint Lists & Cloud Folders
    4. 2.3: Connecting to Enterprise Databases (SQL & Primavera P6)
    5. 2.4: Managing & Changing Data Source Settings
    6. 2.5: Connecting to All Project Class Files (CSV Datasets)

  3. DAY 3: DATA PREPARATION IN POWER QUERY

    11 lessons
    1. 3.0: Intro to Data Transformation
    2. 3.1: Power Query Overview & Cleaning Basics
    3. 3.2: Row Transformations
    4. 3.3: Column Transformations
    5. 3.4: Adding Custom & Conditional Columns
    6. 3.5: Additional Transformations (Grouping, Pivoting & Unpivoting)
    7. 3.5 Conditional
    8. 3.6 Custom
    9. 3.6: Appending Queries (Stacking Data)
    10. 3.7: Merging Queries (Joining Data)
    11. 3.8: Transform and Load Main Class Data **

  4. DAY 4: PROJECT DATA MODELING

    4 lessons
    1. 4.0: Intro to Data Modelling
    2. 4.1: Basics & Theory of Data Modeling
    3. 4.2: Building Relationships (Star and Snowflake Schema)
    4. 4.3: Cardinality

  5. DAY 5: DATA ANALYSIS EXPRESSIONS (DAX) FOR PROJECT METRICS

    5 lessons
    1. 5.0: Introduction to DAX
    2. 5.1: Calculated Columns vs. Measures
    3. 5.2: Logic for Dynamic Project Status Flags
    4. 5.3: Calculating Cost & Schedule Variances
    5. 5.4: Complex Cumulative & YTD Calculations

  6. DAY 6: DATA VISUALIZATION

    9 lessons
    1. 6.0: Intro to Data Visualization
    2. 6.1: Visualization Overview & Canvas Layout
    3. 6.2: Choosing the correct Visuals
    4. 6.3: Formatting Visuals
    5. 6.4: Themes, Colors, and Conditional Formatting
    6. 6.5: Slicers & Multi-Level Filtering
    7. 6.6: Implementing Drill Downs & Drill Throughs
    8. 6.7: Mastering Bookmarks & Buttons
    9. 6.8: Principles of Data Storytelling

  7. DAY 7: PUBLISHING & SHARING IN POWER BI SERVICE

    5 lessons
    1. 7.0: Intro to Publishing and Sharing
    2. 7.1: Overview of Power BI Service
    3. 7.2: Publishing Reports to Workspaces
    4. 7.3: Sharing Reports Securely
    5. 7.4: Automating Data Refreshes

  8. BONUS DAYS: CAPSTONE HANDS-ON PROJECTS

    3 lessons
    1. DAY 8 - Enterprise Financial Portfolio Dashboard
    2. DAY 9: Earned Value Management (EVM) Dashboard
    3. DAY 10: Schedule Comparison Dashboard (Baseline vs Current)
GET LIFETIME ACCESS FOR $99 (55% OFF)

What You'll Build Throughout the Course

Interactive dashboards that bring together project schedules, cost, financial, and performance data into a single source of truth for faster, data-driven decisions.

Why Students Choose This Course

Real Project Data

Use actual schedules, cost, and project performance data—not generic retail or sales datasets.

Build Portfolio Dashboards

Create executive dashboards you can showcase in interviews or adapt for use in your organization.

Learn by Doing

Every lesson includes hands-on exercises, giving you practical experience rather than just watching videos.

GET LIFETIME ACCESS FOR $99 (50% OFF)

WHAT OUR STUDENTS ARE SAYING

Frequently Asked Questions

GET LIFETIME ACCESS
START FREE PREVIEW