IBA - Innovative Business Practices
TR/EN
Power BI & Fabric TrainingTraining

Power BI & Microsoft Fabric Training

Our Power BI trainings cover the full path from raw data to a dashboard ready for a management presentation. Participants work with their own department’s data. The Microsoft Fabric trainings bring every analytics layer, from data integration to reporting, into one platform and work through these layers step by step on a single case selected from your organisation.

Power BI & Fabric Training

Trainings in This Category

Select a training to see its agenda, project cases and technical requirements.

Power BI Basic

Basic — Data Analysis and Reporting Fundamentals Training

01Training Overview

Duration
2 Days
Training Hours
09:30 – 16:30
Maximum Participants
10 Participants
Hands-on Ratio
80% Hands-on / 20% Theory
Certificate
Participants receive an IBA Consultancy Certificate of Participation at the end of the training.
Format
Online, On-site or Hybrid — set according to the organisation's preference.
Prerequisites
No software development knowledge is required. Basic Excel skills (formulas, working with tables) are sufficient.
Training Objective

This two-day training teaches participants to connect raw data in Power BI, build a basic data model, and prepare and share an interactive report. The programme covers connecting to a data source and basic Power Query transformations, simple data modelling, basic visualisation, and the basics of publishing/sharing in the Power BI Service through hands-on work.

This training is shorter and more introductory than IBA's PL-300 training (Microsoft Power BI Data Analysis and Visualisation, 4 days): it does not cover topics such as writing advanced measures with DAX, row-level security (RLS) and scheduled refresh. The organisation can later take its reporting to an advanced level with PL-300.

By the end of the training, participants can connect their own department's raw data, visualise it in a basic report and share it.

Technical Content

Power BI Fundamentals and Connecting Data

  • Introduction to Power BI Desktop and its interface
  • Connecting to a data source and basic Power Query transformations
  • Simple data modelling and relationships between tables

Visualisation and Sharing

  • Basic visualisation types and report design
  • Filters and slicers
  • Basics of publishing and sharing in the Power BI Service

02Exercises and Project Scenarios

Option A

Management Performance Dashboard

A basic dashboard tracking senior management metrics such as subscriber/member numbers, revenue and growth.

Option B

Sales and Stock Performance Dashboard

A basic dashboard tracking sales and stock levels by store/category.

Whichever case is chosen, the technical scope and outcomes of the training stay the same — the same data connection, modelling and visualisation topics are covered. The training is based on a single case chosen by the participant from their own department, and this case is built up step by step over the two days: on Day 1, the data source is connected and cleaned, and a basic data model is completed by creating relationships between tables; on Day 2, a basic set of visuals is created, filters/slicers are added and the report is published to the Power BI Service. The cases come from the same family as those used in IBA's PL-300 training; a different case from the organisation's own dataset (sales, finance, operations, etc.) can also be proposed — provided it is of similar scope, this does not affect the duration or price of the training. The organisation can later take this case to an advanced level with PL-300, including DAX, RLS and scheduled refresh.

03Training Agenda (2 Days)

The agenda builds up the chosen case day by day; the first day focuses on connecting data and modelling, the second on visualisation and sharing.

  1. Day 1 — Connecting Data and the Basic Model

    • Introduction to Power BI Desktop and its interface
    • Exercise 1: Connecting the case data to Power BI Desktop and cleaning it with Power Query
    • The concept of relationships between tables
    • Exercise 2: Building a simple data model with relationships between tables
    • Basic aggregation measures
    • End-of-Day Deliverable: Completing a working basic data model
  2. Day 2 — Visualisation, Interaction and Sharing

    • Basic visualisation types and choosing the right chart
    • Exercise 3: Creating a basic set of visuals for the case data
    • Adding interaction with filters and slicers
    • Exercise 4: Making the report interactive with filters/slicers
    • Introduction to the Power BI Service and publishing steps
    • Final Deliverable: Publishing and sharing the report in the Power BI Service
    • Overall review, Q&A and certificate presentation

04Technical Requirements

Computer

1 per participant (Windows or macOS), with internet access

Software Installation

Power BI Desktop (free) — must be installed before the training

Browser

Microsoft Edge or Google Chrome — for the Power BI Service steps

Account

Microsoft work/school account, or a Power BI Pro trial account opened for the training

Licensing

No licence purchase is required for this training.

