Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• Overview of the platform and its key constituents
• Integration with Microsoft 365 and other Microsoft services
• Comparison between Data Factory, Synapse, and Fabric

Module 2 – Workspace Creation and Management

• Comprehending Fabric Workspaces
• Setting up and organizing Workspaces
• Managing permissions and access rights

Module 3 – Lakehouse in Fabric

• The Lakehouse concept: merging Data Lake and Data Warehouse functionalities
• Establishing a Lakehouse within Fabric
• Data import and management procedures

Module 4 – Notebooks in Fabric

• Introduction to Notebooks (Python, SQL)
• Developing and executing notebooks inside Fabric
• Applications for exploratory analysis and data transformation

Module 5 – Pipelines (Visual ETL)

• ETL principles within Microsoft Fabric
• Building visual pipelines for data ingestion and transformation
• Scheduling and overseeing data flows

Module 6 – Data Warehouse

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

Module 7 – Semantic Model

• Understanding semantic models and their importance
• Creating and modifying analytical models
• Measures, hierarchies, and KPIs

Module 8 – Report Creation in Power BI

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

Conclusion and Future Directions