DAX Booster for Power BI (1 day)

Power BI is taking the world by storm, allowing for amazing transformation in the way you use and present data.

Contact Us Today

Master the Power of DAX to Elevate Your Power BI Skills

Power BI is taking the world by storm, allowing for amazing transformation in the way you use and present data. Our DAX Booster for Power BI course is designed for intermediate to advanced users seeking to deepen their expertise in the powerful Data Analysis Expressions language that underpins Power BI solutions.

This hands-on course provides an in-depth exploration of DAX fundamentals. With practical examples and real-world applications, you’ll gain the skills needed to harness DAX for dynamic and effective data analysis.

What you get from this course

  • This intermediate to advanced hands-on course is focused on enhancing your understanding of the amazing capabilities of DAX.
  • We recommend you attend our Power BI Essentials course before attending this more advanced session.
  • In this course we focus on the core elements needed to get an in-depth understanding of how DAX works, and the application of this knowledge on real-world practice examples. While DAX is also available in Excel this course is focussed on the application of DAX in Power BI desktop.
  • From this course you get an understanding of key elements of DAX language and the ability to develop complex DAX expressions, with a sound understanding of key data modelling concepts.

Pre-requisites

This is an intermediate to advanced course, and users should already be familiar with basic concepts of the Power BI data model and be able to write simple DAX measures such as SUM, COUNTROWS, DIVIDE and TOTALYTD.

If you are not confident with these concepts, then we recommend you attend our Power BI Essentials course before attending this more advanced session.

Full course outline

  • Discover the secrets of data shaping and data modelling that will enable you to simplify your DAX functions and calculate reports faster
  • Learn best practice techniques to make you data model more efficient.
  • Iterator functions such as SUMX that create Virtual tables on the fly

  • Understand Filter Context
  • Learn how to use variables to make your formulas easier to read, faster and more efficient
  • Understand how and when to apply complex filters to your calculations
  • Functions explained include FILTER, ALLSELECTED, EXCEPT, SELECTEDVALUE, ADDCOLUMNS, SWITCH and more

  • Improve your understanding of date-based functions and resolve common date problems
  • Discover the power of harvester measures to improve the user experience
  • Understand how and when to use Disconnected tables.
  • Learn how to combine actual and forecast values into a continuous line chart.
  • See how to display events in progress based on a start and end date

  • See how to easily find unmapped items and errors within your tables
  • Learn how to incorporate images in your filters to make them more intuitive

We recommend our Power Query Booster course to be run in conjunction with this course.  Shaping your data correctly with Power Query is key to simplifying your DAX. The Power Query booster course helps you to understand how to implement more complex data transformations efficiently. 

We recommend running an additional coaching day. Bring your own data and apply your skills to work on your own, real-life DAX driven Power BI project, with the guidance and coaching of our expert facilitator.

You’ll not only practise your newly learned DAX skills, you’ll also walk away with your own improved data models.

Who Should Attend

  • Power BI users who have reached a stage of understanding the basics and now need to extend their DAX knowledge to take their reporting and analysis to the next level.
  • Power BI users who need to understand how DAX works and what is possible, while learning how to approach DAX challenges.

Delivery Options

In-house

All courses are available for in-house training, providing flexible options to meet your needs wherever you are – Perth, interstate, or internationally. Our in-house courses are designed to maximise value with flexibility, tailored content, and cost savings for your team.

Learn More

Virtual Training

Our virtual training options (in-house training only) bring the same high-quality, live, instructor-led courses directly to your team, no matter where they are located. Our virtual training features the same level of interaction as our in-person sessions, while providing the convenience of learning from any location. This option is ideal for interstate and international clients.

Learn More

Previous Training Courses

Why Choose Access Analytic?

At Access Analytic, we don’t just provide training and consulting—we lead the industry. With a 25-year track record of excellence, we are the trusted choice of top global companies for training and consulting in Power BI, advanced financial modelling, data analytics, and AI-driven business solutions.

Industry-Leading Expertise

Our Course Facilitators are internationally recognised thought leaders, speaking at major conferences around the world. One of our directors has been a Microsoft MVP for over seven years—and is the only combined Excel and Data Platform MVP in Australia—highlighting our elite-level expertise.

Global Reach, Local Presence

We deliver world-class training across Australia, Oceania, the South Pacific, the Middle East, Africa, and Asia, helping professionals and organisations harness the power of Power BI, Excel, and AI. Our expertise extends beyond consultancy—we train and educate thousands of professionals worldwide.

Top-Ranked YouTube Channel

We run one of the world’s top YouTube channels for Power BI and Excel, where thousands of professionals look to us for cutting-edge insights and practical expertise.

Trusted by the Biggest Names

Many of the world’s most trusted and respected companies rely on Access Analytic for innovative, data-driven solutions. Our vast experience across industries means we bring the best global ideas and strategies directly to your business.

Elite Team,
No Juniors

We only give you highly experienced facilitators. Every Facilitator assigned to your training course will have the right mix of expertise in areas such as Power BI, finance, AI, best-practice financial modelling, and data analytics. Our team’s depth of real-world knowledge ensures your business benefits from proven insights that streamline processes, enhance decision-making, and deliver measurable results.

Perth-Based, but Borderless Support

Our team is locally based in Perth, but we run courses all around the world.

Setting the
Standard

At Access Analytic, we don’t just keep up with the industry—we set the standard. Partner with us for world-class expertise, cutting-edge solutions, and long-term success.

Meet Our Speakers

Jeff Robson

Founder & CEO | Data and Financial Modelling Specialist

Read More

Wyn Hopkins

Director | Microsoft MVP | Reporting and Automation Expert

Read More

Yury Tokarev

Director | Financial Modelling and Analytics Expert

Read More

Our Clients

Client testimonials

We are thrilled to have helped hundreds of businesses in Perth and worldwide over the years.

Other courses you might be interested in

Maximising your excel productivity

Power Query Booster

Power BI Essentials

Power Query in a Day

Power Query & Power Pivot for Excel

Advanced Budgeting & Forecasting

Financial Modelling in Excel Training Course

Trusted by the Biggest Names

Many of the world’s most trusted and respected companies rely on Access Analytic for innovative, data-driven solutions. Our vast experience across industries means we bring the best global ideas and strategies directly to your business. At Access Analytic, we don’t just keep up with the industry—we set the standard. Partner with us for world-class expertise, cutting-edge solutions, and long-term success.

Contact us today to learn more about our Power BI training options

(We no longer run public courses for individuals)
Consent