Power BI Desktop is completely free, and all data connection, modelling and visualisation work is carried out in it.

Microsoft's free Pro trial licence is used for the sharing steps in the Power BI Service; this adds no cost to the organisation's existing Microsoft 365 licences.

05Learning Outcomes

Connect data

Connect their own department's raw data to Power BI and clean it.

Build a simple model

Create a basic data model by setting up relationships between tables.

Prepare reports

Design a basic visual report using the right chart types.

Add interaction

Make a report interactive with filters and slicers.

Share

Publish a report in the Power BI Service and share it with the relevant people.

PL-300 (Power BI Advanced)

Data Analysis and Visualisation Training

01Training Overview

Duration
4 Days
Training Hours
09:30 – 16:30
Maximum Participants
10 Participants
Hands-on Ratio
80% Hands-on / 20% Theory
Certificate
Participants receive an IBA Consultancy Certificate of Participation at the end of the training.
Format
Online, On-site or Hybrid — set according to the organisation's preference.
Prerequisites
No software development knowledge is required. Basic Excel skills (formulas, working with tables) are recommended.
Training Objective

This training gives participants the ability to manage an end-to-end data analysis process on the Power BI platform. Throughout the programme, participants learn data connection and cleaning, relational data modelling, writing calculations with DAX and interactive dashboard design by working on a real dataset.

The training covers the full process from raw data to a dashboard ready for management presentation. In their chosen case, participants first connect the data and build its model, then write DAX measures that answer business questions, and finally bring these measures together in an interactive dashboard and share it securely through the Power BI Service.

By the end of the training, participants are report developers who can build their own story from their own data rather than applying ready-made templates.

Technical Content

Data Preparation and Modelling

  • The Power BI ecosystem: how Desktop, Service and Gateway relate
  • Licensing models: differences between Free, Pro and Premium
  • Connecting to data sources (Excel, SQL, SharePoint, web)
  • Cleaning and transforming data with Power Query
  • Editing queries and the logic of applied steps
  • Building a relational data model: table relationships and cardinality
  • Introduction to star schema

DAX and Analysis

  • The difference between calculated columns and measures
  • Core DAX functions: SUM, CALCULATE, FILTER
  • Time Intelligence functions: YTD, MTD, period-over-period comparison
  • Performance analysis visuals: KPI, Gauge, Top N

Visualisation, Sharing and Governance

  • Chart types and principles for choosing the right visual
  • Interaction with filtering, slicers and bookmarks
  • Publishing to the Power BI Service and workspace management
  • Gateway setup and automatic data refresh
  • Role-based data security (Row-Level Security)

02Exercises and Project Scenarios

Option A

Management Performance Dashboard

A dashboard tracking senior management metrics such as subscriber/member numbers, revenue, churn and growth. It is extended with time-based comparisons and KPI tracking.

Option B

Sales and Stock Performance Dashboard

A dashboard tracking sales, stock turnover and campaign impact by store/category. It is extended with regional comparison and slicer-based analysis.

Whichever case is chosen, the technical scope and outcomes of the training stay the same — the same Power Query, data modelling, DAX and dashboard design topics are covered. A single dashboard case is chosen for the training and built up step by step over the four days: on Day 1, the data source is connected and cleaned and the basic relational model is built; on Day 2, basic DAX measures and the first set of visuals are added; on Day 3, advanced DAX (time-based analysis) and interactive dashboard design are added; on Day 4, the sharing, automatic refresh and data security layer is set up. A different case from the organisation's own dataset (sales, finance, operations, etc.) can also be proposed — provided it is of similar scope, changing the scenario does not affect the duration or price of the training.

03Training Agenda (4 Days)

