Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Overview of Microsoft Fabric

• Platform overview and its key constituent elements
• Connectivity with Microsoft 365 and broader Microsoft services
• Distinctions between Data Factory, Synapse, and Fabric

Module 2 – Workspace Creation and Administration

• Concepts behind Fabric Workspaces
• Steps to create and structure Workspaces effectively
• Managing permissions and access rights

Module 3 – Lakehouse Implementation in Fabric

• The Lakehouse paradigm: merging Data Lake and Data Warehouse functionalities
• Procedures for establishing a Lakehouse within Fabric
• Strategies for data ingestion and management

Module 4 – Utilizing Notebooks in Fabric

• Introduction to Notebooks (supporting Python and SQL)
• Techniques for creating and executing notebooks inside the Fabric environment
• Practical applications for exploratory analysis and data transformation

Module 5 – Pipelines (Visual ETL)

• ETL principles applied within Microsoft Fabric
• Building visual pipelines for data intake and processing
• Automating and tracking data flow execution

Module 6 – Data Warehouse Management

• Establishing Data Warehouses within the Fabric framework
• Defining table structures and defining relationships
• Connecting with external data sources and various architectural layers

Module 7 – Semantic Modeling

• Understanding the definition and importance of semantic models
• Crafting and refining analytical models
• Managing measures, hierarchies, and KPIs

Module 8 – Report Creation with Power BI

• Establishing connections to the semantic model
• Applying best practices for effective dashboard design
• Distribution and publishing of reports within Fabric

Recap and Future Directions