Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 22 Minute(s)
Language
English
Taught by
Waheed Anwar
Rating
Course Overview
Primavera P6 to Power BI: Build Powerful Project Monitoring Dashboards.
Take control of your projects like never before! This comprehensive course will guide you step-by-step through the process of leveraging the powerful data visualization capabilities of Power BI Desktop for effective project monitoring and controlling.
You will learn how to connect and import project data from various sources, including popular project management software like Primavera P6 and widely used tools like Microsoft Excel. No more static reports! Discover how to transform raw project data into dynamic and interactive dashboards that provide real-time visibility into your project's health.
Throughout this course, you will master the essential techniques for:
Seamlessly importing project data from Primavera P6 into Power BI Desktop.
Structuring and organizing your project data for optimal analysis.
Calculating and visualizing key project performance indicators (KPIs) such as:
Total Project Cost
Budgeted vs. Actual Man-hours
Project Progress (Current Data)
Schedule Variance (Delay/Ahead)
Performance Percentage (%)
Cost Performance Index (CPI)
Schedule Performance Index (SPI)
Creating visually appealing and informative dashboards to track these critical metrics.
Customizing your reports with headings, backgrounds, and layouts for clear communication.
Organizing your data model for efficient management.
Optimizing your Power BI Desktop settings for project analysis workflows.
By the end of this course, you will have the skills to build powerful, insightful Power BI dashboards that enable data-driven decision-making, proactive risk management, and improved project outcomes. Whether you're a project manager, controller, analyst, or any professional involved in project oversight, this course will equip you with the tools to gain a clear, visual understanding of your project's performance and communicate it effectively to stakeholders.
Course Content
- 4 section(s)
- 20 lecture(s)
- Section 1 Introduction
- Section 2 Microsoft Power BI Desktop Software Download and Installation
- Section 3 Hands on Training of Power BI Desktop
- Section 4 Hands on Training on Dashboard Creation
What You’ll Learn
- Connect and import project data from various sources (e.g., Excel, Primavera P6) into Power BI Desktop.
- Design and build interactive Power BI dashboards to visualize key project metrics like total cost, man-hours, and progress.
- Calculate and interpret critical project performance indicators (KPIs) such as Cost Performance Index (CPI) and Schedule Performance Index (SPI) within Power BI
- Create visualizations in Power BI to effectively track project schedule deviations (delay/ahead of schedule).
- Customize Power BI report layouts, including headings, backgrounds, and canvas settings, for clear and professional presentation of project data.
- Organize and manage project data tables within Power BI Desktop using folders for improved data model clarity and navigation.
- Utilize and customize the Power BI Desktop Options dialog to optimize the software for project monitoring and controlling workflows.
Skills covered in this course
Reviews
-
BBabatunde Taiwo
Good contents but no practice documents
-
BBerkan Alper Kaya
I would like to thank the instructor for offering the course free of charge. However, it did not fully meet my expectations. The potential integration between P6 and Power BI could have been demonstrated more extensively.
-
SSiju NAIR
I wish the instructor has any real word experience with the power BI , its too basic
-
UUdemy User
Excelent, but not details.
