Microsoft Fabric: Unified Data Analytics and BI Training Course

Module 1 – Getting Started with Microsoft Fabric

• General overview of the platform and its key components.
• Interoperability with Microsoft 365 and other Microsoft services.
• Distinguishing features among Data Factory, Synapse, and Fabric.

Module 2 – Workspace Creation and Administration

• Insight into the structure of Fabric Workspaces.
• Setting up and organizing Workspaces effectively.
• Managing permissions and user access.

Module 3 – The Lakehouse within Fabric

• Understanding the Lakehouse paradigm: the fusion of Data Lake and Data Warehouse.
• Initiating a Lakehouse within the Fabric environment.
• Processes for importing and managing data assets.

Module 4 – Working with Notebooks in Fabric

• Introduction to Notebooks utilizing Python and SQL.
• Creating and executing notebooks inside Fabric.
• Practical applications for exploratory analysis and data transformation.

Module 5 – Pipelines and Visual ETL

• Core ETL principles applied in Microsoft Fabric.
• Designing visual pipelines for data ingestion and transformation.
• Scheduling tasks and monitoring data flow performance.

Module 6 – The Data Warehouse

• Establishing Data Warehouses within Fabric.
• Defining table models and establishing relationships.
• Connecting with external data sources and architectural layers.

Module 7 – The Semantic Model

• Defining the semantic model and its strategic importance.
• Building and refining analytical models.
• Working with measures, hierarchies, and Key Performance Indicators (KPIs).

Module 8 – Report Development in Power BI

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

Course Wrap-up and Future Directions