Power BI Expert

A practical, expert-level Power BI training covering advanced data modeling, M language, external tools, administration, and complex analyses. Duration: 2 days.

The Power BI Expert training is a two-day, hands-on course for experienced Power BI users who want to elevate their skills to an expert level. The course covers advanced features such as working with SQL data sources, the M query language, and external tools like Tabular Editor and DAX Studio. Power BI administration functions are also addressed.

In this course you will

  • work with complex queries;
  • use parameters and custom functions in Power Query;
  • understand and apply the M query language;
  • maintain query folding with SQL;
  • set up and utilize Data Flows;
  • use Direct Query and connect to (Azure) SQL databases;
  • create and use aggregation tables;
  • implement incremental refresh for large datasets;
  • perform Pareto and ABC analyses;
  • build forecasting and P&L statements in Power BI;
  • understand Power BI administrator options;
  • apply advanced role-level security (RLS);
  • work with certified datasets and premium features;
  • use external tools like DAX Studio and Tabular Editor;
  • create and manage calculation groups;
  • configure and manage gateways.

Schedule a training?

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in English and Dutch.

REQUEST IN-COMPANY TRAINING

 

Public training calendar
datedur.lang.locationprice 
12 Nov2Nweb based 1195 EUR (excl. VAT)
10 Dec2Utrecht 1195 EUR (exempt from VAT)
03 Feb2Utrecht 1195 EUR (exempt from VAT)
16 Jun2Utrecht 1195 EUR (exempt from VAT)
15 Sep2Utrecht 1195 EUR (exempt from VAT)
SESSION INFO AND ENROLMENT

Intended for

The Power BI Expert training is ideal for experienced Microsoft PB users, administrators, users who are working with large datasets, users looking to further develop their expertise.

Background

Participants are expected to have knowledge of Power BI Advanced and hands-on experience with Power BI (e.g., through the Power BI fundamentals and Power BI Advanced).

Main topics

Power Query:

  • Working with complex data sources.
  • Using parameters.
  • Converting queries into functions.
  • The M language.
  • Using and preserving SQL & query folding.
  • Creating and using data flows within organizations.
  • Creating date tables in Power Query.
  • Using incremental refresh for large dataset.

Data Modeling:

  • Direct Query vs. Import vs. Dual storage modes.
  • Creating and using aggregation tables.
  • Working with many-to-many relationships.
  • Handling Slowly Changing Dimensions (SCD).
  • Handling parent-child hierarchies using DAX functions.

Using External Tools for Performance & Productivity:

  • DAX Studio
    • Measuring DAX performance.
    • Query tracing.
    • Documentation.
  • Tabular Editor
    • Measure management.
    • Creating and using calculation groups.

Frequently Requested Advanced Analyses:

  • Profit & Loss statements in Power BI (P&L).
  • Pareto analyses.
  • ABC analyses.
  • Forecasting in Power BI.

Power BI Administration:

  • The Power BI Admin Portal and its options.
  • Premium vs. Pro license options.
  • Creating and using certified datasets.
  • Creating and managing gateways.
  • Advanced role-level security (RLS).

Training method

Live instructor-led training, with plenty of opportunities for practical excercises.

Certificate

At the end of the session, the participant receives a 'Certificate of Completion'.

Duration

2 days.

Course leader

Fast Lane.


SESSION INFO AND ENROLMENT