Primavera & Power Bi Integration | Interactive Dashboards

This course explains how to link Power BI to Primavera P6, and how to prepare interactive reports and project dashboards

What you'll learn

Install and signup the free version of Power BI

Adjust Primavera P6 projects' schedules

Integrate between Primavera P6 and Power BI

Prepare project database in a very organized way

Creates powerful interactive project reports & dashboards

Compare progress between baseline and updates

Publish Power BI reports and dashboards online

Complete a case study for a real hotel project

Requirements

Basic Knowledge of working with Excel

Basic Knowledge of working with Primavera P6

Description

Microsoft Power BI is the easiest reporting tool available today, used for data analysis and interactive visualization. Microsoft Power BI is available for free, you just need to sign up. It is super easy to use to create interactive reports and dashboards.I will teach you how to easily transfer your Primavera programs to a powerful dashboard to get a deep insight into your projects and to drive your business decisions. Also, I will show you how to publish your dashboards and access them through your smartphone, tablet, or laptop.In this course, I will take you step by step, topic by topic, with the easiest way possible, using the most effective ways to adjust your schedules, prepare the database and create your Power BI interactive reports. In addition, I will explain all the tricks and hicks that you may face during the integration through a full example for a real five-star hotel example.The course has the following topics:A. Power BI OverviewB. Install Power BI desktopC. Adjust Primavera ProgrammeD. Adjust the database, using ExcelE. Check the values in Power BIF. Explore visualsG. Filters & SlicersH. Measure and new columns calculationsI. Link Power BI to the project layoutsJ. Case Study: complete 5-star hotel exampleK. Publish /Share the report, using the mobile application

Overview

Section 1: Introduction to Power BI desktop

Lecture 1 Introduction and course content

Lecture 2 Lecture 2: Power BI overview

Lecture 3 Lecture 3: Installing Power BI and Signup

Section 2: Section 2: Preparing and adjusting the database

Lecture 4 Lecture 4: Link the database to Power BI

Lecture 5 Lecture 5: Adjust Primavera Programme I

Lecture 6 Lecture 6: Adjust Primavera Programme II

Lecture 7 Lecture 7: Understanding the data tables and adjust database

Section 3: Section 3: Creating and adjusting data model and relationships

Lecture 8 Lecture 8 : Import database, adjust power BI model

Lecture 9 Lecture 9 : Power quarry editor

Section 4: Section 4: Visualizing data with Power BI visuals

Lecture 10 Lecture 10 : Visuals I

Lecture 11 Lecture 11: Visuals II

Lecture 12 Lecture 12: Measures and new columns

Lecture 13 Lecture 13 Slicers

Lecture 14 Lecture 14: Edit interactions and filters

Lecture 15 Lecture 15: Synoptic- Resources Power BI, GF layout, JPG and

Section 5: Section 5: Case study - Building interactive dashboards with MS Power BI

Lecture 16 Lecture 16: Five-star hotel example – session1

Lecture 17 Lecture 17: Five-star hotel example – session2

Lecture 18 Lecture 18: Five-star hotel example – session3

Lecture 19 Lecture 19: Five-star hotel example – session4 – Resources

Section 6: Section 6: Publish online, Mobile App and Primavera and Power BI autolink

Lecture 20 Automatically link MS Power BI and Primavera P6 SQLite Database

Lecture 21 Lecture 21: Publish Power BI report online and adjust mobile App

Project Directors / Project Managers / Functional Managers,Schedulers / Planning Engineers,Project Engineers / Project Coordinators,Whoever wants to enhance her/his reporting skills