Power BI in Project Control HOST: OSAMA SAAD
MBA, PMP, PSP, PMI-SP
Power BI
Power BI Roadmap
Software
Data Models Activity
Download Data Primary and
& Connection Codes
and Normalization Foreign Keys
Points Requirements
Installation
Cardinality / Power BI
Power BI Tour Cross Filter Relationships Power Query Data
Direction Templates
Calculated
Prepare Format
DAX Formula Columns / Full Report
Measures
Dashboard Dashboard
Advanced Themes
Excel (Bonus) (JSON)
Three Layouts
Report
Data Tables
Model
Data Connectors
What is a Data Model?
Raw data tables that define certain characteristics
Identify relationships among all these tables with one or
more connection points.
E.g. Facebook
Surveys (courtesy, prize draw)
Loyalty programs for big brands
Activity Codes – Best Practices
High Level
FUNNEL More detailed
and laser-focused
Low Level
Snowflakes
Schemas
Primary
Primary and
Foreign
Foreign
Foreign keys Foreign
Primary
Primary
Foreign
Data Normalization
Eliminate redundant data
Minimize errors and anomalies (Insert, Update or Delete)
Each table presents certain information (purpose)
Each key area has primary and foreign keys
Name “Tables”
Remove Blank Rows
Data Import to Power BI - Steps
Transform Format Unpivot
Data Columns Columns
Uncheck
Add Format
Relationship
Relationships Dates Again
Detection
Cardinality
Baseline Details Sheet
Labor Assignments Sheet
Earned Value Model
Day 1 Day 2 Day 3 Day 4 Day 5 Day 6
Budgeted total cost = $10,000
Activity A
Budgeted Labor Units = 1,000 hours
Activity B
Budgeted total cost = $20,000
Budgeted Labor Units = 500 hours
Update by end of Day 3
Attribute Activity A Activity B
Planned % 75% 25%
Planned Value Cost 0.75*10,000 = $7,500 0.25*20,000 = $5,000
Planned Value Labor Units 0.75*1,000 = 750 hours 0.25*500 = 125 hours
Actual % 50% 10%
Earned Value Cost 0.5*10,000 = $5,000 0.1*20,000 = $2,000
Earned Value Labor Units 0.5*1,000 = 500 hours 0.1*500 = 50 hours
Schedule Update - Cost
Update by end of Day 3 – Cost Wise
Attribute Activity A Activity B
Planned % 75% 25%
Planned Value Cost 0.75*10,000 = $7,500 0.25*20,000 = $5,000
Planned Value Labor Units 0.75*1,000 = 750 hours 0.25*500 = 125 hours
Actual % 50% 10%
Earned Value Cost 0.5*10,000 = $5,000 0.1*20,000 = $2,000
Earned Value Labor Units 0.5*1,000 = 500 hours 0.1*500 = 50 hours
Budgeted Total Cost $10,000 $20,000
Overall Planned % = (7,500 + 5,000) / (10,000 + 20,000) = 41.6%
Overall Actual % = (5,000 + 2,000) / (10,000 + 20,000) = 23.3%
Planned % vs Actual % = 23.3% - 41.6% = -18.3%
Measures
%’s
Table Measure
Planned Cost Early (Weekly)
Cum Planned Cost Early
Planned Cost Late (Weekly)
Cum Planned Cost Late
Planned Labor Units Early (Weekly)
%
Cum Planned Labor Units Early
Planned Labor Units Late (Weekly)
Cum Planned Labor Units Late
Earned Value Cost & Labor Units (Update)
Actual This Week Period Cost & Labor Units (Update)
Variance Analysis
Indicator Formula
Variance % Actual % - Planned %
Cost Variance Earned Value Cost – Planned Value Cost
Remaining Cost Budgeted Total Cost – Earned Value Cost
SPI Earned Value Cost / Planned Value Cost
Variance & SPI
Variance % = Actual % - Planned %
Actual % = Earned Value Cost / Total Cost
Planned % = Planned Cost / Total Cost
SPI = Earned Value Cost / Planned Cost
Issues with using Power BI
Work with large projects and exceed the 1M excel rows.
Import recovery program to the data model.
