Model Online / On-Site
Duration
Modules 6 modules

Course Objective & Scope

Microsoft Fabric unifies data integration, data engineering, warehousing, real-time analytics and Power BI in a single SaaS platform built on OneLake. The programme explains what each component does, the workspace and capacity concepts, and which item to choose for which scenario.

Hands-on, participants create a Lakehouse, load data with a Data Factory pipeline and Dataflow Gen2, build medallion (bronze-silver-gold) layers and publish a Power BI report in Direct Lake mode. The output is a draft Fabric starter architecture suited to the organisation.

Who Should Attend?

  • BI and data teams evaluating Fabric
  • Power BI developers and reporting analysts
  • Software and IT specialists getting started with data engineering
  • Technical managers involved in data platform decisions

Key Takeaways

  • Explain Fabric components and the OneLake architecture
  • Choose between Lakehouse and Warehouse by scenario
  • Build a data loading flow with pipelines and Dataflow Gen2
  • Organise data with medallion layers
  • Publish reports on a Direct Lake semantic model

Curriculum

Fabric Architecture and OneLake
  • Workloads, workspaces and capacity concepts
  • OneLake, shortcuts and the Delta Parquet format
Lakehouse and Data Warehouse
  • Lakehouse tables and the SQL analytics endpoint
  • T-SQL-based modelling with Warehouse
Data Integration with Data Factory
  • Pipelines and the Copy activity
  • Low-code transformation with Dataflow Gen2
Notebooks and Medallion Architecture
  • Basic transformations with Spark notebooks
  • Bronze-silver-gold layer design
Power BI with Direct Lake
  • Direct Lake vs Import vs DirectQuery
  • Semantic models and report publishing
Governance and Starter Architecture
  • Access roles, Purview integration and monitoring
  • Draft starter architecture for the organisation

Other Courses in This Category

  • Migrating from Power BI to Microsoft Fabric

    Moving Power BI Premium/Pro environments to Fabric capacity, converting dataflows to Gen2 and sources to Lakehouse and Direct Lake, so BI teams produce a risk-controlled migration roadmap.

    Business Intelligence & Analytics Corporate
    Live Course
    6 modules
    View
  • Data Analysis with Excel

    PivotTables, XLOOKUP, dynamic array functions (FILTER, UNIQUE, SORT), conditional aggregation, What-If analysis and Power Pivot, so business users perform fast and reliable analysis in Excel.

    Business Intelligence & Analytics Corporate
    Live Course
    6 modules
    View
  • Python in Excel: Automating Analysis with pandas

    Python in Excel (=PY), pandas for cleaning and transforming data, openpyxl report automation and matplotlib charts, helping Excel users scale repetitive analysis with Python.

    Business Intelligence & Analytics Corporate
    Live Course
    6 modules
    View
  • SQL and Power BI for Business Analysts

    Querying databases with SELECT, JOIN, GROUP BY, CTEs and window functions, then modelling and reporting in Power BI, so business analysts produce their own analyses without depending on IT.

    Business Intelligence & Analytics Corporate
    Live Course
    6 modules
    View
  • Tableau for Data Analysis and Dashboards

    Data connections, dimensions and measures, calculated fields, LOD expressions, parameters and interactive dashboard design in Tableau Desktop, plus publishing to Tableau Cloud for visual analysis.

    Business Intelligence & Analytics Corporate
    Live Course
    6 modules
    View
  • AI-Assisted Data Analysis and Reporting

    Copilot in Power BI and Excel, data analysis with ChatGPT/Claude, natural-language querying, automated summaries and insight generation with output verification, so analysts turn AI output into trustworthy reports.

    Business Intelligence & Analytics Corporate
    Live Course
    6 modules
    View

Get in touch