babymore87
MyBoerse.bz Pro Member
Free Download Power BI Project Controls Dashboards with Microsoft Project
Published 8/2026
Created by Hassan Krayem
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Beginner | Genre: eLearning | Language: English | Duration: 35 Lectures ( 8h 45m ) | Size: 8.2 GB
Build resource workload, progress, KPI and S-curve dashboards using Excel, Power Query and DAX for pharma C&Q projects.
What you'll learn
Build a live Workload Dashboard in Power BI to track resource capacity and detect overload on C&Q projects Connect Power BI to MSP data and model a WBS-driven Project Progress Report Calculate SPI and Schedule Variance in Power BI and display them in a dynamic Project Health Score visual Design an interactive S-Curve comparing Baseline, Forecast, and Actual progress with automatic data date tracking Build a Key Highlights panel for Issues, Actions, and Risks that the project team can update without touching Power BI Structure a reporting system that replaces manual Excel status reports on pharmaceutical commissioning projectsRequirements
Basic Power BI Desktop experience: you should be able to open a .pbix file, load data, and create a simple visual Familiarity with project scheduling concepts: WBS, milestones, float, actual %, and schedule variance Working knowledge of pharmaceutical C&Q project structure (IQ/OQ/PQ phases, GxP context) is strongly recommended Access to MSP or exported MSP data is a plus but not mandatory - sample data is providedDescription
Turn your Microsoft Project schedule into interactive Power BI dashboards for project planning, monitoring and control.
Project schedules contain valuable information, but standard Microsoft Project views are not always suitable for management reporting, resource analysis or communicating project performance. This practical course shows you how to transform your own Microsoft Project data into clear and decision-focused Power BI dashboards.
You will follow a complete workflow from Microsoft Project to Excel and Power BI. You will prepare the data, transform it with Power Query, create DAX calculations and build several dashboards for different project-control needs.
During the course, you will learn how to
• Export project schedule and workload data from Microsoft Project
• Prepare and structure the exported data in Excel
• Connect Excel project data to Power BI
• Clean and transform project data using Power Query
• Create DAX measures and calculated objects
• Build a resource workload and capacity dashboard
• Analyse resource assignments, availability, holidays and vacations
• Create a project follow-up dashboard
• Track task progress, comments and actions
• Identify and present critical project activities
• Calculate and display project performance KPIs
• Compare baseline, actual and forecast performance
• Build project S-curves and progress visuals
• Create interactive reports for project managers and stakeholders
The course uses a realistic pharmaceutical line-upgrade and Commissioning & Qualification project as its practical case study. However, the methods can also be applied to construction, engineering, manufacturing, shutdown and other schedule-driven projects.
You are encouraged to follow the lessons using your own Microsoft Project schedule. This allows you to apply the techniques directly to a real project instead of depending on the instructor's dataset.
able resources are provided progressively throughout the course. These resources include organized DAX formulas, Power Query M code, calculated columns and tables, model relationships and data-preparation guidance. Students can copy the required code while following the corresponding dashboard lessons.
This course is designed for
• Project controls professionals
• Planning and scheduling engineers
• Project managers
• Microsoft Project users
• Power BI users working with project data
• Construction and engineering professionals
• Pharmaceutical and C&Q project professionals
Basic familiarity with Microsoft Project, Excel and Power BI will be helpful. The course focuses on applying these tools to real project-control reporting rather than teaching every basic feature of each application.
By the end of the course, you will be able to transform your Microsoft Project schedule data into a structured Power BI reporting system containing resource, follow-up, KPI and S-curve dashboards.
Who this course is for
This course is built for PMOs, schedulers, and project controls engineers working on pharmaceutical Commissioning & Qualification projects who are tired of manual reporting and want to deliver real-time dashboards to their stakeholders. If you already work with MSP and understand C&Q project structure, you will get immediate practical value from every module. It is not for beginners looking for a general Power BI introduction - it is for professionals who want a reporting system that matches the complexity of their projects.Homepage
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
No Password - Links are Interchangeable
