NEW On Demand Course 

Power BI Foundations for Project Controls

Transform your data in Power BI using Power Query, apply DAX formulas for advanced calculations, and build effective data models. 

  3 Hours of Training
  3 Quizzes
  Certificate of Completion
  Software Included (Windows Required)
  Perfect for Beginners or Intermediates
  Language: English (with subtitles)
  Instructor: Yash Desai
USD $249.00 for 1 Year of Online Access

power bi foundations online course preview

NEW On Demand Course 

Power BI Foundations for Project Controls

Transform your data in Power BI using Power Query, apply DAX formulas for advanced calculations, and build effective data models. 

  3 Hours of Training
  3 Quizzes
  Certificate of Completion
  Software Included (Windows Required)
  Perfect for Beginners or Intermediates
  Language: English (with subtitles)
  Instructor: Yash Desai
USD $249.00 for 1 Year of Online Access

power bi foundations online course preview

NEW On Demand Course 

Power BI Foundations for Project Controls

Transform your data in Power BI using Power Query, apply DAX formulas for advanced calculations, and build effective data models. 

  3 Hours of Training
  3 Quizzes
  Certificate of Completion
  Software Included (Windows Required)
  Perfect for Beginners or Intermediates
  Language: English (with subtitles)
  Instructor: Yash Desai
USD $249.00 for 1 Year of Access

About the Course

In this course, you will gain hands-on experience with exporting data from Primavera P6, organizing and preparing data in Excel, and linking Excel to Power BI. You’ll learn how to format and transform your data in Power BI using Power Query, apply DAX (Data Analysis Expressions) formulas for advanced calculations, and build effective data models.
Additionally, you will explore using filters, designing interactive reports, and sharing them via Power BI Service. This course is tailored for professionals seeking to streamline project data analysis and reporting using Power BI.

What You'll Learn

  • Basics of Power BI for project planning
  • Importing data from P6 and advanced data modelling and preparation
  • Intro to DAX and basic visuals
  • Create S-Curves, RAG Status Donut Chart, and conditional formatting
  • Creating and sharing customized interactive reports in Power BI

Who Is This Course For?

Project Controllers looking to enhance their data management skills
Data Analysts
who want to build a strong foundation in data analysis
Project Schedulers
can benefit from improved tools to manage timelines and resources effectively
Project Managers
will gain insights into data-driven decision-making for better project outcomes
Students
interested in data analysis can learn valuable skills that will boost their career prospects

About the Course

In this course, you will gain hands-on experience with exporting data from Primavera P6, organizing and preparing data in Excel, and linking Excel to Power BI. You’ll learn how to format and transform your data in Power BI using Power Query, apply DAX (Data Analysis Expressions) formulas for advanced calculations, and build effective data models.
Additionally, you will explore using filters, designing interactive reports, and sharing them via Power BI Service. This course is tailored for professionals seeking to streamline project data analysis and reporting using Power BI.

What You'll Learn

  • Basics of Power BI for project planning
  • Importing data from P6 and advanced data modelling and preparation
  • Intro to DAX and basic visuals
  • Create S-Curves, RAG Status Donut Chart, and conditional formatting
  • Creating and sharing customized interactive reports in Power BI

Who Is This Course For?

Project Controllers looking to enhance their data management skills
Data Analysts
who want to build a strong foundation in data analysis
Project Schedulers
can benefit from improved tools to manage timelines and resources effectively
Project Managers
will gain insights into data-driven decision-making for better project outcomes
Students
interested in data analysis can learn valuable skills that will boost their career prospects

Course Outline & Duration

Module 1: Basics of Power BI  - 9m 48s

3m 45s

Power BI Licensing and Platforms

1m 58s

Setting Up Power BI Desktop

1m 36s

Launching Power BI

2m 29s

Module 2: Advanced Data Modelling - 24m 24s

3m 06s

Data Preparation for Power BI

