Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Overview of Microsoft Fabric

• Introduction to the platform architecture and its key components
• Alignment with Microsoft 365 and additional Microsoft services
• Distinguishing features between Data Factory, Synapse, and Fabric

Module 2 – Workspace Administration

• Concept of Fabric Workspaces
• Procedures for creating and structuring Workspaces
• Managing permissions and access rights

Module 3 – Lakehouse Architecture

• The Lakehouse paradigm: Merging Data Lake and Data Warehouse capabilities
• Setting up a Lakehouse instance within Fabric
• Strategies for data ingestion and administration

Module 4 – Utilizing Notebooks

• Introduction to Notebooks supporting Python and SQL
• Executing notebook workflows within the Fabric environment
• Applying notebooks for exploratory data analysis and transformation tasks

Module 5 – Visual Pipelines (ETL)

• ETL methodologies within Microsoft Fabric
• Constructing visual pipelines for data ingestion and processing
• Scheduling tasks and monitoring data flow performance

Module 6 – Data Warehousing

• Establishing Data Warehouses in Fabric
• Designing table models and defining relationships
• Integrating with external data sources and architectural layers

Module 7 – Semantic Modeling

• Defining semantic models and their strategic importance
• Building and refining analytical models
• Configuring measures, hierarchies, and KPIs

Module 8 – Power BI Reporting

• Establishing connections to semantic models
• Best practices for designing effective dashboards
• Distributing and publishing reports across Fabric

Recap and Future Actions