Sale!

Jeancarlo Duran Maica – Power BI Visual Data Analytics for Project Controls – Project Control Academy

$1.297 $350

A hands-on online training workshop on the Power BI application in Project Controls Power BI Visual Data Analytics for Project Controls. Learn How to Automate Your Project Controls Reporting & Create Real-Time Dashboards at the Click of a Button with Power BI

  • Course’s name: Jeancarlo Duran Maica – Power BI Visual Data Analytics for Project Controls – Project Control Academy
  • Size: GB
  • Delivery Method: Instant Download (You will receive the download link through your email right after making the payment)
  • Last Update: 2023

Chat with us or contact us via email coursesdownload.uk@gmail.com if you want to pay with Paypal or Credit Card

Description

Jeancarlo Duran Maica – Power BI Visual Data Analytics for Project Controls – Project Control Academy

Introducing… A hands-on online training workshop on the Power BI application in Project Controls Power BI Visual Data Analytics for Project Controls. Learn How to Automate Your Project Controls Reporting & Create Real-Time Dashboards at the Click of a Button with Power BI

This course will highly benefit all project controls professionals who are keen on making the leap to the next level of seamless automation in Project Controls.

The series of the modules in this comprehensive applied course is designed to provide you accelerated learning in every facet of project controls reporting, from connecting your cost estimate to Power BI to connecting your P6 schedule to Power BI, so you can create real-time dashboards for all sorts of project controls reports.

Course Outline & Agenda

The Power BI Visual Data Analytics for Project Controls online training course is delivered in 10 sessions over the course of 8 weeks.

Each session will introduce you to the essential skills and knowledge of Power BI and Data Analytics within the context of an applied project controls use case: prepare, model, visualize, and analyze the data and deploy and maintain deliverables.

In addition, each session comes with hands-on, real-life workshops that help you fully grasp the content covered in each session and build visual dashboards in each session of the course.

The sessions are delivered online via our private and secure learning management system (LMS). Each session takes about 4 hours, making the course complete within 8 weeks.

You can start the course right away as soon as you enroll. If you cannot complete the course within 8 weeks, that’s totally fine. You have access to the entire course material and instructor support for one year and can take the course at your pace.

Here is the course agenda and what is covered in each week of the program:

WEEK 1: Session 1- Power BI Reporting Architecture

Learn how to properly administer the Power BI interface and its reporting architecture and build your first project progress report

✅ Learn how to publish your reports on Power BI Cloud: Datasets, Workbooks, Reports and Dashboards

✅ Learn how to build your data models in Power BI Desktop: Reports, Data, and Model

✅ Identify the different connectivity levels in Power BI: On-Premises, Cloud and SQL database

✅ Explore the Power BI Reporting Architecture: Develop the first project progress report

📊 Workshop # 1: Drilling & Grouting Project

WEEK 2: Session 2 – Using the Cost Estimate in Power BI

Learn how to prepare the cost estimate data using Power Query and apply effective coding strategies within Power BI to strengthen the control accounts tracking and communication

✅ Perform the sequential ETL steps (Extract / Transform / Load)

✅ Learn how to prepare the cost estimate data using Power Query

✅ Apply effective coding strategies within Power BI to strengthen the control accounts tracking and communication

✅ Identify and deploy Budget analysis and KPIs (Pareto, Histograms, S-Curves)

📊 Workshop #2: Cost Estimate Preparation & Visualization for the Water Line Piping Project

🧩 Case Study #1: Developing the Man-hours S-Curve for the Water Supply Line Project

WEEK 3: Session 3 – Tracking the Cost Estimate in Power BI using DAX

Gain a deep understanding of Power BI DAX Formulas and how you can track your Cost Estimate in Power BI

✅ Learn how to prepare the project actual data using Power Query

✅ Apply coding strategy to track Actual Progress by control account

✅ Assign the actual costs and actual man-hours in the data model

✅ Add new columns and measures in the data model using DAX Formulas (for next session KPIs)

