Call Us: +32 2 466 00 16
Follow Us:

Analyzing your data with Power BI for BI Professionals

5 days
5 days

Upcoming Sessions





Book now





Book now





Book now




Book now

Interested in a private company training? Request it here.

Introduction to Power BI

Power BI is a service that covers multiple things: Power BI Desktop, the Power BI cloud service, ... . In this introduction we set the scene for the rest of the training, introducing the different aspects of Power BI.

  • The Need for Business Intelligence
  • Self-Service BI versus Enterprise BI
  • Core concepts of Power BI
  • Introducing Power BI Desktop
  • Introducing the Power BI Service
  • Power BI Service Tiers and Features

Creating Queries using Power BI Desktop

In this chapter, you will learn how to create queries using Power Query in Power BI Desktop to extract, transform, and clean data from source systems such as SQL Server, Oracle, Excel files, CSV files, folders, and others.

  • Creating Power Queries and Working with Query Steps
  • Loading Data from CSV, Excel, Web, Folders...
  • Loading Data from Relational Databases
  • Applying Basic Transformations
  • Performance Tuning via Query Folding
  • Loading Data via DirectQuery
  • LAB: Creating Queries using Power BI Desktop

Writing Advanced Queries in Power BI Desktop

Often, your data sources contain data that requires extra processing. In this course, you will learn about more advanced transformations that Power BI offers, such as Pivot, Unpivot, error handling, and more. This chapter will also cover combining data from multiple sources, query parameters, query functions, and how to manage data source credentials.

  • Advanced Power Query Transformations
  • Appending and Merging Queries
  • Working with Query Parameters
  • Defining and Using Query Functions
  • Managing Data Source Security
  • LAB: Writing Advanced Queries in Power BI Desktop

Building a Semantic Model

Participants learn why and how to create a Semantic Model, including data sorting, data types and formatting, hiding tables and columns, creating hierarchies, and more. We will also have a look at the storage of data in import mode, including the techniques that are used for compression. We will see DAX Studio as a tool to analyze and reduce storage costs.

  • The Need for a Semantic Model
  • Authoring Semantical Models in Power BI Desktop
  • Column Data Types and Formatting
  • Sorting Columns
  • Data Categorization
  • Creating Hierarchies inside Tables
  • Semantic Model Storage Cost
  • Analyzing Storage Costs using DAX Studio
  • LAB: Building and Enhancing a Semantic Model


Participants will learn about the different types of relationships available in Power BI, including 1:N, 1:1 and N:M relationships. We will see the limitations of relationships, including the fact that there can only be one active relationship between two tables and how to overcome this limitation. Finally, we will discuss the concept of filter direction, and have a look at single- and cross filter directions.

  • Cardinality of Relationships
  • Relationship Limitations
  • Role-playing Dimensions
  • The Cross-Filter Direction of Relationships
  • LAB: Working with Relationships

Semantic Models and Storage Modes

We will have a look at the different storage modes of a Power BI Semantic Model (Import, DirectQuery, Dual and Live). We will discuss a solution for the problem that in this era of big data, we often face data sources that are too big to be imported and too slow to be directly queried. The solution for this dilemma is a combination of Import and Direct Query, called aggregation tables.

  • Import Mode
  • DirectQuery Mode
  • Dual Mode
  • Live Connection
  • Aggregation Tables
  • LAB: Working with Storage Modes

Data Analysis Expressions (DAX)

DAX (Data Analysis Expressions) is the formula language used in Power BI Semantic Models, Excel Power Pivot Semantic Models, and in Analysis Services Tabular. Among other things, it's used to create calculated columns, measures and tables. In this chapter, we will introduce the basic concepts of DAX. If students are interested in a deeper dive into this language, we refer them to the three-day course Mastering DAX

  • DAX Introduction
  • Creating Calculated Columns
  • Creating Tables
  • Creating Measures
  • Creating Measures using Microsoft Copilot
  • CALCULATE-Function
  • Time-Intelligence Functions
  • LAB: Introduction to DAX

Designing Reports in Power BI Desktop

After fine-tuning the model, we can use it to create our reports. Power BI enables the creation of impressive reports, and in this module, you will explore various visualizations and the interactive behavior of these reports.

  • Overview of the Report Canvas
  • Adding Text Boxes, Shapes and Images
  • Using built-in Visualizations
  • Custom Theming
  • Printing a Power BI Report
  • Power BI Templates
  • LAB - Designing Reports in Power BI Desktop

Enhancing Reports in Power BI Desktop

