Microsoft Fabric in Controlling

Microsoft Fabric Overview

• Overview of OneLake as a central storage body and its technical features.
• Distinction between lakehouse and warehouse.
• Shortcut as a link to other data sources without an ETL process.
• Semantic model based on OneLake.

Medallion architecture

• Bronze: Raw data, directly from source systems (e.g., ERP, CRM).
• Silver: cleaned and harmonized data (e.g., duplicates removed, formats standardized).
• Gold: aggregated, business-ready data for reporting and analysis (e.g., KPIs, forecast data).
• Practical example: All three stages are completed using Dataflow Gen 2.

Data integration in OneLake

• Centralized DataFlows versus decentralized Power Query processes.
• Brief overview of Notebook/PySpark: for very large amounts of data or complex cleanups.
• Brief overview of Azure Data Factory/Pipelines: Orchestration of more complex loads, such as e-mail for successful and failed processes.

Data Activator for Automation

• Alerts and triggers for controlling key figures.
• Automated workflows (e.g., notification in case of deviations).

Hands-on demonstration

• Creating a simple report from OneLake data.
• Create data flow and visualize it in Excel or Power BI.