1 – Introduction and Data Preparation
- The Microsoft Fabric ecosystem
- Simple data import (Excel)
- Power Query: Data cleaning and transformation (ETL)
- Data types and basic operations
2 – Data Modeling
- Fact and Dimensional Tables concepts
- Creating Relationships (Star Schema)
- Defining Filter Direction and Cardinality
- Aggregations and data types
3 – Calculations with DAX (Fundamentals)
- Introduction to DAX
- DAX Syntax and Operators
- Calculated Columns vs Measures (Fundamental differences)
- Aggregation Functions (SUM, AVERAGE, MIN, MAX)
- Basic functions
4 – Data Visualization and Reporting
- Selecting the right visual for the objective
- Field configurations and visual formatting
- Page creation and customization
5 – Collaboration and Sharing
- Publishing to Power BI Service
- Introduction to Workspaces
- Creating basic Dashboards