Sometimes a static report just isn't enough. In this module you'll learn how to make interactive reports which are easy to use for any type of end user. Take your reports to the next level!

  • Slicers and Filters
  • Drill Through Pages
  • Custom Tooltips
  • Bookmarks
  • Visual Hierarchies and Drill-down Behaviour
  • Grouping and Binning
  • Dynamic Behaviour with Parameters
  • Custom Visuals
  • Report Mobile Design
  • LAB - Enhancing Reports in Power BI Desktop

Introduction to the Power BI Service

If you want to share models and reports with you co-workers, you should upload them to the Power BI Service. In this module you will learn about the general features of the Power BI service, the next modules dive into the details.

  • Power BI Service Overview
  • Microsoft Fabric Introduction
  • Power BI Service Tiers and Features
  • Working with Semantic Models and Reports
  • Creating and Using Workspaces
  • LAB - Introduction to the Power BI Service

Creating Semantic Models and Reports in Power BI Service

For some reports, you may not want to go through the hassle of creating or recreating a Semantic Model in Power BI Desktop. That's why you can immediately create or connect to existing Semantic Models in the Power BI Service. In this chapter you will learn how, combined with a deeper dive into the Semantic Model and Report configurations.

  • Creating Semantic Models in the Power BI Service
  • Connecting to Semantic Models in Power BI Desktop
  • Semantic Model Configuration and Permissions
  • Creating Reports in the Power BI Service
  • Configuring and Exporting Reports
  • LAB - Creating Semantic Models and Reports in Power BI Service

Creating Dashboards and Analyzing Data with Power BI Service

Dashboards enable you to integrate visuals from various reports onto a single page for swift access. This module instructs you on constructing and customizing these dashboards within the Power BI Service. You will also learn how to connect Semantic Models in Excel Pivot Tables and keep track of important KPIs using Scorecards.

  • Creating & Configuring Dashboards
  • Working with Power BI Q&A
  • Analyze Semantic Models in Excel
  • Metrics and Scorecards for KPI tracking
  • LAB - Creating Dashboards

Sharing Content in the Power BI Service

Power BI has different mechanisms to share content with other users: Sometimes you want to share in order to develop something together, or you want others to customize something, or maybe you want others to have read-only permissions on the shared object. In this module you'll learn how to accomplish this with the different sharing options in the Power BI Service.

  • Sharing Reports and Dashboards with Internal and External Users
  • Sharing Content inside a Workspace
  • Creating & Consuming Power BI Apps
  • Publishing Reports to the Web
  • Subscribing to Reports
  • Embedding Reports in SharePoint Online or Microsoft Teams
  • Report Usage Metrics
  • LAB - Sharing Content in the Power BI Service

Managing Data Refresh in Power BI

Semantic Models that are uploaded to the Power BI Service need to have their data refreshed from time to time. This module shows the different options to configure the data refresh, for cloud data as well as data which is stored on-premises.

  • Scheduling Semantic Model Refreshes
  • Online vs. On-Prem Data Sources
  • The Need for a Data Gateway
  • Configuring a Data Gateway
  • Incremental Refresh

Securing a Semantic Model

Security roles can be defined in Power BI Desktop. In the Power BI Service, we can enforce row level security by assigning (groups of) people to the different security roles. We will see how to set up Row Level Security in Power BI Desktop, including Dynamic Row Level Security, and how to enforce it in the Power BI Service.

  • Enhancing a Semantic Model with Row Level Security
  • Configuring Row Level Security
  • Implementing Dynamic Security
  • Security and Relationships

Power BI is a business analytics service that enables users to visualize and share insights from their data through interactive dashboards and reports. It allows you to connect to various data sources and create visually compelling reports that can be accessed across different devices.

This course will teach you all aspects of connecting to data sources and transforming data using Power Query, creating Power BI Semantic Models and reports, and publishing and maintaining them on the Power BI Service. The course also covers more technical topics on Power Query and DAX. Additionally, it explains how to configure a Data Gateway to connect the Power BI service to your on-premises data sources and how row-level security can be used to secure Semantic Models.

This course is intended for BI or IT professionals who have a technical background. U2U also offers a 3-day course Analyzing your data with Power BI for Business Users targeted at business users without a technical background.

Contact Us
  • Address:
    U2U nv/sa
    Z.1. Researchpark 110
    1731 Zellik (Brussels)
  • Phone: +32 2 466 00 16
  • Email:
  • Monday - Friday: 9:00 - 17:00
    Saturday - Sunday: Closed
Say Hi
© 2024 U2U All rights reserved.