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 Quizzes
Certificate of Completion
Software Included (Windows Required)
Perfect for Beginners or Intermediates
Language: English (with subtitles)
Instructor: Yash Desai
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
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
3m 06s | ||
Data Preparation for Power BI | 3m 06s | |
Importing and Transforming Data | 3m 21s | |
Exploring Power Query Functions | 4m 51s | |
Quiz | 10m 00s |
Cardinality and Slicers | 3m 48s | |
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 |
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
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.
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.