Projects Analysis & Reporting By Using Power BI

Name: Projects Analysis & Reporting By Using Power BI
Rating: 4.4 (27 reviews)

Created byExperts House

Last updated 8/2025

English

What you'll learn

Learn How to Prepare interactive Reports/Dashboard with Real time updates
In-depth Data Visualization,Maps and charts for Professional Reports and advanced dashboards
Advanced Data Modeling Techniques including Relations ,Data Flow Examples
Basics & Advanced usage of Power Bi Tools by working on Mini Projects, checking Best Practice
Understanding Application of Data Analysis/Sience in Projects
Getting Full Knowledge and Definitions of Power BI,Business Intelligence and Data Analysis
Understanding using Power Bi with Integrated AI Tools /Machine Language and how to use it for advanced reports
Connecting power Bi with multi data Sources (Inc.Primavera p6)
How to Use Power Bi Q/A Tool (AI) for advanced Reports and dashboards
How To Use Power Query Editor(Data Transformation)/Data Cleaning
Conditions of Professional Presentation/Reports/Dashboard Color and Preview
How To Use Visuals and Build Reports and Dashboard (inc maps,Power platforms)
Dax Function Usage/Mini Projects
What Is M-Language ? and how to Use it ?

Course content

7 sections • 64 lectures • 31h 19m total length

Intro13:09
Explore Power BI fundamentals, from data sources and reports to dashboards, data modeling, DAX and M language, guided by real-world engineering analytics.
Introduction53:14

Introduction To Power BI Outputs28:07
Quick Previow Of PowerBI Layouts29:00
Getting Data1:08:34
Intro to (Report/Table/Model/Dax/Transform)View1:17:51
General Visuals Options20:00
Intro To Visualisation16:12
Visuals (Stacked Bar/Column)1:02:55
Visulas(Clustered Bar/Column)7:55
Visulas(100% stacked column)10:08
Visulas(Line Chart)23:37
Learn how line, area, and stacked area charts visualize project progress over time, compare actual progress with the planned progress, and customize axes, legends, and data labels in Power BI.
Visulas(Area&Stacked Area Chart)12:57
Learn to create and read area and stacked area charts in Power BI, compare head office and general costs, and read values using a single y axis.
Visulas(Line & (Stacked ,Clustered) column chart)+Ribbon Chart14:10
Visulas(Waterfall Chart)21:37
Visulas(Funnel Chart)9:09
Visulas(Scatter Chart)17:45
Visulas(Pie&Donut Chart)10:52
Explore Power BI pie and donut charts, comparing values and details by project; adjust colors, legend, slicer, and labels, while noting negative values are zero and totals show 100%.
Visulas(Treemap Chart)4:32
Visulas(Gauge Chart)11:41
Visulas(Card Family Charts)27:44
Master Power BI card visuals—normal, simple, multi-row, and the new card—learn to configure layouts, callout values, drill through, overflow, and slicer-driven filtering for projects.
Visulas(KPI Chart)11:51
Visulas(Slicers Chart)1:02:07
Visulas(Table&Matrix Chart)24:11
Visulas(Key Influencers Chart)26:26
Visulas(Decomposition tree Chart)19:10
Visulas(Q&A)12:38
Explore how a Power BI Q&A feature lets you ask data questions in a search bar, generate charts or cards, and refine results with synonyms while avoiding extra measures.
Visulas(Narrative Reports)17:46
Visulas(Metrics)50:38
Power Automate20:11
Power Apps Intro10:42
Elements27:19
Learn to use Power BI elements—text box, buttons, shapes, and images—to create navigable, narrative reports with bookmarks and slicer actions.
Bookmarks25:14
Selection & Arrange8:04
Maps1:36:03
Learn to use Power BI maps, including map, field map, shape map, ArcGIS and Azure map, with geocoding via Bing, longitude/latitude data, legends, and interactive bubbles.
Conditional Formatting32:45
Performance Analyzer2:46
Visualisation Advices1:13:05

