Power BI - The Basics

Using Microsoft Power BI for the first time

Attendance fee

999 eur plus VAT

Customers of Lucanet Group receive a 10% discount.
Partners of Lucanet Group receive a 20% discount.

Discounts are not combinable.

In just two days, the training course “Power BI – The Basics” will teach you how to improve your reporting using Microsoft’s free, self-service business intelligence solution.

You’ll learn how to import and transform data from Excel and any other source, create complex data models, and prepare appealing, interactive, and up-to-date reports.

Agenda/content

Agenda/content

1. Introduction to Power BI

  • Understanding the concept behind Power BI and its possible uses
  • Understanding Power BI in the context of other Microsoft products
  • Introduction to Power BI Desktop

2. ETL process using the Power Query Editor

  • Familiarizing yourself with the Power Query Editor’s user interface
  • Importing data (Excel, csv/txt, folders, SharePoint, web, databases, etc.)
  • Validating, transforming, and enriching data

3. Data modeling

  • Understanding the basics of data modeling
  • Creating a Power BI Desktop data model
  • Defining relationships, the filter direction, and cardinality between tables

4. Measures and DAX

  • Using quick measures
  • Introduction to the Data Analysis Expressions (DAX) programming language including functions for text, date, time intelligence, etc.
  • Implementing column-based calculations using DAX
  • Implementing measures using DAX

5. Reports

  • Internalizing the basics of report design
  • Learning about a range of common visuals, including charts and cards
  • Understanding filter options, data slicers, and the cross-filtering feature
  • Creating reports/report pages

Organiser label

Natalie Stein

Natalie Stein

Academy Manager

Service hours:

Monday to Thursday 09:00-16:00 CET
Friday 09:00-14:00 CET