Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Getting Started with Microsoft Fabric

• Comprehensive overview of the platform and its core elements
• Exploring connectivity with Microsoft 365 and other Microsoft services
• Analyzing the distinctions between Data Factory, Synapse, and Fabric

Module 2 – Workspace Creation and Administration

• Deep dive into the functionality of Fabric Workspaces
• Steps for creating and structuring Workspaces
• Managing permissions and user access protocols

Module 3 – Utilizing Lakehouses in Fabric

• Understanding the Lakehouse paradigm: the fusion of Data Lake and Data Warehouse capabilities
• Setting up a Lakehouse environment within Fabric
• Strategies for importing and administering data

Module 4 – Leveraging Notebooks in Fabric

• Introduction to Notebooks supporting Python and SQL
• Procedures for building and executing notebooks inside Fabric
• Practical applications for exploratory data analysis and transformation tasks

Module 5 – Visual ETL Pipelines

• Exploring ETL principles within the Microsoft Fabric context
• Developing visual pipelines to handle data ingestion and transformation
• Techniques for scheduling and overseeing data workflows

Module 6 – Data Warehouse Implementation

• Establishing Data Warehouses directly within Fabric
• Structuring table models and defining relationships
• Strategies for integrating with diverse data sources and architectural layers

Module 7 – Developing Semantic Models

• Defining semantic models and understanding their strategic importance
• Crafting and refining analytical models
• Configuring measures, hierarchies, and Key Performance Indicators (KPIs)

Module 8 – Crafting Reports with Power BI

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

Conclusion and Future Directions