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

Power BI Visual Data Analytics for Project Controls With Jeancarlo Duran Maica – Project Control Academy – Instant Download!

Content Proof:

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

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

Automate your project controls reporting and create real-time dashboards effortlessly with Power BI.

Say goodbye to manual data consolidation and hours spent on report generation. Power BI streamlines the process, allowing you to focus on analysis and improving project performance. Say hello to seamless automation in project controls without the need for programming skills or costly software.

Here’s what you may not know about Power BI:

1. Power BI is a recent technology! Released by Microsoft in July 2015, Power BI is a cloud-based Business Intelligence (BI) service. Its relative newness means many are yet to discover its capabilities.
2. Power BI doesn’t require programming knowledge! Even without software development experience, you can create insightful dashboards and automate project reporting using Power BI. However, not everyone knows how to utilize its potential.
3. Power BI is free! Microsoft offers a free version of Power BI with a 1 GB data capacity limit. While there are paid features available, most users won’t need them initially.
4. Power BI complements existing project controls software. Instead of replacing project controls software, Power BI integrates with it, automating reporting and providing tailored insights. It enhances project predictability and bridges gaps in data integration.

By leveraging Power BI, you can transform your project reporting process and gain real-time visibility into project status and performance.

What If You Could….

 Automate your entire reporting cycle and tremendously reduce the amount of time in consolidating data and producing reports
 Prevent errors associated with manual data entry and consolidation
 Provide real-time visibility into your projects’ status
 Quickly identify project performance problems at the desired granularity level
 Spend more time in data analysis and flagging project issues
What if you could have a “One-Click Reporting Tool” for Project Controls?
Sounds impossible?!!

Power BI has made the next level of automation for Project Controls reporting possible!
However, not everyone knows how to tap into Power BI and getting started.
That’s why we have developed the most practical and step-by-step training program in Power BI as it applies to Project Controls.

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

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

What You’ll Gain Upon the Completion of the Training

Power BI is becoming one of the most used tools on the market for all industries.
The “problem” is that it is too hard to find qualified professionals with a background in data analytics and project controls, so this is the BEST TIME to learn Power BI, grow professionally and be able to choose where to work.

Upon completion of the course, you will successfully master advanced project controls analytics using Power BI and will be able to implement this knowledge immediately in your day-to-day work.

To be more specific, below are some of the expected learning outcomes that you’ll gain upon the completion of this course:

LEARN how to build your data models in Power BI Desktop, so you can automate your data workflows (data wrangling) and gain deeper insights into your project performance instantly.

LEARN how to publish your reports on Power BI Service (Datasets, Reports , and Dashboards), so you can share and communicate project performance with the project team using cloud-based interactive reports at the click of a button.

SET UP your reporting architecture for Project Controls using Power BI to get better, faster, and deeper project analytics saving at least 50% of the time compared to the traditional way.

AUTOMATE your reporting workflows using Power Query for automatic data transformation and the Power BI service for recurring and automatic data sources update, adding more visibility to project reports in a timely manner.

LEARN advanced project controls design principles to produce high-impact visualizations and dashboards to address specific project needs that are sometimes impossible in MS Excel or simply too time-consuming to prepare. (Specific visualizations include: cost estimate Pareto and gap analysis, milestone trend analysis, float erosion, schedule integrity and quality, critical and near critical path assessment, S-curves, etc.)

APPRECIATE various methods of obtaining P6 data in Power BI (Excel, XML, XER, SQL), so that you can formulate your own schedule KPIs.

UNDERSTAND the steps to establish a direct connection from the P6 SQL database to Power BI, so that you can set up real-time dashboards to make better-informed business decisions.

What Is UNIQUE About This Training?

Here are several key unique points about this training that you wouldn’t find in other similar training courses in the market:

 The most comprehensive applied Power BI online course you will ever find in project controls, covering all facets of Project Controls reporting from cost to schedule and types of connection to data sources (XML, XER, SQL). It is dedicated to ANY project controls professional who is keen on creating real-time reports and perform data analysis efficiently.