The agenda works through the dashboard case chosen before the training. Every step below that mentions "the chosen case" is applied to the scenario the organisation prefers (Management Performance Dashboard / Sales and Stock Performance Dashboard, or an organisation-specific dataset).

  1. Day 1 — Data Connection, Cleaning and Building the Basic Model

    • The Power BI ecosystem: how Desktop, Service and Gateway relate
    • Licensing models: differences between Free, Pro and Premium
    • Connecting to data sources (Excel, SQL, SharePoint, web)
    • Cleaning and transforming data with Power Query
    • Editing queries and the logic of applied steps
    • Building a relational data model: table relationships and cardinality
    • Introduction to star schema
    • Exercise 1: Connecting the chosen case to its data source and cleaning the data
    • Exercise 2: Creating relationships between tables
  2. Day 2 — Calculations with DAX and Basic Visualisations

    • Introduction to DAX: the difference between calculated columns and measures
    • Core DAX functions: SUM, CALCULATE, FILTER
    • Exercise 3: Writing basic measures that answer business questions
    • Basic visuals: Card, Pie Chart, Table
    • Chart types: Column, Line, Scatter, Funnel
    • Principles for choosing the right chart for the right data
    • Exercise 4: Creating the first set of visuals
    • Visual formatting and on-brand design
  3. Day 3 — Advanced DAX and Interactive Dashboard Design

    • Time Intelligence functions: YTD, MTD, year-on-year comparison
    • Exercise 5: Writing time-based analysis measures
    • Performance analysis visuals: KPI, Gauge, Top N
    • Exercise 6: Building a performance indicator panel
    • Filtering, slicers and page-level interaction
    • Switching between scenario-based views with bookmarks
    • Exercise 7: Completing the interactive dashboard
    • Introduction to Power BI integration with Power Apps
  4. Day 4 — Sharing, Governance and Final Deliverable

    • Publishing to the Power BI Service and workspace management
    • Exercise 8: Publishing the report to the Service
    • Gateway setup and automatic data refresh
    • Exercise 9: Designing a scheduled refresh plan
    • Role-based data security (Row-Level Security)
    • Exercise 10: Defining department-based data access with RLS
    • Sharing, permission management and turning dashboards into an app
    • Final Deliverable: End-to-end testing and publishing of the chosen case
    • Overall review, Q&A and certificate presentation

04Technical Requirements

Computer

1 per participant (Windows or macOS), with internet access

Software Installation

Power BI Desktop (free) — must be installed before the training

Browser

Microsoft Edge or Google Chrome — for the Power BI Service steps

Account

Microsoft work/school account, or a Power BI Pro trial account opened for the training

Licensing

No licence purchase is required for this training.

Power BI Desktop is completely free, and all data connection, modelling, DAX and visualisation work is carried out in it.

Microsoft's free Pro trial licence is used for the sharing and automatic refresh steps in the Power BI Service; this adds no cost to the organisation's existing Microsoft 365 licences.

05Learning Outcomes

Develop reports

Connect and clean raw data and turn it into a dashboard ready to present to management.

Build a data model

Link multiple tables with the correct relationship types.

Write calculations

Create DAX measures that answer business questions (growth rate, period-over-period comparison).

Design dashboards

Create user-friendly screens that support decision-making, with filtering and interaction.

Publish

Move a report to the Power BI Service and share it securely.

Keep data up to date

Set up a live data connection with a Gateway and schedule automatic refresh.

DP-600 (Microsoft Fabric Basic)

Introduction to an End-to-End Data Platform — Beginner Training

01Training Overview

Duration
2 Days
Training Hours
09:30 – 16:30
Maximum Participants
12 Participants
Hands-on Ratio
80% Hands-on / 20% Theory
Certificate
Participants receive an IBA Consultancy Certificate of Participation at the end of the training.
Format
Online, On-site or Hybrid — set according to the organisation's preference.
Prerequisites
No software development knowledge is required. Basic knowledge of data/tables and Excel skills are sufficient; SQL knowledge is useful but not required.
Training Objective

This training teaches participants, hands-on, how to build an enterprise data platform on Microsoft Fabric and make raw data ready for reporting. Throughout the programme they work with OneLake architecture, Lakehouse and Warehouse structures, data ingestion with Dataflow Gen2 and Pipelines, transformation with Notebooks and Spark, and the medallion (bronze/silver/gold) layer approach.

The topics follow a single business scenario. A case is chosen with the organisation before the training. On the first day the case's raw data is brought into Fabric and cleaned; on the second day it is transformed, moved into a gold layer with a star schema, and every step is joined into one automated flow.

The training ends at a gold layer that is ready for reporting. Turning this data into a Power BI data model and a management report is covered in IBA Consultancy's Power BI trainings; the last part of the second day shows this step with a Direct Lake semantic model example.

By the end of the training, participants can build a data platform that brings their organisation's data into Fabric, cleans and transforms it, and keeps it up to date automatically.

Technical Content