Intro To Power Query Editor10:07
Applied Steps21:48
Queries Pan Setting9:10
Home Menue (Part-01-Query/Manage Columns/Reduce Rows/Sort/Transform)48:24
Home Menue (Part-02-Combine)1:00:23
Home Menue (Part-03-AI Insights)17:00
Transform Menu54:26
Learn how to clean and shape data in Power BI's transform menu, then load, model, and create dashboards, by transposing, replacing errors, filling gaps, pivoting, merging, and extracting.
Add Column Menu25:20
View Menu13:06
Tools Menu9:20

Introduction To DAX10:02
Master DAX in Power BI to transform data with calculated columns, measures, and tables, model relationships across datasets, and learn about 250 functions and the DAX versus M languages.
How To Write Dax Formulas39:23
Math Functions32:24
Explore DAX mathematical functions in Power BI, from absolute and cosine to convert, ceiling, and divide, and learn how to combine data for advanced visuals and forecasting.
Text Functions37:13
Explore text functions in Power BI to combine, format, and extract data from text, using concatenate, concatenatex, find, search, trim, and format across tables.
Aggregation Functions47:50
Explore aggregation functions in Power BI, including average, count, and sum, and learn how blanks, text data, and iterators like average x and count x shape your results.
Logical Functions11:32
Learn to apply logical functions in Power BI, including and, or, not, and switch, to create true/false conditions and handle non-blank values.
Date/Time Functions47:00
Explore date and time functions in Power BI to build a date table, enable time intelligence, and strengthen project reporting with calendar and calendar auto features.
Time intelligence Functions1:00:17
Learn Dex language time intelligence functions in Power BI, using a date table and calculations like MTD, QTD, YTD, and end-of-period measures to analyze project data.
Filter Functions (Part-01)1:23:31

General Introduction17:26
Learn ten universal rules for launching and managing projects, from understanding company policy and project plan to establishing data systems, KPIs, and reporting templates.
Workshop-01-L0135:51
Transform daily site data into stakeholder-ready Power BI visuals, revealing target versus achievement across private and government sectors, through data collection, cleaning, and concise conclusions.

Requirements

Basic Computer Skills

Description

The Power-BI Course is Covering All details of Power BI Program including Dax Language and M-Language also As Next:

Introduction for Business Intelligence(BI).
How to use Power BI for Business Intelligence(BI).
Difference Between Excel and Power BI.
What is Data Analysis Concept
Usage of Power Bi in Engineering Fields.
Power Bi Types & Contents (Licenses,View and Updates)
Power BI Online Service
How to Get Data From Data Sources To Power Bi (including Primavera with Example)
How To Build Data Model .
how to manage Relationships and cross filter directions between datasets
Layouts of Powerbi Usage
Report View Usage
Table View Usage
Model View Usage
How to Use Visuals to Build Reports (Full Details)
Using Of images,Shapes and Bookmarks
Using of Power Platforms (Automation,P,Reports,...)
Using Of Power Maps
Building Dashboards
Visualization Advises for Better Reports
Power Query Editor Full Details
How To Transform Data
Invoke Functions,Lists
Dax Language usage
How to Build Dax Language Formulas
Dax Language Functions (FULL 290 Functions with examples)
Variables Usage
M-Language Usage
How to Build M-Language Formulas
M-Language Functions (with examples)
Dax Query Layout Full Details
Full Workshops with Actual Projects Data (Updated)
Q&A and Updated Chapter for any new Updates
Updated workshops Discussions.
Power BI Best Practices.

Who this course is for:

Fresh Graduates
Planning & Technical Engineer
Project Control Engineer
Cost Control Engineers
Business Development Managers
General Managers

Projects Analysis & Reporting By Using Power BI

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 1hr 6min

Getting Data & Creating Reports36 lectures • 16hr 36min

Data Modeling4 lectures • 1hr 46min

Transform Data10 lectures • 4hr 29min

DAX Language9 lectures • 6hr 9min

M-Language1 lecture • 20min

Workshops2 lectures • 53min

Requirements

Description

Who this course is for: