Power BI Training – Advanced Techniques and Best Practices

Program Language
This program will be conducted in German.

Who Should Attend
The Power BI training is aimed at advanced Power BI users who want to deepen their knowledge and implement more complex scenarios in data modeling, visualization, and collaboration.

What You Learn
The training covers advanced techniques and best practices in Power BI. The following topics are included:

• Creating measures with DAX (difference between measures and calculated columns, best practices, aggregation functions, filter context, CALCULATE, common use cases such as YTD, year-over-year comparisons, dynamic calculations)
• Deep dive: Role concepts in Power BI (Row-Level Security, role management, dynamic security, testing and publishing)
• DAX Query View: Analyzing and understanding measures (analyzing measure calculations, tools like DAX Studio, query plans, storage engine vs. formula engine)
• Copilot in Power BI (overview, use cases, opportunities and limitations of AI-powered assistance)
• Power Query – In-depth exploration (advanced transformations with M language, error handling, performance optimization, parameterization, custom columns)
• SharePoint integration (connecting lists and files, authentication, automating refreshes)
• Creating interactive reports (parameters, buttons, navigation, drillthrough/drilldown/drill-up, bookmarks for storytelling)

How You Learn
The training combines theoretical input with hands-on exercises. Participants will work on a continuous example project to apply what they have learned in practice.

Your Benefits
In future, you will

• Have more overview: Know what Power Query is and how to apply it
• Work more efficiently: Save time through the effective use of Power Query and its functions
• Organize data better: Create and manage structured and clear tables