Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• Platform overview and core components
• Integration capabilities with Microsoft 365 and related services
• Comparative analysis of Data Factory, Synapse, and Fabric

Module 2 – Managing Fabric Workspaces

• Detailed understanding of Fabric Workspaces
• Creation and organizational strategies for Workspaces
• Administration of permissions and access controls

Module 3 – The Fabric Lakehouse

• Exploring the Lakehouse architecture: merging Data Lake and Data Warehouse capabilities
• Procedure for establishing a Lakehouse within Fabric
• Data import and management workflows

Module 4 – Notebooks in Fabric

• Overview of Notebooks supporting Python and SQL
• Creating and executing notebooks directly within the Fabric environment
• Practical applications for exploratory analysis and data transformation

Module 5 – Visual ETL Pipelines

• ETL principles within the context of Microsoft Fabric
• Designing visual pipelines for data ingestion and transformation
• Scheduling and monitoring data flow operations

Module 6 – Data Warehousing

• Setting up Data Warehouses in Fabric
• Defining table models and establishing relationships
• Connecting with external data sources and distinct layers

Module 7 – Semantic Modeling

• The significance and definition of semantic models
• Construction and refinement of analytical models
• Configuring measures, hierarchies, and key performance indicators

Module 8 – Power BI Reporting

• Linking reports to the semantic model
• Effective practices for dashboard design
• Distribution and publication of reports via Fabric

Conclusion and Future Directions