Power BI Fundamentals: From Data to Dashboard

Instructor: Alaa Hady · Language: English or Arabic · Suggested duration: 2 days · Level: Beginner to Intermediate (Level 100–200)

Objectives

• Connect to common corporate data sources and transform raw data into clean tables.
• Build a sound foundational Star Schema data model.
• Write core DAX measures and Visual Calculations for business metrics.
• Design interactive, accessible report pages and publish to the Power BI Service.

Outline and contents

1. Power BI Desktop architecture, modern ribbon interface, and workflow overview
2. Connecting to Excel, CSV, SharePoint folders, and SQL/Dataverse sources
3. Power Query essentials: data types, filtering, merging, appending, unpivoting, and error handling
4. Data modelling basics: fact vs. dimension tables, relationships, cardinality, and filter direction
5. Calculated columns vs. DAX measures vs. Visual Calculations
6. Introductory DAX: SUM, AVERAGE, COUNTROWS, DISTINCTCOUNT, DIVIDE, and basic CALCULATE
7. Visual selection, layout hierarchy, conditional formatting, and dashboard storytelling
8. Slicers (new slicer visual), drill-through pages, custom report tooltips, and bookmarks
9. Publishing to Workspaces, scheduled refresh basics, and sharing via Power BI Apps
10. Hands-on end-to-end dashboard capstone project

Target audience

New Power BI users, Excel analysts, business analysts, reporting specialists, and departmental staff.

Expected outcomes

Participants can build an end-to-end Power BI report from raw files to published dashboard, explain their relational model, write essential DAX calculations, and share their work securely.