Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Introduction to Microsoft Fabric

• A general overview of the platform and its key constituent parts
• How Fabric integrates with Microsoft 365 and other Microsoft services
• Key distinctions between Data Factory, Synapse, and Fabric

Module 2 – Creating and Managing Workspaces

• Gaining a deep understanding of Fabric Workspaces
• Processes for creating and organizing Workspaces efficiently
• Managing permissions and access controls

Module 3 – Lakehouse in Fabric

• The Lakehouse concept: merging the capabilities of Data Lakes and Data Warehouses
• Steps for establishing a Lakehouse within Fabric
• Techniques for importing and managing data resources

Module 4 – Notebooks in Fabric

• An introduction to Notebooks utilizing Python and SQL
• Creating and executing notebooks directly within the Fabric interface
• Applying notebooks for exploratory analysis and data transformation tasks

Module 5 – Pipelines (Visual ETL)

• Core ETL concepts as they apply to Microsoft Fabric
• Developing visual pipelines to handle data ingestion and transformation
• Implementing scheduling and monitoring for data flows

Module 6 – Data Warehouse

• Setting up Data Warehouses within the Fabric environment
• Defining table models and establishing relationships
• Integrating with external data sources and other architectural layers

Module 7 – Semantic Model

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

Module 8 – Building Reports in Power BI

• Establishing connections to the semantic model
• Adopting best practices for effective dashboard design
• Processes for sharing and publishing reports within Fabric

Wrap-up and Future Pathways