Home  >  All Training  >  Workshops

Advanced Power BI Masterclass: How To Master DAX!

Ever puzzled over 'What's DAX and its significance?' Picture DAX as the toolkit in an architect's arsenal. Given a blueprint, with DAX, you can reshape, refine, and redesign. For a dynamic career in Power BI that extends beyond mere visuals, DAX is your cornerstone!

Trainer:
JESSICA JOLLY
Type:
 WORKSHOP 
Level:
 ADVANCED 

Key highlights in this training:

  • LEARN TO MAKE NEW INFORMATION FROM THE DATA YOU ALREADY HAVE: You'll learn one of the MOST important skills for a BI specialist. If you are serious about a career in Power BI, learning to use DAX is essential.
  • LEARN HOW TO USE FORMULAS: You'll learn how to quickly find out things you want to know about your information, like how many, how much, how often using DAX along with its inbuilt formulas.
  • GET VERY HANDS ON: Make sure you have Power BI desktop installed before this workshop. Expect to download sample data. You'll be practicing with Jessicas' help.

Our Platinum Plan:

Get this and 400+ hours of training with our Collab365 Platinum Plan.

Learn More
Your 7-Day trial includes:
  • Access to the Collab365 Academy
  • All Challenges, certifications, summits, ebooks and workshops
  • No obligations or restrictions. Cancel anytime.
  • Access to all new training and events while your plan is active. 

 WHAT YOU WILL LEARN 

What DAX IS and why it's an essential skill to know for a Power BI Pro

When introduced to DAX, most ask, "What's DAX and why should I master it?" Imagine a food box arriving at your doorstep. It contains precise ingredients and a recipe. Yet, what if you want to tweak the dish? That's where DAX comes in! Just like you'd modify ingredients to craft a new dish, DAX reshapes your data to tell compelling stories. For a robust Power BI career beyond just visuals, mastering DAX is essential.

Here's what you will learn ...

What the filter and row context is. You'll hear this a lot as you learn. 

How to filter a whole table, or just a selection of columns to reveal different themes and trends

How to use a core function -  calculate - to dynamically filter your existing data into new tables you can use

How to replace one filter with another, ignore and intersect your data using filters

reasons to WATCH

  • DAX is an absolutely essential skill to master in your Power BI learning journey.
  • Practice and more practice is the way to embed the learning in this area. This workshop is very hands on. 
  • You'll be supported by a passionate MCT and encouraged to work along and try out the excercises
  • You'll be able to ask Jessica questions at the workshop if attending live and clarify on the concepts where you need more support

This workshop will be hosted by Jessica Jolly (MCT)

The Topics You Will Cover

What is DAX?

Using some every day analogies, you'll learn about the crucial role DAX will play in your development as a Power BI Pro

Practice | Practice | Practice

You'll be experimenting and learning with Jessica using LOTS of practice in these areas:

  • Filters to replace other filters
  • Filters to ignore other filters
  • Filters intersecting other filters 

What Skills are Needed

Even the name "DAX" (Data Analysis Expression") is a bit daunting, but you'll learn how easy it is to form complex DAX formula using real examples. With practice and Jessica's support, you'll have a grasp in no time. 

How to Optimise

Some filters are inefficient and some approaches are optimized. Learn about the differences and how to filter over a whole table or just selected columns

Context Transition

Changing the way a filter works on the fly sounds daunting but you will learn about Filtering with a context transition

Where to head next in your career path

Experimenting and learning in this workshop will show you how you will cope with the more complex data interactions needed when working with Power BI. It will be a great way to decide if this path is for you - and to ask an expert where to head next

Is This Workshop Right For You?

Would you answer YES to any to these questions?

Chances are, you thought Power BI might be simple but then tried to perform a task you routinely do in Excel using Pivot tables and found it hard. 

Power BI works in a totally different manner to Excel and requires a subtle shift in approach. 

This workshop will help you change mindset and break down your DAX barriers.

  • Do you know the basics of Power BI but understand that drag and dropping fields can only take you so far? 
  • Have you dabbled with Formulas like Calculate but want a much deeper understanding of what's going on with the data? 
  • Are you looking for techniques to combine information you already have in new ways to reveal insight?
  • Do you find the idea of 'formula' daunting or get lost in learning that tries to teach you how to use DAX? (They assume we already know SO MUCH!)
  • Are you finding that basic measures are not enough but realise that making what you need from DAX can be confusing and time consuming?
  • Do you learn better by practicing on small examples, getting the support you need and moving forward in small steps towards a goal?

"I'm at a stage in my Power BI learning where this Workshop makes so much sense as a next step ..." 

I've spent time learning the basics of Power BI -  like importing data, building a model, visualising and publishing reports.

I feel now that I have reached the limit of what I can do with my data 'out of the box' and need to be able to transform it in new ways to reveal insights. Ive got some really basic skills in this area, but I know I need the next level. 

Thats why I believe this workshop is a natural next step ...

Read more ...

DAX and formulas allow me to not just refine and clean my data, they allow filtering, combinations and limitations to be put in placeto make meaningful NEW tables that I can then visualise or analyse.  

The skills I need to do this take practice. I'm also likely to have questions because this is a more complex area that I have delved into so far.

Thats why I will be watching this workshop because I believe with the right support (that Jessica can offer), I'll be able to get to the next level on my own Power BI learning journey more quickly than just using Microsoft learn based content alone.

Meet your Workshop Host...

Jessica Jolly (MCT)

Jessica Jolly is A Microsoft Certified Trainer with an MCSE in Data Analytics.

Passionate about the topic with a practice focused on Power BI specifically, and the Power Platform more generally. 


Before starting my own business, ALT-Enter, LLC, I worked for Unilever, a global consumer products company, for 27 years, in a variety of roles.


Because of my many years of corporate work experience, I focus my training on teaching business analysts the practical uses of the features and functionality in Microsoft Office applications, with a special focus on Power BI, Excel, Power Pivot (Excel 2016), and the Power Query Editor. 

Frequently Asked Questions

Can I get an invoice?

As soon as you purchase your pass you will be emailed a receipt. If you'd also like a formal invoice, please send your request to hello@collab365.com.

Can I get refund?

We offer a full 7-Day free Trial with nothing held back. If you choose to cancel before the 7-days then you pay nothing. For this reason we don't offer refunds.

Can I buy a team or multi-user pass?

At the moment, only individual passes are available. Please contact us at hello@collab365.com if you'd like to discuss the purchase of more than 5 passes.

Can I share the videos and ebooks?

No, only the person who purchases the pass will be able to watch the videos and will receive the ebooks. We ask that you do not share them.