Microsoft Fabric Platform and Architecture

  • Fabric's SaaS-based unified analytics platform and how it differs from the traditional data warehouse approach
  • Tenant, capacity (F SKU and trial capacity) and Workspace concepts, and using the Fabric portal
  • Which need each component serves: OneLake, Lakehouse, Warehouse, Data Factory and Notebook
  • Organising data in bronze, silver and gold layers with the medallion architecture

OneLake and Lakehouse

  • The difference between the Files and Tables areas in a Lakehouse, and the Delta Lake table structure
  • Loading data by uploading a file and converting the uploaded file into a Delta table
  • Connecting different sources to OneLake with Shortcuts, without copying the data
  • Querying Lakehouse tables with T-SQL through the SQL analytics endpoint

Data Ingestion and Preparation (Data Factory)

  • Data types, filtering, Merge and Append with Dataflow Gen2 and Power Query Online
  • Handling errors and null values, and setting a Lakehouse as the data destination
  • Source-to-target connections with the Pipeline Copy Activity and scheduled loads with a Schedule Trigger
  • Following run history and basic error analysis in the Monitoring hub
  • Choosing between file upload, Dataflow Gen2, Pipeline, Notebook, Shortcut and Mirroring for each scenario

Transformation with Notebooks, Spark and Warehouse

  • How Notebooks work, and reading Lakehouse tables with PySpark DataFrames and Spark SQL
  • Writing transformed data, with null checks and calculated columns, to a new Delta table
  • The differences between a Fabric Warehouse and a Lakehouse, and when to choose which
  • Building a star schema with Fact and Dimension tables using T-SQL Views and CTAS

Towards Reporting, Capacity and Copilot

  • Creating a Direct Lake semantic model from the gold layer and how it feeds Power BI
  • Basic rules for capacity consumption, cost awareness and scheduling workloads
  • An overview of AI support from Fabric Copilot for Dataflows, Notebooks and SQL

02Exercises and Project Scenarios

Option A

Sales and Stock Data Platform

Retail sales, product, store and customer data is brought into Fabric, cleaned and turned into a gold layer made of FactSales with DimDate, DimProduct, DimStore and DimCustomer. It is extended with automatic nightly loads of sales and stock data.

Option B

Production and Operations Data Platform

Data from the production line and operational systems is collected and cleaned in a Lakehouse. Production volumes, downtime and efficiency data are moved into a Fact/Dimension structure in a Warehouse and kept up to date with scheduled loads.

Option C

Financial Performance Data Platform

Income and expense data from the accounting/ERP system is combined with budget data. A gold layer is built that is ready for budget-versus-actual comparison and department-level cost analysis.

Whichever case is chosen, the technical scope and outcomes of the training stay the same. On Day 1, a Workspace and Lakehouse are created for the case, raw data is loaded into the bronze layer, cleaned with Dataflow Gen2 into the silver layer, and the load is scheduled with a Pipeline. On Day 2, the silver data is transformed with Notebooks and Spark, the gold layer is built with Fact/Dimension tables in a Warehouse, and every step is joined into a single Pipeline flow and monitored. At the end of the day, a semantic model built on the gold layer shows how the data moves on to Power BI. Participants leave with one data platform that runs automatically from source to gold layer.

03Training Agenda (2 Days)

The agenda works through the project case chosen before the training. Every step below that mentions "the chosen case" is applied to the scenario the organisation prefers (Sales and Stock / Production and Operations / Financial Performance, or an organisation-specific process). The review time at the end of each day is set aside for any extra work the exercises need.

  1. Day 1 — Fabric Basics and Data Ingestion (Bronze → Silver)

    • Fabric's SaaS-based platform; tenant, capacity (F SKU and trial) and Workspace concepts
    • An overall map of Fabric components and the medallion (bronze/silver/gold) architecture
    • How OneLake works, the Files/Tables split and the Delta Lake table structure
    • Exercise 1: Creating a Workspace and Lakehouse for the chosen case, loading raw data into the bronze layer and converting it into a Delta table
    • Exercise 2: Connecting a second source with a Shortcut and querying it through the SQL analytics endpoint
    • Preparing data with Dataflow Gen2 and Power Query Online; handling errors and null values
    • Exercise 3: Cleaning the chosen case's data with Dataflow Gen2 and writing it to the silver layer
    • The Pipeline concept, Copy Activity and scheduled loads with a Schedule Trigger
    • Exercise 4: Building a scheduled load flow for the chosen case and monitoring it in the Monitoring hub
    • End-of-day review: choosing an ingestion method (Dataflow, Pipeline, Notebook, Shortcut, Mirroring)
  2. Day 2 — Transformation, Gold Layer and End-to-End Flow (Silver → Gold)

    • How Notebooks work; an introduction to PySpark DataFrames and Spark SQL
    • Exercise 5: Reading the silver table in a Notebook, checking nulls, adding a calculated column and writing it to a gold Delta table
    • The differences between a Fabric Warehouse and a Lakehouse; Fact and Dimension tables and the star schema approach
    • Exercise 6: Building the chosen case's gold layer in a Warehouse as Fact/Dimension tables with T-SQL Views and CTAS
    • Exercise 7: Joining the Dataflow, Notebook and load steps into a single Pipeline flow
    • Exercise 8: Running the end-to-end flow, monitoring it in the Monitoring hub and analysing errors
    • Towards reporting: creating a Direct Lake semantic model from the gold layer (trainer demo)
    • Capacity consumption and cost awareness; an overview of Fabric Copilot
    • Final delivery: testing the chosen case's flow that runs automatically from source to gold layer, overall review and certificates

