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:
Agenda:
Using some every day analogies, you'll learn about the crucial role DAX will play in your development as a Power BI Pro
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.
Changing the way a filter works on the fly sounds daunting but you will learn about Filtering with a context transition.
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
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
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:
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 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
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:
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.
Absolutely, we also offer discounts for multiple purchases. To sign-up for a Teams Pass, please visit our Platinum Plan page.
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.
Send us an email at hello@collab365.com and we can help.
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.
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!
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.
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 or courses related to these certifications.
*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.
