Power BI: Core features

  • Course types: Calendar course / In company
  • Version: Office 2013/2016
  • Takes place in: Antwerp, Brussels
  • Duration: 2 days
  • Price: € 950 VAT excl. / Cheaper course?


Learn the basic principles of Power BI in two days

You may have heard of Power BI and already have seen a few examples in the form of visually appealing dashboards and reports. But how do you get started with it? In this two-day course we will look at the various phases you need to cover. We will retrieve our data via queries, create a data model with the necessary relationships and calculations, build an interactive report and publish it in the cloud. Finally we will create a dashboard in the cloud that we can share with colleagues.

Choose a date and location


After completing this course you will be able to:

  • Import data via queries
  • Use queries to transform tables into usable, meaningful data
  • Create a data model with relationships, custom sort orders, date dimension tables etc.
  • Create reports in a Power BI Desktop environment
  • Create reports and dashboards in a Power BI Service environment
  • Share reports and dashboards with colleagues

Target Group

Anyone wishing to gain a solid grounding in creating and sharing reports and dashboards via Power BI.


Prior knowledge of Power BI is not required. Familiarity with entering functions manually in Excel would be a bonus since you will not have a function wizard in Power BI.


Part 1: Power BI

  • What are the components of Power BI?
  • What is the difference between Power BI Desktop and Power BI Service?

Part 2: Queries

  • Importing data
  • Converting data (remove duplicates, delete records, filter, add columns, unpivot)
  • Expanding tables with data from other tables (compare Vlookup)
  • Comparing tables (What is common to them? What is only in table 1? What is the total of these 2 or more tables?)
  • Arranging similar tables horizontally

Part 3: Data Modelling

  • The different data types
  • Relationships between tables
  • Defining a date dimension table
  • Defining custom sort orders
  • Setting up data categories
  • Hiding (auxiliary) columns from the model
  • Calculated columns
  • Measures (general functions, filter functions)
  • Context

Part 4: Reports in Power BI Desktop

  • Components of a report
  • Working with tiles
  • Standard visualisation options (stacked bar, stacked column, area, treemap, map, pie, slicers etc.)
  • Ad hoc filters
  • Filters in a report (visual level filters, page level filters, report level filters)
  • Publication to Power BI Service

Part 5: Power BI Service

  • Refreshing datasets
  • Difference between reports and dashboards
  • Creating dashboards
  • Quick insights
  • Q&A (ad hoc questions about the dataset)
  • Publishing data from Excel directly to dashboards

Part 6: Sharing

  • Sharing a dashboard with colleagues
  • Embedding a report in e.g. a SharePoint page

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning

Request an offer

Share this course on Facebook, Twitter, LinkedIn or e-mail

Practical info

The practical info and applicable cancellation conditions related to this training course.


Choose a date and location

€ 950 VAT excl.
Cheaper course?

Requesting a quotation

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.



If you enrol several employees for the same course on the same date, you will get a discount:

  • 2 employees: 15% discount on the 2nd subscription
  • 3 or more employees: 15% discount on the 2nd subscription and 40% on further participants


Contact Astrid De Roeck

+32 2 264 13 20