Advanced Power BI in a Day: 1-Day Workshop

The advanced Power BI In-A-Day workshop was designed by Allgeier (Schweiz) to pick up where the Dashboard in a Day (DIAD) left off. It is run by qualified BI consultants in a similar hands-on style as participants learned to appreciate in the DIAD course. The material is updated frequently and undergoes rigorous testing procedures to ensure attendees have the best possible learning experience.

Topics

• Basic DAX Concepts
• Working with Time Series Data
• Working with Hierarchical Data
• Designing the User Experience

The format of this workshop is unlike any other Microsoft training program you might have encountered. It is based on experiential learning methods, is extremely hands-on and will have a lasting impact on your skills to build powerful reports.

Agenda

The first part introduces key formulas and functions, which provide users with the skills needed to perform advanced comparisons on their data. It includes: 

• Basic Aggregations
• Quick Measures 
• Table Functions 
• Calculate Function 
• Filter Modifiers

The second part focusses on advanced Power Query and Data Relationship concepts. It includes: -

• Merging Data
• Transposing Data
• Self-referencing relationships
• Relationship cardinality
• Relationship hierarchy

The third part provides advanced User Interface (UI) and User experience (UX) techniques. These include:

• Background Images
• Bookmarks
• Image buttons & navigation elements
• Triggering Visibility

Finally, with the help of the consultant, the attendees get a chance to apply their new skills on their own data and reports.