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.

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 Modelling:

• 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).

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

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

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).

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.