Advanced Power BI

Unlock enterprise tools for scalable, high-performance reporting.

Progress to enterprise-level Power BI

This one-day intensive workshop is designed for experienced Power BI users. Led by a senior BI consultant, this session dives deep into enterprise-grade features, advanced DAX techniques, scalable modelling strategies, and performance tuning.

Through hands-on exercises and real-world examples, you’ll gain the tools and confidence to deliver robust, efficient, and impactful Power BI solutions across your organisation.

Audience

This in-person course is designed for Power BI users who are already comfortable with report building, data modelling, and DAX fundamentals. Participants should be confident in using Power BI Desktop and Power BI Service and ready to deepen their technical knowledge to tackle real-world business problems.

Course format

One-day, intensive workshop, delivered by a senior data expert with deep experience in enterprise Power BI implementations and business problem-solving.

This course focuses on solving complex business challenges using best-practice techniques and enterprise-grade features, with hands-on exercises, real-world examples, and expert tips woven throughout. You’ll explore powerful modelling patterns, advanced DAX strategies, and optimised design techniques to elevate your reporting and analytics skillset.

Learning outcomes

By the end of this course, you will be able to:
Create dynamic, user-friendly reports with advanced slicer and filtering techniques
Use calculation groups to streamline and scale DAX calculations
Configure bridge tables to support complex relationships
Apply row-level and object-level security for tailored data access
Enhance your reports with practical techniques for better comparisons, visuals, and interactivity.
Use Power BI templates, apps, and themes to deliver scalable reports
Optimise report performance using built-in and external tools

Key learning areas

Advanced Slicers & Filtering Strategies
  • Master advanced slicer types, sync options, and interactive slicer panels using bookmarks and buttons
  • Implement hierarchical, cascading, and DAX-driven slicers to create dynamic, user-friendly reports
Calculation Groups
  • Apply advanced DAX for time intelligence and dynamic comparisons (e.g., YTD, LYTD, MOM, YOY)
  • Use Tabular Editor to create calculation groups for scalable, reusable logic and measure formatting
Scalable Modelling with Bridge Tables
  • Use bridge tables to manage many-to-many relationships and enable multi-category analysis.
Security & Customer-Specific Views
  • Configure row-level and object-level security for controlled access
  • Build dashboards that show personalised views while comparing to business-wide benchmarks
Tips & Tricks for Advanced Reporting
  • Improve readability with stacked bar charts
  • Apply best practices for map and location visuals
  • Create dynamic previous-period comparisons
  • Compare customer or business unit metrics against business-wide benchmarks
Creating and Customising Themes
  • Customise colours, fonts, and visuals
  • Build and edit JSON theme files for advanced styling
  • Save and reuse custom themes for consistency across reports
Governance & Deployment
  • Package and deploy reports using Power BI .pbit templates
  • Use TMDL to version and migrate semantic model objects
  • Governance and user onboarding tips
Performance Optimisation & Diagnostics
  • Package and deploy reports using Power BI .pbit templates
  • Use TMDL to version and migrate semantic model objects
  • Governance and user onboarding tips

Bring Your Own Device: Participants will need a laptop with Power BI Desktop installed (free from Microsoft). Instructions will be sent before the course.
‍
What You’ll Leave With: Practical knowledge you can apply immediately to create more insightful and interactive Power BI reports that support business decision-making.

Register your interest today for Power BI training

Learn from BI consultants who use Power BI to solve real business problems, daily.
Build practical skills through hands-on exercises you can apply immediately.
Small workshop sizes (4–8 people) ensure personalised support and discussion.
See how Power BI fits into your existing tools and drives more intelligent decisions.
Gain practical skills that you can apply right away in your everyday tasks.
PBI icon
Microsoft Power BI

Advanced

$800*
(NZD)
per person

*Pricing is subject to change without notice.

FAQs

Do you have Questions? Below are answers to some common questions about our training workshops.
How long does each workshop run for?
How often are the workshops run?
Where are the workshops held?
How many people can attend each workshop?
Tailored to you

Custom Training

If our pre-built workshops don't quite meet your needs, we can design a tailored training session to address your specific requirements. Whatever business challenge you're trying to solve, a custom session will ensure the training is relevant, practical, and aligned with your team's priorities.
Contact us today to discuss your requirements.
Contact