Deepen your Power BI knowledge: Learn advanced Power Query techniques, complex DAX functions, professional report design, and row-level security. This workshop provides practical training on how to efficiently create, manage, and share dashboards and reports with other users.
Our experienced trainers will show you:
- how to design and optimize complex data models while avoiding performance issues
- how to apply advanced Power Query techniques to efficiently prepare large or complex data sources
- how to develop sophisticated DAX calculations – including time intelligence, relationship handling, and dynamic measures
- how to build professional report structures, navigation flows, and interactive features (drillthrough, tooltips, bookmarks)
- how to implement security and governance – from Row‑Level Security to publishing and managing content in the Power BI Service
Your benefits at a glance
- 2-day seminar with hands-on exercises
- In-depth knowledge of Power Query and DAX functions
- Professional report design, navigation, and security settings
- Using the Power BI Service for collaboration and sharing
- Hybrid participation possible
Seminar content
Power Query:
- Parameters, Last Refresh, integrating SharePoint files
- Combining files from folders, unpivoting tables
- Merging multiple sheets, joining tables
DAX functions:
- Calendar, CalendarAuto, Calculate, CalculateAll / RemoveFilter
- Time Intelligence: TotalYTD, DateAdd
- UseRelationship, SumX
Report design & navigation:
- Page buttons, drillthrough, tooltips, bookmarks
- Lookup table for axis sorting
Row-Level Security (RLS):
- Setting up roles in Power BI Desktop
- Applying filters to columns or users
- Assigning roles in the Power BI Service
Power BI Service:
- Configuring workspaces, Manage access
- Create a Workspace app
Prerequisites
- Basic knowledge of Power BI Desktop or participation in Power BI Fundamentals
- Experience with pivot tables in Excel is an advantage
Target Audience
- Users who want to create complex dashboards and reports
- Professionals who use advanced analysis features of Power BI
- Participants who want to visualize and share data professionally