01-Easiest way to Create Power BI and Excel Dashboards based on Primavera Project - Introduction
Introduction to Series for creation of Interactive Power BI and Excel Dashboards based on Primavera Project.
02- Easiest way to Create PBI and Excel Dashboards from Primavera. setup and cleaning Data.
Import XER for the sample projects (Baseline and Update) into Primavera. Define the used data from Primavera. Export Data file from Primavera which will be used in Power BI and Excel. Define the Exported file from Primavera. Power BI - Import Date, clean the data and Test Data. Excel - Import Date, clean the data and Test Data.
03.3-PBI - Easiest way to Create PBI & Excel Dashboards from Primavera creating overall data Part 3
Power BI essential settings. Power Query Creating WBS Levels Tables (Phases, Work and Floors). Power BI Create Relations between Tables.
03.4-PBI - Easiest way to Create PBI & Excel Dashboards from Primavera creating overall data Part 4
Cost Chart - Explain the calculations. Bookmarks and Button for Interactivity. Use Bookmark Navigator instead of Buttons.
03.5-PBI Easiest way to Create PBI & Excel Dashboards from Primavera creating overall data Part 5
Add Hierarchy Visual, check the Interactivity and Compare progress data with Primavera. Command Edit Interaction to make some visuals with overall data. Progress and Labor Visuals Interaction between Overall and WBS.
03.6-PBI Easiest way to Create PBI & Excel Dashboards from Primavera creating overall data Part 6
Create Visual for Floors Progress. 02:34 Visual conditional Formatting. 06:38 Solving Visual Problems for Blank Records.
03.7-PBI Easiest way to Create PBI from Primavera creating overall data - Final
This Video is the Final Part for the General Progress Dashboard: 00:21 Interactive Title - Introduction. 00:48 Interactive Title - Method. 05:58 Interactive Title - Format by HTML. 09:58 Update Primavera Project and Update the Power BI Report. 12:04 Conclusion.