📊 Workshop # 2: Preparing the Cost Estimate for a 63-km Water Line Piping project

WEEK 4: Session 4 – Earned Value Analysis (EVA) Report in Power BI

Create a dashboard for your Earned Value Analysis and unlock specific project controls visuals to enhance team performance, productivity, and communication

✅ Identify key custom visuals for project controls in Power BI

✅ Explore some most common DAX formulas applicable to Project Controls

✅ Learn how to prepare your Earned Value Analysis Report in Power BI

✅ Identify and deploy KPIs, Cards, Timeline, S-Curves (BAC, PV, EV, AC)

📊 Workshop # 3: Earned Value Analysis Visual Dashboard

🧩 Case Study #2: Prepare a fully automated EVM Man-Hour Dashboard for the Water Supply Line Project

WEEK 5: Session 5 – Connecting the P6 files to Power BI

Learn different methods to connect Primavera P6 to Power BI

✅ Learn how to how to draw a Planned Value curve in Power BI

✅ Explore how to troubleshoot your Power Query Update

✅ Learn how to finalize & publish a report in Power BI

✅ Discover different methods to connect Primavera P6 to Power BI to extract schedule KPI and visual schedule dashboards

📊 Workshop # 4:  Boreholes Schedule Integrity Dashboard

WEEK 5: Session 6 – Connecting the Primavera a P6 XML files to Power BI

Link a Cost-loaded Schedule from Primavera P6 to Power BI

✅ Learn how to get data from P6 to Power BI using XML files

✅ Understand and expand P6 XML Tables using Notepad++ and Power BI

✅ Learn how to build time-phased budgets in Power BI

📊 Workshop # 5: Pipeline Project

🧩 Case Study #3: Water Supply Line Project-Get deeper insights from your data

WEEK 6: Session 7 – Capturing the Schedule Update from P6 XML to Power BI

Learn how you can actualize the Schedule Dashboard using Primavera P6 updates

✅  Prepare the Schedule visual reports in Power BI (Baseline)

✅ Create a Gantt Chart in Power BI

✅  Model the actuals from P6 in Power BI

✅  Actualize your schedule dashboard with new schedule updates from P6

📊 Workshop # 5: Pipeline Project

WEEK 7: Session 8 – “Plug & Play Dashboard” Connecting the P6 XER File to Power BI

Develop a “Plug and Play” solution for reporting by mining your Primavera P6 XER files data in Power BI

✅ Learn how to get data from P6 to Power BI using XER files

✅ Identify key Power Query transformations for shaping the data

✅ Use DAX formulas and Measures to translate P6 database into P6 user interface equivalent

📊 Workshop # 6: Schedule Update Analysis

WEEK 8: Session 9 – “Plug & Play Dashboard” Deep dive into your P6 Data using XER files

Learn how you can deploy an automated Schedule Dashboard, assessing trends in your Primavera P6 data without the need for spreadsheets.

✅  Prepare the Schedule report in Power BI (time-related visuals)

✅  Model the Baseline and the Schedule Updates from P6 in Power BI

✅ Learn some advanced DAX measures & calculated fields in P6

✅  Get automatic schedule updates in Power BI

📊 Workshop # 7: XER Schedule Quality Analysis

WEEK 8: Session 10 – Connecting the P6 SQL Database to Power BI

Connect the P6 SQL database to Power BI and explore the pro & cons of database connection

✅ Learn and identify key tables within the P6 database schema

✅ Quick introduction to SQL Server Management Studio (SSMS) and SQL Queries

✅ Establish P6 SQL database connection to Power BI

✅ Understand pros and cons of using P6 database connection

📊 Workshop # 8: P6 Project Portfolio

🧩 Case Study #4- Residential Development Project Dashboard

Sale Page: https://members.projectcontroltraining.com/powerbi

Reviews

There are no reviews yet.

Be the first to review “Jeancarlo Duran Maica – Power BI Visual Data Analytics for Project Controls – Project Control Academy”