Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Overview of Microsoft Fabric

• Platform summary and its key components
• Connectivity with Microsoft 365 and associated services
• Comparative analysis of Data Factory, Synapse, and Fabric

Module 2 – Workspace Creation and Administration

• Insights into the structure of Fabric Workspaces
• Procedures for creating and structuring Workspaces
• Managing permissions and access rights

Module 3 – Lakehouse Technology

• The Lakehouse paradigm: merging Data Lake and Data Warehouse capabilities
• Setting up a Lakehouse within Fabric
• Data importation and management strategies

Module 4 – Fabric Notebooks

• Getting started with Notebooks (supporting Python and SQL)
• Executing notebook workflows within the Fabric interface
• Applying notebooks for exploratory analysis and data transformation

Module 5 – Visual Pipelines (ETL)

• Understanding ETL principles in the context of Microsoft Fabric
• Designing visual pipelines for data ingestion and processing
• Scheduling tasks and monitoring data flow integrity

Module 6 – Data Warehousing

• Provisioning Data Warehouses within Fabric
• Structuring tables and defining relationships
• Connecting with external data sources and architectural layers

Module 7 – Semantic Modeling

• Defining semantic models and their strategic importance
• Developing and refining analytical models
• Implementing measures, hierarchies, and KPIs

Module 8 – Report Development in Power BI

• Establishing connections to the semantic model
• Applying best practices for effective dashboard design
• Distributing and publishing reports across the Fabric ecosystem

Wrap-up and Future Pathways