🔷 Power BI Training Program Structure 

🔷 Power BI

لتحليل البيانات وذكاء الأعمال

حوّل البيانات إلى قرارات ذكية باستخدام

 ( Microsoft Power BI. )

برنامج تدريبي عملي يؤهّلك لبناء نماذج تحليل احترافية، كتابة معادلات  ( DAX )، وتصميم  ( Dashboards ) تفاعلية تُستخدم فعليًا في بيئة العمل.

ابدأ من الأساس، واصل حتى مستوى احترافي يؤهلك لسوق العمل في مجال تحليل البيانات وذكاء الأعمال.

✅ Module 1: Power BI Fundamentals & Environment Setup

Getting Started with Power BI

This module introduces students to the Power BI ecosystem and business intelligence concepts. Learners will understand how Power BI fits into the data analysis workflow and how to work with Power BI Desktop.

Topics include:

• Introduction to Business Intelligence & Power BI

• Power BI Desktop vs Power BI Service

• Installing and exploring Power BI Desktop

• Understanding the Power BI interface and workflow

• Connecting to data sources (Excel, CSV, Folder, Web, Database)

• First data load and basic report creation

🎯 Outcome: Students can navigate Power BI and build their first basic report.

✅ Module 2: Power Query in Power BI (Data Cleaning & ETL)

Data Preparation with Power Query

This module focuses on preparing and transforming raw data using Power Query inside Power BI.

Topics include:

• Power Query Editor interface

• Data cleaning techniques

• Removing duplicates, errors, and nulls

• Data type management

• Split, merge, replace, extract, and transform columns

• Merge and append queries

• Folder-based dynamic data models

🎯 Outcome: Students can build professional ETL processes inside Power BI.

Module 3: Data Modeling & Relationships

Building Professional Data Models

Students learn how to build structured data models that enable accurate and fast analysis.

Topics include:

• Star schema vs flat tables

• Fact and dimension tables

• Creating and managing relationships

• Date tables and time intelligence foundations

• Optimizing model performance

🎯 Outcome: Students can design scalable analytical data models.

✅ Module 4: DAX Fundamentals for Data Analysis

Core DAX for Business Calculations

This module introduces DAX as the analytical engine behind Power BI.

Topics include:

Calculated columns vs measures

DAX syntax and concepts

Aggregation functions (SUM, COUNT, AVERAGE, DISTINCTCOUNT)

Logical functions (IF, SWITCH)

Filter functions (CALCULATE, FILTER, ALL)

Understanding row context and filter context

🎯 Outcome: Students can create accurate dynamic measures.

✅ Module 5: Advanced DAX & Time Intelligence

Advanced Business Calculations

Students move to advanced analytical scenarios.

Topics include:

• Advanced CALCULATE patterns

• Time intelligence (YTD, MTD, QTD, YoY, Rolling periods)

• Ranking and Top N analysis

• Percentages and contribution analysis

• Working with multiple tables in DAX

• Optimizing DAX performance

🎯 Outcome: Students can build professional KPIs and analytical metrics.

✅ Module 6: Data Visualization & Interactive Dashboards

Professional Reports & Dashboards

This module focuses on transforming numbers into decision-ready visuals.

Topics include:

• Choosing the right visuals

• Formatting reports professionally

• Slicers and advanced filtering

• Drill-down, drill-through, tooltips

• Interactive dashboards design principles

• Building executive dashboards

• Using bookmarks and buttons

🎯 Outcome: Students can design interactive business dashboards.

✅ Module 7: Real-World Business Projects

Practical Business Intelligence Applications

This module is fully practical and case-based.

Projects may include:

• Sales performance dashboard

• Financial analysis dashboard

• HR analytics dashboard

• Executive KPI dashboard

🎯 Outcome: Students graduate with real portfolio projects.