Part 1: Connect and Transform

Learn to import data from various sources such as Excel, CSV, PDF, SQL, and more.

Master using the Power Query editor to clean, transform, and automate your data effectively.

Part 2: Data Modeling

Enhance the benefits of the data by Creating meaningful relationships between different datasets and finally use all data as one Dataset.

Part 3: DAX Measures and Data Analysis

Discover the power of DAX language for creating measures and calculations.

Learn essential data analysis techniques.

Part 4: Interactive Dashboards

Learn the Data visualization essentials. Create Powerful, Interactive dashboards. Share and Publish Dashboards.

Hands-on Learning Approach

This course adopts a completely practical approach, ensuring that participants apply their learning during the course.

Participants engage in hands-on exercises during the lecture, receiving immediate feedback from the trainer. At the end of each module, participants are required to complete a project, allowing them to reinforce their learning.

Final Project Assessment

Upon completion of the course, participants must successfully pass a final project (End-To-End) that covers all the course content.

This final project evaluates the participant’s ability to apply their learning effectively, ensuring proficiency in Power BI and data analysis techniques.

Module 1 – Connect Data

Introduction to Power BI

• Download & Install.
• Power BIower BI
• Power BI Desktop and Power BI Service.

Capstone basic project (End-To-End)

• Overview of Power BI and its components by implementing a small & Basic project to be familiar with its uses and outcomes

Connect and load Data into Power BI

• Load a single file (Excel, CSV, PDF, SQL).
• Load & Combine all files from the same folder.
• Load Date from online Sources (OneDrive, Google Drive, Web)

Module 2– Power Query (Cleaning-Wrangling)

Introduction to Power Query Editor

• Overview of Power
• Query and its
• Power Query Editor Interface.

Power Query – Data Wrangling “Transformation”

• Learn how to reshape and Prepare your data for analysis.
• Remove top Rows and Promote Headers.
• Delete, Rename, and reorder columns.
• Filter & Sort.

Power Query – Data Cleaning

• Understand the importance of data cleaning.
• Learn Data Cleaning techniques, such as:
• Handle missing values
  • Handle Blanks
  • Correct Data type

Power Query – advanced data wrangling techniques

• Split and Merge Columns.
• Add Custom Columns.
• Applying conditional transformations.
• Group BY.
• Pivot & Unpivot
• Merge & Append.

Module 3 – Data Modeling (Basic)

Understanding Data Relationships

• Explore the importance of creating relationships between
• Types of Datasets (Fact vs. Dimension)
• Relationship Types.

Dax Measures & Calculations (Basics)

• Calculated columns.
• Measures (Implicit Vs. Explicit).
• Sum, Count, Average, Min, Max.
• Add Columns and Measures to Visuals
• Filter Context.

Module 4 – Data Modeling (Advanced)

Dax Measures & Calculations (Advanced)

• Iterated Measures.
• Distinct Count & Count rows. Related.
• Divide
• Calculate, All, All selected.
• Conditional Functions (IF, and, or, Switch).

Advanced Techniques

• Calendar Table.
• Measure Table & Folders.
• Relationships Layouts.

Time Intelligence function

• Calculate for Time
• DATEADD
• TOTALYTD
• TOTALQTD
• TOTALMTD
• SAMEPERIODLASTYEAR
• Year-over-year / Month-over-month trends &comparisons.
• Moving & Rolling averages.

Module 5– Data Visualization & Dashboards

Data Visualization

• Principles of effective data visualization.
• Choose the right visualization for different scenarios.
• Formate and customize charts & Visuals.

Interactive Dashboards

• Understand the components of a Power BI dashboard.
• Learn how to arrange and format visuals on a Power BI dashboard.
• Explore techniques for creating interactive elements such as slicers, filters, drill-throughs, and Tooltip.
• Page Navigator, Bottoms, Field Parameters.

Module 6 – Share and collaborate

Share & Publish

• Understand the different sharing options available in Power BI.
• Explore sharing settings and permissions management.

Collaboration with Power BI Service

• Understand how to collaborate with colleagues using the Power BI Service.
• Understand how to share and collaborate on Power BI reports using OneDrive for Business