This 2-day course takes experienced Power BI users to the next level in data analytics. Through hands-on excercises, you’ll master integrating Power BI with Azure to handle robust datasets and execute complex data transformations using Power Query’s M language. Level up your data modelling skills by implementing star schemas, optimising relationships, and configuring aggregate tables.
Boost your visualisations using DAX to build custom reports incorporating advanced calculations, security roles and dynamic cell-level security. Make reports come alive with Advanced Power BI visuals like animated scatter plots, pixel perfect matrixes, and Sankey diagrams.
Tackle common problems like data drifts, scalability bottlenecks and security gateways through challenges with sample datasets. By the end, you’ll have honed grade skills for impactful data storytelling using advanced integrations, modelling techniques, visualisations and codes.
- Advanced DAX formulas and techniques
- Advanced Data Modelling
- Using Power Query
- Pre-aggregating data
- Merging data
- Pivoting data
- Workflows – Using Flow or a third-party tool
- Creating Custom visuals in Visual Studio
- R Script
- Use of Azure and effective data connections,
- How to get around time intelligence
