Intermediate Power BI Workshop

Craft insights with complex data transformation

- Review basic data transformations and dive into complex transformations

- Delve into Power Query formula language

- Practical exercises in data cleaning, shaping, and creating calculated columns

Fine-tune Power BI data models

- Understand data modelling concepts

- Optimise data models for performance

- Explore query folding and query optimisation techniques

Optimise data insights with DA

- Dive into Data Analysis Expressions (DAX) language

- Intermediate DAX functions and concepts

- Write complex DAX measures to answer specific questions

Design and customise your reports

- Explore and create custom layouts with json files

- Create visualisations with custom layouts

- Hands-on exercises creating visuals

Beyond basic charts with custom visuals

- Explore best practices for combining multiple visuals 

- Understand the power of maps and geolocation data

- Utilise forecasting and advanced analytics features

Security and integration

- Protect data with row-level and data-level security 

- Understand a user of roles and permissions in Power BI

- Integrate PowerBI with other applications

Master data visualisations

- Plan and create content that connects with your audience

- Select and implement appropriate visualisations 

- Apply design principles to enhance your dashboards

Dashboard design with storytelling techniques 

- Design captivating and impactful data stories 

- Bring it all together with interactive storytelling practice