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!
Key highlights in this training:
Access this training for free for 7-Days with our Platinum Plan Trial!
Get this Training, plus 400+ hours of in-depth Workshops, Challenges, Ebooks and Conferences with a 7-Day Free Trial. You'll also become a Platinum Member in the Collab365 Academy, where you'll get early access to all of our new training and events. It's also simple to cancel you trial!
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
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.
"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 ...
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
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 [email protected].
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.
At the moment, only individual passes are available. Please contact us at [email protected] if you'd like to discuss the purchase of more than 5 passes.
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.