04Technical Requirements

Computer

1 per participant (Windows or macOS), with an uninterrupted internet connection

Browser

Microsoft Edge or Google Chrome (latest version). All work is done in the browser; no software needs to be installed.

Access

Microsoft Fabric access, trial capacity and participant Workspace permissions are provided by the organisation. Access must be tested at least 2 working days before the training; the trainer helps with the setup.

Licensing

No additional licence purchase is needed for this training.

All exercises run on Microsoft Fabric trial capacity. To open trial capacity in the organisation's tenant, an administrator must enable the related tenant setting.

The Copilot part is shown as a demo in the trainer environment. Copilot is not available on trial capacity, so using Copilot features in the organisation's own environment requires a paid Fabric capacity (F SKU).

05Learning Outcomes

Build a data platform

Create a Fabric Workspace and Lakehouse and bring the organisation's data sources together in one place on OneLake.

Ingest and prepare data

Clean raw data with Dataflow Gen2 and Pipelines and load it into a Lakehouse on a schedule.

Transform data

Run basic transformations with Spark in a Notebook and write the result to a Delta table.

Design a layered architecture

Organise data in bronze, silver and gold layers and build the gold layer as a star schema.

Automate and monitor the process

Join ingestion and transformation steps into a single Pipeline flow, monitor it in the Monitoring hub and analyse errors.

Choose the right tool

Make a reasoned choice between Lakehouse and Warehouse, and between Dataflow, Pipeline, Notebook, Shortcut and Mirroring, for a given data need.

DP-700 (Microsoft Fabric Advanced)

Enterprise Data Engineering and Analytics Solutions — Advanced Training

01Training Overview

Duration
5 Days
Training Hours
09:30 – 16:30
Maximum Participants
10 Participants
Hands-on Ratio
80% Hands-on / 20% Theory
Certificate
Participants will receive an IBA Consultancy Certificate of Participation at the end of the training.
Format
Online, On-site or Hybrid — based on the organisation's preference.
Prerequisites
Knowledge at the level of the Microsoft Fabric Beginner Training (Fabric core components, SQL querying, data warehousing and dimensional modelling, Power BI data modelling, basic ETL processes) or equivalent experience is recommended.
Training Objective

This training aims to take the foundations laid in Fabric Beginner to the level where participants can build a production-ready data platform at enterprise scale. Throughout the programme, participants move the data of the case chosen in Fabric Beginner into a Medallion architecture made up of Bronze, Silver and Gold layers, develop metadata-driven parameterised pipelines, apply PySpark/Spark SQL transformations in Notebooks, and build an enterprise Power BI solution on top with a Direct Lake-compatible Semantic Model.

What sets this training apart is that topics are not covered through disconnected examples but by scaling the case chosen in Fabric Beginner up to enterprise level. Over five days, the same case is expanded step by step with data integration, data engineering, data warehousing, security and lifecycle management layers.

For participants who have not taken Fabric Beginner, the same case options (Sales and Stock Analysis / Production and Operations / Financial Performance) are set up quickly on the first day and built upon.

By the end of the training, participants do not just have a simple reporting solution; they own a production-ready enterprise Fabric platform equipped with security, monitoring and DevOps processes.

Technical Content

