Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• Overview of the platform and its core components
• Integration with Microsoft 365 and other Microsoft services
• Distinguishing between Data Factory, Synapse, and Fabric

Module 2 – Creating and Managing Workspaces

• Understanding the role of Fabric Workspaces
• Creating and organizing Workspaces
• Managing permissions and access control

Module 3 – Lakehouse in Fabric

• The Lakehouse concept: merging Data Lake and Data Warehouse functionalities
• Setting up a Lakehouse in Fabric
• Importing and managing data resources

Module 4 – Notebooks in Fabric

• Introduction to Notebooks (Python, SQL)
• Creating and executing notebooks within Fabric
• Application scenarios for exploratory analysis and data transformations

Module 5 – Pipelines (Visual ETL)

• ETL concepts specific to Microsoft Fabric
• Constructing visual pipelines for data ingestion and transformation
• Scheduling and monitoring data flows

Module 6 – Data Warehouse

• Establishing Data Warehouses in Fabric
• Table modeling and defining relationships
• Integrating with other data sources and layers

Module 7 – Semantic Model

• Defining semantic models and their significance
• Creating and editing analytical models
• Working with measures, hierarchies, and KPIs

Module 8 – Building Reports in Power BI

• Connecting to the semantic model
• Best practices in dashboard design
• Sharing and publishing reports within Fabric

Summary and Next Steps