Power Bi For Construction Projects A Real Case Study 2024

Create Astonishing Dashboards and KPI's Report for Construction Projects - a complete and Comprehensive course from A2Z

What you'll learn

Create Professional Dashboards for construction projects

Monitor and Control Construction Projects Using Power BI

Earn A solid knowledge in Analyzing Projects Data Using Power Bi

A Complete Case Study from Project Schedule to Project Update and Finally Project Reporting

Master Skills of Using Business intelligence tools in reporting your construction projects

Create Your Own Database for construction projects

Requirements

No Prior Knowledge for Power Bi or Primavera P6

No Prior Knowledge to Power BI

No Prior Knowledge to Excel

Description

in this course you will be introduced to the Revolutionary Power Bi the leading business intelligence tool, to transform raw data into meaningful insights. You will discover how to connect to various data sources, clean and transform your data, and create visually stunning reports and dashboards that will impress your stakeholders. with a comprehensive course in the construction projects monitoring and controlling Field with a real life case study you will have the tools and Techniques to create your own database and Setup a professional portfolio of Professional Reports. But that's not all! This course goes beyond the basics and dives deep into advanced topics such as data modeling, DAX formulas, and data visualization best practices. You will learn how to create interactive reports that allow you to drill down into the details, analyze trends, and identify patterns that can help you optimize your construction projects.And the best part? This course is hands-on and practical. You will work on real-world construction datasets, tackling common challenges and solving real problems that you encounter in your day-to-day work. By the end of the course, you will have a portfolio of impressive Power BI projects that you can showcase to potential employers or clients.

Overview

Section 1: Monitor and Control Your Mega Construction Project

Lecture 1 What will make You a Professional Engineer

Lecture 2 Learn About Construction Projects Metrics, KPI's, KRI's and KRA's

Section 2: 02 - Your Power Comes from Your Database

Lecture 3 Your First Glance to Primavera P6

Lecture 4 Master the Slicing Concept in P6

Lecture 5 Cont Slicing Concept in P6

Lecture 6 Create Your First Professional Database

Lecture 7 Create Powerful Database Part 2

Lecture 8 Export Resource Assignment to Database

Lecture 9 Export Updates to Database

Section 3: 03 - Welcome to the Universe Of Power Bi

Lecture 10 Download and install Microsoft Power Bi

Lecture 11 Going through the world of Power BI

Lecture 12 The True Power Query Editor in Power BI

Lecture 13 The Power of Data Modeling and Data Engineering

Lecture 14 Create your First dashboard in Power BI

Lecture 15 Create Planned Vs Actual and Earned Value Report

Lecture 16 Create Earned Value Analysis Report

Lecture 17 Create Planned Vs Earned Value Resources HRS

Lecture 18 Design your Report the way That Talks

Lecture 19 Learn DAX and Create Your First Formula

Lecture 20 Create Resources Histogram Report

Lecture 21 Create Cost and Units Variances Report

Lecture 22 Model your Building inside Power BI

Lecture 23 How to Connect SQL Databases to Power BI

Planning Engineer,Engineers interested in construction projects,Engineers interested in Data Analysis and Projects Reporting,Construction Managers,Engineers curious in Power bi