Enterprise Fabric Architecture and the Medallion Approach

  • Designing the Tenant, Capacity, Domain and Workspace organisation to enterprise standards; separating Development, Test and Production environments
  • Making the right architectural choice between Lakehouse, Warehouse and Eventhouse for each use case, and applying data discovery with OneLake Catalog
  • Building a Medallion architecture of Bronze, Silver and Gold layers; separating the responsibility of each layer (raw data storage, cleansing/standardisation, applying business rules)
  • Batch and streaming data ingestion, full/incremental load strategies, and comparing Pipeline, Copy Job, Dataflow Gen2 and Notebook approaches by scenario

Metadata-Driven and Parameterised Pipeline Development

  • Designing dynamic flows using pipeline parameters, Lookup and ForEach activities, and If Condition/Switch
  • Hands-on parameterised loading of multiple tables using a parent-child pipeline structure and a metadata control table
  • Setting up trigger and schedule management, error handling and notification processes to enterprise standards

Data Engineering with Fabric Spark

  • Hands-on demonstration of Fabric Spark architecture, Driver/Executor concepts, Lazy Evaluation and partitioning using PySpark DataFrames
  • Data transformation with Select, Filter, WithColumn, Join, GroupBy/Aggregate and Window Functions; data quality checks with null/duplicate handling and schema validation
  • Temporary Views, CTEs and cross-layer data transformations with Spark SQL, compared with the DataFrame API

Delta Lake Management

  • Hands-on demonstration of the Delta Transaction Log, ACID transactions and Schema Enforcement/Evolution in the Bronze-Silver-Gold flow
  • Developing incremental load processes with Merge, Update, Delete and Upsert scenarios
  • Partition strategies, table maintenance, Time Travel and the small-file problem from a performance optimisation perspective

Data Warehouse and Dimensional Modelling

  • Comparing Lakehouse and Warehouse use cases through SQL Endpoint, T-SQL, Stored Procedure and View capabilities
  • Dimensional data model design with Star Schema and Snowflake Schema, Surrogate/Natural Keys, grain definition and Slowly Changing Dimensions
  • Building Fact and Dimension tables in the Gold layer, and centralising data quality metrics and business rules

Semantic Model, Direct Lake and Power BI

  • Comparing Import, DirectQuery and Direct Lake connection modes; building a Direct Lake-compatible Semantic Model on the Gold layer
  • Developing basic and advanced DAX measures with the Measure Table approach and Calculation Groups
  • Preparing a secured management report with Row-Level Security and Object-Level Security and sharing it through a Fabric Workspace

Fabric Security, DevOps and Monitoring

  • Planning permissions at Tenant/Capacity/Workspace/Item level, Workspace roles (Viewer/Contributor/Member/Admin) and OneLake security
  • Controlled content promotion between Development, Test and Production environments with Deployment Pipelines; introduction to Git integration and branching strategies
  • Monitoring pipeline/notebook/Semantic Model run history via the Monitoring Hub; log table design and source-to-target row count reconciliation

Capacity Management and Real-Time Intelligence (covered hands-on on Day 5)

  • Fabric Capacity and the Capacity Unit concept; assessing how pipeline, Spark and Semantic Model workloads affect resource consumption
  • Introduction to real-time analytics with Eventstream, Eventhouse, KQL Database and Real-Time Dashboard; operational alert scenarios with Activator

02Exercises and Project Scenarios

Option A

Sales and Stock Analysis System

The sales and stock analysis system built in Fabric Beginner is scaled up to enterprise level by moving SQL Server sales transactions, Excel product targets, CSV store/stock information, and customer and campaign data into the Bronze-Silver-Gold layers. It is turned into a management report secured with Row-Level Security by region and store manager.

Option B

Production and Operations Reporting System

The production/operations reporting system built in Fabric Beginner is scaled up to enterprise level by layering production line, downtime and efficiency data with a Medallion architecture. Periodic production reports are automated with parameterised pipelines and incremental loading.

Option C

Financial Performance Reporting System

The financial performance system built in Fabric Beginner is scaled up to enterprise level by ingesting accounting/ERP data into the Bronze-Silver-Gold layers and moving it into a dimensional model. It is turned into a board report secured with Row-Level Security by department.

