Project Monitoring And Controlling With Power Bi Desktop

Primavera P6 to Power BI: Build Powerful Project Monitoring Dashboards.

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.

Requirements

No prior experience with Power BI or project management software is strictly required. We will guide you through the basics. Familiarity with basic computer operations and spreadsheet software (like Excel) will be helpful but not essential.

Description

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 CostBudgeted vs. Actual Man-hoursProject 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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 The Professionals Who Should Learn Power BI

Section 2: Microsoft Power BI Desktop Software Download and Installation

Lecture 3 How to Download Power BI Desktop Software

Lecture 4 Installation of Power BI Desktop

Lecture 5 Overview of Welcome Screen in Power BI Desktop

Lecture 6 Exploring the Power BI Desktop Layout

Section 3: Hands on Training of Power BI Desktop

Lecture 7 How to Export Data from Primavera P6 for Power bi

Lecture 8 Columns Modification for Excel Data

Lecture 9 Import Data from Excel to Power BI Desktop

Lecture 10 How to create a Folder to arrange the Tables

Lecture 11 Overview of Options dialog in Power BI Desktop

Lecture 12 Setting of Power bi canvas Background

Section 4: Hands on Training on Dashboard Creation

Lecture 13 Dashboard for the Project Total Cost in Power BI

Lecture 14 Dashboard for Budgeted Total Man hours and Actual Man hours in Power BI

Lecture 15 Dashboard for the Project Progress Current Data in Power BI

Lecture 16 Dashboard for Delay / Ahead Schedule in Power BI

Lecture 17 Dashboard for Performance PCT% in Power BI

Lecture 18 Dashboard for Cost Performance Index (CPI) in Power BI

Lecture 19 Dashboard for Schedule Performance Index (SPI) in Power BI

Lecture 20 Setting for Heading, Background and Wallpaper in Power BI

This course is for project managers, project controllers, project analysts, and anyone involved in tracking and managing project performance. If you want to leverage the power of data visualization to gain better control over your projects, this course is for you.