B3: Using Microsoft Power BI for Project Dashboards
Saturday - Sunday, June 27-28, 2020 (1.5 DAYS)
Instructor: Dr. Mohamed El-Mehalawi
Dr. Mohamed El-Mehalawi is a certified PMP (Project Management Professional) with more than 25 years of project management and controls experience. Currently, he is the global leader of project planning and scheduling at Dow Chemical Company. Mohamed served as the manager of project controls department at SBM Offshore. He served as the director of PPM consulting at Faithful and Gould North America. Mohamed is a member and speaker at the PMI and AACE and contributes to the CII Research. Mohamed received his Ph.D. degree from The Ohio State University in industrial and systems engineering in 1998.
It is well known that project controls functions own a lot of data. Analysis of the data is not straightforward if the data is stored in spreadsheets or even relational databases. It is hard and time consuming to repeat spreadsheet analysis every week or every month. Business Intelligence (BI) tools like Microsoft Power BI is an affordable platform for data visualization and analysis.
In this seminar, trainees will learn how to use Power BI to produce interactive project controls dashboards. First, the basics of Power BI will be covered then project controls examples will be developed by participants. This is a hands-on training that will guarantee the participants can replicate what they learn back into their companies. Participants are encouraged to get their own data to build their own dashboards toward the end of the course.
Who should take this course?
Anyone works on a Project Team:
Project Controls Managers
Project Quality Managers
Participants of this course must bring a laptop computer with MS Power BI installed.
| 8:00 - 9:00
|| Setup of Microsoft Power BI Software
| 9:00 – 9:30
|| Connecting Power BI to data sources (Excel)
| 9:30 – 10:00
|| Connecting Power BI to MS-Access
| 10:00 – 10:30
| 10:30 – 11:00
|| Connecting Power BI to Primavera
| 11:00 – 12:00
|| Linking tables to integrate data
| 12:00 – 1:00
| 1:00 – 2:00
|| Adding calculated columns to data tables
| 2:00 – 2:45
|| Walk through different visuals
| 2:45 – 3:00
| 3:00 – 4:30
|| Filters, slicers, and drill-through
| 4:30 – 5:00
|| Formatting Dashboards
8:00 – 9:00
| Develop interactive earned value analysis (EVA) visuals
|9:00 – 9:30
|| CPI/SPI Visuals
|9:30 – 10:00
|| Cash Flow Visuals
|10:00 – 10:15
|10:15 – 10:45
|| Commodity Tracking Interactive Visuals
|10:45 – 12:00
|| Schedule Interactive Analytics
$1150 member / $1300 non-member
NOTE: Fee includes hot breakfast, lunch (for the full day), and morning and afternoon refreshment breaks each day. Late (after May 21) and onsite registrations assessed a $100 penalty. Seminar is subject to cancellation and full refund if minimum enrollment is not met by the early registration deadline.