Whichever case is chosen, the technical scope and outcomes of the training stay the same; the same Medallion architecture, parameterised pipeline, Spark/Delta Lake and Direct Lake Semantic Model topics are covered. On Day 1, the data sources of the chosen case are brought into the enterprise Fabric architecture and loaded into the Bronze layer with a metadata-driven parameterised pipeline; on Day 2, the Silver and Gold layers are built with Notebooks/Spark and Delta Lake; on Day 3, a dimensional data model is built on the Gold layer, along with a Direct Lake-compatible Semantic Model and a Power BI management report; on Day 4, the solution is secured with Row-Level Security and made production-ready with Deployment Pipelines and monitoring mechanisms; on Day 5, capacity optimisation and, where needed, Real-Time Intelligence components are added and teams present the solution end to end. The organisation's own process can also be used as the case; provided it is of similar scope, this does not affect the duration or price of the training.

03Training Agenda (5 Days)

The agenda is delivered by scaling the project case chosen in Fabric Beginner (or before the training) up to enterprise level. Every step below that refers to "the chosen case" is applied to the organisation's preferred scenario (Sales and Stock Analysis / Production and Operations / Financial Performance, or an organisation-specific process).

  1. Day 1 — Enterprise Fabric Architecture and Data Integration

    • Tenant, Capacity, Domain and Workspace organisation; designing Development/Test/Production environments to enterprise standards
    • Choosing between Lakehouse, Warehouse and Eventhouse; data discovery with OneLake Catalog
    • Medallion architecture: the purpose and responsibilities of the Bronze, Silver and Gold layers
    • Batch/streaming data ingestion, full/incremental load strategies; comparing Pipeline, Copy Job, Dataflow Gen2 and Notebook
    • Pipeline parameters, Lookup/ForEach activities, If Condition/Switch and the parent-child pipeline structure
    • Exercise 1: Creating a metadata control table for the chosen case and loading multiple source tables into the Bronze layer with parameters
    • Exercise 2: Logging successful/failed loads and recording pipeline run information
  2. Day 2 — Data Engineering with Fabric Spark, PySpark and Delta Lake

    • Fabric Spark architecture: Driver/Executor, Lazy Evaluation, Transformation/Action and partition concepts
    • Data transformation with PySpark using Select/Filter/WithColumn, Join, GroupBy/Aggregate and Window Functions
    • Handling null/duplicate values, schema validation and data quality checks; reusable transformation functions
    • Temporary Views, CTEs and cross-layer data transformation with Spark SQL, compared with the DataFrame API
    • Delta Lake architecture: Transaction Log, ACID transactions, Schema Enforcement/Evolution
    • Exercise 3: Reading the chosen case from the Bronze layer and producing clean data in the Silver layer with schema/data type checks and separation of invalid records
    • Exercise 4: Incremental loading with Delta Merge and adding technical audit columns
    • Exercise 5: Building Gold layer tables by applying business rules
  3. Day 3 — Data Warehouse, Dimensional Modelling and Power BI

    • Lakehouse and Warehouse design decisions; using SQL Endpoint, T-SQL, Stored Procedures and Views
    • Dimensional data modelling: Star Schema, Snowflake Schema, Surrogate/Natural Keys, grain definition, Slowly Changing Dimensions
    • Exercise 6: Building Fact and Dimension tables in the Gold layer for the chosen case, and centralising data quality metrics and business rules
    • Semantic Model architecture: comparing Import, DirectQuery and Direct Lake; how Direct Lake works
    • Measure Table approach, Calculation Groups and DAX measure development (basic and advanced)
    • Exercise 7: Creating a Direct Lake-compatible Semantic Model from the Gold layer, setting up Fact/Dimension relationships and preparing DAX measures
    • Exercise 8: Creating a Row-Level Security role, preparing the management report and sharing it through a Fabric Workspace
  4. Day 4 — Fabric Security, DevOps and Monitoring

    • Permissions at Tenant/Capacity/Workspace/Item level; Workspace roles (Viewer/Contributor/Member/Admin)
    • Overview of Row-Level Security, Object-Level Security, OneLake security, sensitivity labels and Microsoft Purview integration
    • Exercise 9: Defining department/region-based access rules at Workspace and OLS/RLS level for the chosen case
    • Promoting content between Development, Test and Production environments with Deployment Pipelines; Deployment Rules
    • Introduction to Git integration: branching strategies, source control, notebook/pipeline version management
    • Exercise 10: Setting up a Deployment Pipeline for the chosen case's solution and running a test-to-production promotion scenario
    • Monitoring pipeline/notebook/Semantic Model run history with the Monitoring Hub; log table design, Run ID usage, retry and alert mechanisms
    • Exercise 11: Building a data quality log mechanism that checks source-to-target row count reconciliation
  5. Day 5 — Capacity, Real-Time Intelligence and End-to-End Project

    • Fabric Capacity and the Capacity Unit concept; how pipeline, Spark and Semantic Model workloads affect resource consumption
    • Query and model optimisation, data size/partition strategy, and balancing cost and performance through capacity monitoring
    • Introduction to Real-Time Intelligence: Eventstream, Eventhouse, KQL Database/Queryset, Real-Time Dashboard and Activator
    • Exercise 12 (optional): Trying out a simple real-time data stream with Eventstream for the chosen case
    • End-to-End Enterprise Project: analysing source system and reporting requirements, designing the Workspace/Lakehouse architecture
    • Final Deliverable: Integrating the chosen case end to end with Bronze-Silver-Gold layers, parameterised pipelines, a Semantic Model and RLS security, presented by the teams
    • General review, Q&A and certificate presentation