3m 06s

Importing and Transforming Data

3m 21s

Exploring Power Query Functions

4m 51s

Quiz

10m 00s

Module 3: Visuals and DAX in Power BI - 1h 37m

Cardinality and Slicers

3m 48s

Creating Relationships

4m 57s

Understanding Different Views and Relationships

5m 52s

Creating Basic Visuals

3m 58s

Intro to DAX and Basic Visuals

11m 00s

Formatting Visuals

16m 17s

Importing Baseline Data and Computing Metrics Using DAX

13m 54s

How to Create an S-Curve

11m 34s

How to Build a RAG Status Donut Chart

6m 13s

Exploring Conditional Formatting

10m 04s

Quiz

10m 00s

Module 4: Dynamic Reporting in Power BI - 30m 38s

Adding Bookmarks for Visuals on the Dashboard

14m 10s

Publishing Power BI Reports

2m 41s

1m 35s

Course Wrap-Up

0m 47s

BONUS - Extending Power BI with Automation

1m 25s

Quiz

10m 00s

Course Outline & Duration

Module 1: Basics of Power BI  - 9m 48s

3m 45s

Power BI Licensing and Platforms

1m 58s

Setting Up Power BI Desktop

1m 36s

Launching Power BI

2m 29s

Module 2: Advanced Data Modelling - 24m 24s

3m 06s

Data Preparation for Power BI

3m 06s

Importing and Transforming Data

3m 21s

Exploring Power Query Functions

4m 51s

Quiz

10m 00s

Module 3: Visuals and DAX in Power BI - 1h 37m

Cardinality and Slicers

3m 48s

Creating Relationships

4m 57s

Understanding Different Views and Relationships

5m 52s

Creating Basic Visuals

3m 58s

Intro to DAX and Basic Visuals

11m 00s

Formatting Visuals

16m 17s

Importing Baseline Data and Computing Metrics Using DAX

13m 54s

How to Create an S-Curve

11m 34s

How to Build a RAG Status Donut Chart

6m 13s

Exploring Conditional Formatting

10m 04s

Quiz

10m 00s

Module 4: Dynamic Reporting in Power BI - 30m 38s

Adding Bookmarks for Visuals on the Dashboard

14m 10s

Publishing Power BI Reports

2m 41s

1m 35s

Course Wrap-Up

0m 47s

BONUS - Extending Power BI with Automation

1m 25s

Quiz

10m 00s

What You Get:

20+ Video Lessons

Professionally recorded videos that teach you to transform your data with Power BI.

Challenging Quizzes

Lock in your learning by completing quizzes for each module.

Project Files

Download project files and follow along with the videos.

Training Platform

Track your progress and earn awards as you complete your training.

Learn Anywhere, Any Time

Access your training material from anywhere at any time. Learn at your own pace.

Support Forums

Ask questions, get advice, tips &feedback from our experts in the support forum.

Your Instructor

yash desai

Yash Desai

Data Scientist - Movar

Yash Desai is the Data Scientist at Movar Group and holds a Master's degree in Big Data Science. His expertise lies in data engineering (Azure DevOps) and data analysis (Power BI, Power Apps). He creates end-to-end solutions for companies in traditional project controls moving them to the digital age. Yash also has expertise in machine learning and deep learning. 

This course was created in partnership with Movar Group.

movar-group

7-Day No Questions Asked Money-Back Guarantee

When you register, you are fully protected by our 100% Satisfaction-Guarantee. If you don’t feel like you’ve received value and you decide you want to cancel any time within the first 7 days, just let us know and we’ll send you a prompt refund. No hassles, headaches or hoops to jump through.

“We’re so confident that you’ll find Plan Academy useful that you have 7 days to change your mind. We won’t make you beg or invoke any silly rules or conditions – if you’re not satisfied within your first 7 days then we’ll refund you without any fuss.”

We accept these major credit cards. All prices USD.