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!

Suitable For

Beginners

Duration

5 Hours Recording

Format

Workshop

Presenter

Jessica Jolly

What you'll learn:

  • 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.
  • What the filter and row context is. You'll hear this a lot as you learn.
  • How to replace one filter with another, ignore and intersect your data using filters
  • How to filter a whole table, or just a selection of columns to reveal different themes and trends
  • 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.
  • 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.
  • How to use a core function - calculate - to dynamically filter your existing data into new tables you can use
Purchase this training only:
Get immediate access to this training content with a one-off purchase.
$197.00 USD
Or
Subscribe to all of the training in the Collab365 Academy:
Get this training plus over 450 hours of training and access to the Collab365 Academy. Learn More.

Agenda:

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

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. 

Context Transition

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

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 

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

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

Description:

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.

This training includes:

  • 5 hours of training
  • Access to the Collab365 Academy
  • Workshop Resources
  • Watch on Desktop or Mobile

Thoughts from the Collab365 Team:

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 place to 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

Jessica Jolly

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.

100% Satisfaction guaranteed

100% Guaranteed

We're thrilled to have you explore our content! Like many of our happy customers, we're sure you'll find great value in what we offer. If, for any reason, you're not completely satisfied with a stand-alone purchase, please reach out within 30 days. We're more than happy to process a refund for you.

As for our Platinum Plan, we invite you to take advantage of our Collab365 Academy with a full-access, 7-day trial. It's a wonderful opportunity to experience all that we have to offer. Please note, due to the nature of this comprehensive trial, we are unable to provide refunds for plan purchases.

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're thrilled to have you explore our content! Like many of our happy customers, we're sure you'll find great value in what we offer. If, for any reason, you're not completely satisfied with a stand-alone purchase, please reach out within 30 days. We're more than happy to process a refund for you.

As for our Platinum Plan, we invite you to take advantage of our Collab365 Academy with a full-access, 7-day trial. It's a wonderful opportunity to experience all that we have to offer. Please note, due to the nature of this comprehensive trial, we are unable to provide refunds for plan purchases.

Can I buy a team or multi-user pass?

Absolutely, we also offer discounts for multiple purchases. To sign-up for a Teams Pass, please visit our Platinum Plan page.

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.

Who do I contact if there's a problem?

Send us an email at hello@collab365.com and we can help. 

Can I cancel my subscription?

Of course. The trial lasts for 7-Days and you can cancel anytime before that. If you choose to continue as a paid platinum member you can also cancel at any time.

How do I get my certifications?

If the training you purchase also includes a certification, then as soon as you complete, we will automatically email you so you can redeem your badge on Credly. Good luck!

What is included in the Platinum Plan?

The Platinum Plan offers a comprehensive suite of resources tailored for Microsoft 365 learners:

  • Complete access to our current library of over 200 hours of detailed Microsoft 365 training and 108 Ebooks.
  • A rich selection of over 30 half-day workshops covering essential Microsoft 365 and Power Platform concepts.
  • Membership in an active community of 10,000 learners for peer support and networking.
  • Continuous updates with all new workshops, challenges, and success paths to keep your skills sharp and current.
  • Lifetime access to all virtual summit session recordings, with insights from top industry experts.
  • As we evolve, so will our content. The Platinum Plan includes all future training that aligns with the core educational content and formats currently offered.

What is not included in the Platinum Plan?

While the Platinum Plan is extensive, there are a few exclusives that fall outside its scope:

  • One-on-one coaching sessions and personalized, coached training programs.*
  • Custom software solutions or tools that are not a part of the standard offerings within the Collab365 Academy.
  • Niche training that falls outside of the Power Platform, SharePoint, or Microsoft Teams ecosystem.
  • External certifications or formal accreditation from third-party institutions.

*Please note that there may be occasional exceptions to the coached training programs. Stay tuned for special announcements or offers that may include these features.

Tell me more about the "Build Your Intranet" Program

Availability for the 'Build Your Intranet Program' is strictly limited and allocation will be determined on a first-come, first-served basis. This promotional offer is exclusively available to purchasers of this All-Access Pass and is subject to the terms and conditions of sale. We reserve the right to modify or withdraw this offer at any time without prior notice.

I have a Platinum Plan or Lifetime, Should I Buy This?

If you already have an active Lifetime or Platinum Plan, the event recordings are included as are the bonus items. The BYI Program is being run in partnership with another business so is not included. If you are interested in this, please contact hello@collab365.com for exclusive pricing (places are limited)

  • Personal

  • Teams

Purchase this training only:
Get immediate access to this training content with a one-off purchase.
$197.00 USD
Or
Subscribe to all of the training in the Collab365 Academy:
Get this training plus over 450 hours of training and access to the Collab365 Academy. Learn More.