Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Overview of Microsoft Fabric

• A comprehensive look at the platform’s architecture and key components
• Synergy with Microsoft 365 and other Microsoft service offerings
• Distinguishing between Data Factory, Synapse, and Fabric

Module 2 – Workspace Creation and Administration

• Gaining a deep understanding of Fabric Workspaces
• Strategies for creating and structuring Workspaces effectively
• Governing permissions and managing user access

Module 3 – The Fabric Lakehouse

• The Lakehouse paradigm: unifying Data Lake and Data Warehouse capabilities
• Implementing a Lakehouse within the Fabric environment
• Processes for importing and administering data assets

Module 4 – Notebooks in Fabric

• Introduction to Notebook functionalities using Python and SQL
• Developing and executing notebooks inside Fabric
• Applying notebooks for exploratory analysis and data transformation tasks

Module 5 – Visual ETL Pipelines

• ETL principles as applied in Microsoft Fabric
• Constructing visual pipelines for efficient data ingestion and transformation
• Scheduling and overseeing data flow operations

Module 6 – Data Warehouse

• Provisioning Data Warehouses within Fabric
• Designing table models and defining relationships
• Interfacing with external data sources and integrated layers

Module 7 – Semantic Models

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

Module 8 – Developing Reports in Power BI

• Establishing connections to the semantic model
• Adhering to best practices in dashboard architecture and design
• Distribution and publishing of reports within the Fabric ecosystem

Recap and Path Forward