The most hands-on training on Power BI as it’s applied to Project Controls! You will learn Power BI by solving real Project Controls problems through different case studies and acting as a BI Consultant. The course allows you to tackle the most challenging project controls reporting issues in half the time and with a high-impact solution that will mesmerize your colleagues.

Step-by-step implementation and guidance, which enable you to apply your learning in a project environment immediately and achieve a significantly more robust result.

 Presented by a Microsoft Certified Data Analyst, a subject matter expert on Power BI and Primavera P6, and Project Controls practitioner, Jeancarlo Duran Maica, MBA, CCP™, PMP®, EVP™, Microsoft MCP©, who has extensive knowledge and experience in setting-up data, building interactive dashboards and running up-to-the-minute analytics using Power BI on a wide range of multimillion-pound projects.

Based on the training that the instructor has given to hundreds of project professionals, with little to no previous experience in Power BI. Upon the course completion, they all could build interactive real-time dashboards and automate their project reporting process. You should expect to obtain similar results.

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

This training is for you if…

• Project Controls professionals seeking to automate and enhance reporting processes, create real-time dashboards, and focus more on data analytics.
• Project Planner/Schedulers aiming to maximize scheduling software like Primavera P6 for efficient communication.

• Cost Controllers interested in generating insightful cost reports and presenting them through interactive visual dashboards.
• Cost Estimators looking to present cost estimates effectively and provide automatic updates.
• Project/Program Managers in need of real-time reporting solutions for quick project performance insights.
• Project leaders interested in gaining updated knowledge in quantitative risk management.
• Beginners in Project Controls seeking to learn Power BI and data analytics to stand out in their field.
• Those with some Power BI experience wanting to refine their skills or learn report design principles.

Is This Training For Me if ….

• I have no experience with Power BI or programming languages? Absolutely! This training covers principles for all project professionals, regardless of Power BI or software development experience.
• I don’t have the Power BI software? No problem! You can download the latest version for free.
• I use in-house Project Controls Software? Certainly! Power BI complements existing software, streamlining reporting processes and integrating data sources efficiently.

Pre-Requisites and Required Software:

No prior Power BI experience needed. This course covers everything from beginner to advanced level. A project controls background is beneficial but not required.

The course includes step-by-step case studies to help you grasp each scenario easily. Suitable for both junior and seasoned project controls professionals in various disciplines. Familiarity with Primavera P6 software is preferred for connecting schedule files to Power BI.

Recommended Software:

• Latest version of Power BI (free download at powerbi.com)
• Microsoft Excel (standalone or part of Microsoft Office 365 suite)
• Primavera P6 (preferably release R15 onwards, 30-day trial available for download)
• Notepad++ (free software)

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

****Explore irresistible discounts on a variety of courses at Buytorich – a treasure trove awaits you Here!

Frequently Asked Questions:

1. Innovative Business Model:
   • Embrace the reality of a genuine business! Our approach involves forming a group buy, where we collectively share the costs among members. Using these funds, we purchase sought-after courses from sale pages and make them accessible to individuals facing financial constraints. Despite potential reservations from the authors, our customers appreciate the affordability and accessibility we provide.
2. The Legal Landscape: Yes and No:
   • The legality of our operations falls into a gray area. While we lack explicit approval from the course authors for resale, there’s a technicality at play. When procuring the course, the author didn’t specify any restrictions on resale. This legal nuance presents both an opportunity for us and a boon for those seeking budget-friendly access.
3. Quality Assurance: Unveiling the Real Deal:
   • Delving into the heart of the matter – quality. Acquiring the course directly from the sale page ensures that all documents and materials are identical to those obtained through conventional means. However, our differentiator lies in going beyond personal study; we take an extra step by reselling. It’s important to note that we are not the official course providers, meaning certain premium services aren’t included in our package:
     • No coaching calls or scheduled sessions with the author.
     • No access to the author’s private Facebook group or web portal.
     • No entry to the author’s exclusive membership forum.
     • No direct email support from the author or their team.

   We operate independently, aiming to bridge the affordability gap without the additional services offered by official course channels. Your understanding of our unique approach is greatly appreciated.