Model Online / On-Site
Duration
Modules 6 modules

Course Objective & Scope

For organisations that have used Power BI for years, moving to Fabric involves many decisions, from the licensing and capacity model down to the data preparation layer. The programme covers building an inventory of workspaces, semantic models and dataflows, moving from Premium capacity to Fabric SKUs and converting Dataflow Gen1 to Gen2.

Participants migrate a sample Power BI solution to a Lakehouse and Direct Lake architecture and compare performance and cost before and after. The work ends with a migration checklist and phased roadmap adapted to the organisation's environment.

Who Should Attend?

  • BI team leads and managers who administer Power BI
  • BI developers building semantic models and dataflows
  • Data platform and cloud architects
  • Prerequisite: experience with Power BI Service and data modelling

Key Takeaways

  • Inventory existing Power BI assets and their dependencies
  • Assess capacity, licensing and cost impact
  • Move Dataflow Gen1 content to Dataflow Gen2 and pipelines
  • Convert Import models to Direct Lake where appropriate
  • Prepare a phased migration and rollback plan

Curriculum

Power BI and Fabric: What Changes?
  • Premium capacity vs Fabric capacity
  • Licensing, CU consumption and cost model
Inventory and Assessment of the Current Environment
  • Workspace, semantic model and dataflow inventory
  • Dependency analysis with the Scanner API and lineage
Migrating the Data Preparation Layer
  • Converting Dataflow Gen1 to Gen2
  • Target architecture with pipelines and Lakehouse
Converting Semantic Models to Direct Lake
  • Direct Lake requirements and fallback behaviour
  • Performance and refresh comparison
Security, Governance and Monitoring
  • Workspace roles, RLS and OneLake security
  • Monitoring with the Capacity Metrics app
Migration Roadmap
  • Pilot selection and phased migration plan
  • Rollback scenarios and checklist

Other Courses in This Category

  • 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
  • Microsoft Power BI Fundamentals Basic Power BI

    Foundational Microsoft Power BI training covering data connections, Power Query transformations, Star Schema data modeling, basic DAX measures, and interactive dashboards.

    Business Intelligence & Analytics Corporate
    Live Course
    9 modules
    View

Get in touch