04Technical Requirements

Computer

1 per participant (Windows or macOS), with an uninterrupted internet connection

Software

Power BI Desktop and an up-to-date web browser

Access

Microsoft Fabric access for the training, a tenant and trial environment, and participant Workspace permissions are provided by the organisation. Where these are not already in place, the trainer can support the setup process.

Data Source Access

Sample datasets for the chosen case (SQL Server, Excel, CSV, etc.) or the organisation's own test data should be ready before the training.

Licensing

No additional licence purchase is needed for the core content of the training; the work can be done on a Fabric trial capacity.

However, to fully test Deployment Pipelines, Git integration and Real-Time Intelligence components at enterprise scale, it is recommended that the organisation has a valid Fabric Capacity licence.

Power BI Desktop is free to install; to publish and share the report in a Workspace, participants need the appropriate Workspace permissions.

05Learning Outcomes

Design an enterprise architecture

Set up the Tenant/Capacity/Domain/Workspace organisation and a Medallion (Bronze/Silver/Gold) layer architecture to enterprise standards.

Develop metadata-driven pipelines

Load multiple sources automatically and traceably with parameterised pipelines driven by a metadata control table.

Carry out data engineering

Apply Bronze-to-Gold data transformations with PySpark and Spark SQL and set up incremental loading with Delta Lake.

Build a dimensional data model

Design a Gold layer of Fact/Dimension tables following Star Schema principles, and a Direct Lake-compatible Semantic Model.

Set up security and governance

Publish a report secured with Row-Level Security and Object-Level Security, in line with organisational sharing policies.

Move to production

Promote the solution from development to test and production environments in a controlled way using Deployment Pipelines and monitoring mechanisms.

Frequently Asked Questions

The training period is determined as 2 days for the beginner level and 4 days for the advanced level. This period is ideal for detailed treatment of the subjects and practical applications. Flexible hours are offered to suit the busy schedules of the participants.

Trainings are carried out interactively with experienced trainers. Both theoretical information and practical work are presented together. Remote participation is also possible with the Power BI training online option. Training materials and resources are provided to participants digitally.

Anyone who wants to improve themselves in data analysis and reporting can participate. It is ideal for business analysts, data experts, IT professionals and managers. It is also suitable for those who are just starting their career and want to specialize in this field. Power BI course brings together participants from different sectors.

Basic computer knowledge and familiarity with Excel are sufficient. It is advantageous for those with previous data analysis experience, but it is not required. The training content is designed to be easily understood by participants of all levels. In this way, even beginners can easily follow.

Participants are given a certificate of achievement when the case studies in the training programs are completed with the effective application of the determined concept. In cases where the concept studies are not applied, participants are certified with a participation certificate documenting their involvement in the process.

The beginner level runs 4 days and the advanced level 5 days. Training hours are 09:30 to 16:30.

It can be delivered online, on site or hybrid. The format is set according to your preference.

The beginner level needs no development background; basic data/table knowledge and basic Excel are enough. The advanced level assumes beginner-level Fabric knowledge or equivalent experience.

The program is 80% practice and 20% theory. A single case from your organisation is grown step by step throughout the training.

Up to 12 participants at beginner level and up to 10 at advanced level.

Yes. Participants receive an IBA Consultancy Certificate of Attendance at the end of the training.