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 recommended 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

Public Courses

Our public courses are located primarily in Perth (with options for interstate and international participants), providing individuals or smaller teams with the opportunity to join our comprehensive training sessions alongside other industry professionals.

Learn More

Upcoming Course Dates

Power BI Essentials (2 days) Face-to-Face Training

February 11, 2025 @ 8:30 am - February 12, 2025 @ 4:30 pm

A$1,499.00 – A$1,699.00

Our Public courses are aimed at smaller groups of 3 – 8 people so that there is more opportunity for the instructor to assist on a 1-1 basis and discuss the attendee’s specific real-world scenarios.

NOTE: For Public Courses a minimum of 3 attendees must have signed up 4 weeks in advance of the course otherwise the course will be postponed, and full refunds offered. The 3rd day option also requires a minimum of 3 attendees to proceed

Why Learn From Access Analytic

Practical

Highly experienced facilitators who actively and regularly consult with clients.

Applicable

Apply what you learn to your job to further your career.

Hands-on

The course is designed to provide maximum hands-on experience.

Passionate

Our facilitators love this subject!

Clear

We specialise in translating complex subjects into concepts that are easy to understand.

On-going help

You can always email the facilitator with any questions.

Comprehensive course notes

Useful working document to support your learning.

Networking

Meet industry peers and hear how they approach this subject.

Our Course Facilitators

Jeff Robson

Masters (Applied Finance), Bachelor of Commerce (Accounting & Information Systems), Certified Information Systems Auditor (CISA), Fellow of the Australian Institute of Management (FAIM), Fellow of the Financial Services Institute of Australasia (F Fin), Member of the Australian Institute of Company Directors (MAICD), Microsoft Excel Expert, International Presenter

Wyn Hopkins

Microsoft MVP, Published Author of “Power BI for the Excel Analyst”, B.Sc. (Hons) Accounting & Financial Management

Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”.

YouTube content creator:  over 5.5 million views and 95,000+ subscribers.

Yury Tokarev

PhD (Finance and Economics), Chartered Accountant with the Australian Institute of Chartered Accounting (CA), Bachelor of Business (Finance and Economics), Microsoft Certified Excel Expert (MCEE)

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

DAX Booster for Power BI

Power BI Essentials

Power Query in a Day

Power Query & Power Pivot for Excel

Advanced Budgeting & Forecasting

Financial Modelling in Excel Training Course

Learn from highly qualified finance professionals with international experience

Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.

Get Ahead of the Game – Book Your Training Now!