Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Getting Started with Microsoft Fabric

• Platform overview and key architectural components
• ​Integration strategies with Microsoft 365 and adjacent Microsoft services
• Distinguishing between Data Factory, Synapse, and Fabric

Module 2 – Workspace Creation and Administration

• ​Exploring the concept of Fabric Workspaces
• Setting up and structuring Workspaces effectively
• Managing permissions and user access

Module 3 – The Lakehouse within Fabric

• The Lakehouse paradigm: merging Data Lake and Data Warehouse capabilities
• Provisioning a Lakehouse in the Fabric environment
• Techniques for data ingestion and management

Module 4 – Utilizing Notebooks in Fabric

• Introduction to Notebooks supporting Python and SQL
• Executing and creating notebooks within Fabric
• Applying notebooks for exploratory insights and data transformation

Module 5 – Visual Pipelines (ETL)

• ETL principles applied in Microsoft Fabric
• Constructing visual pipelines for data loading and processing
• Scheduling tasks and monitoring data flow health

Module 6 – The Data Warehouse

• Setting up Data Warehouses in Fabric
• Designing table structures and defining relationships
• Connecting with external data sources and other architectural layers

Module 7 – The Semantic Model

• The role and importance of semantic modeling
• Building and refining analytical models
• Defining measures, hierarchies, and key performance indicators (KPIs)

Module 8 – Developing Reports in Power BI

• Linking reports to the underlying semantic model
• Effective dashboard design strategies
• Distribution and publishing of reports within Fabric

Recap and Future Pathways