Power BI PathFinder Challenge: Unleash Your Datas Potential with DAX

Discover the power of DAX in Power BI to revolutionize your data analysis. Learn to create dynamic reports, insightful visuals, and unlock the full potential of your data.

Collab365 Challenge

Presenter

Jon Manderville, Coach

Suitable For

Intermediate

Study Duration

2 Hours

What you'll gain my completing this Challenge:

  • Deep Dive into DAX Filtering Mechanics: Understand the underlying workings of DAX filtering for advanced data manipulation.
  • Applying Various Data Filters: Explore different types of data filters to enhance analysis and reporting.
  • Percentage Calculations and Advanced Measures: Learn to create percentages and complex measures using DAX.
  • Understanding DAX and Its Importance: Learn why DAX is crucial in Power BI and how it enhances data analysis.
  • Creating Totals with DAX: Master the art of generating totals and aggregates using DAX formulas.
  • Data Filtering with DAX: Dive into filtering data effectively using DAX for refined data insights.

Note: This Challenge is included with the Power BI Success Path.

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.

Description:

Embark on an engaging journey with the Power BI Pathfinder Challenge, designed to take your Power BI skills to the next level. This Challenge is a natural progression from the popular Power BI StepUp Challenge, but don't worry if you haven't completed it - you can still dive right in!

This challenge offers an in-depth exploration of DAX within Power BI, tailored for both beginners and experienced users. Attendees will start with a foundational understanding of DAX and its role in Power BI. The course progresses through creating totals, advanced filtering techniques, and understanding the mechanics of DAX operations. Participants will also gain expertise in applying various filters, creating percentage-based calculations, and manipulating data views using DAX. The training culminates in understanding the interaction between Power BI report filters and DAX, equipping learners with comprehensive skills for powerful data analysis.

Challenge Learning Modules:

Why is DAX Valuable And What Does It Do?

  • Introduction to DAX in Power BI
  • The significance of DAX in data analysis
  • Basic DAX functions and their applications
  • How To Create Totals Using DAX

  • Techniques for calculating totals and aggregates
  • Practical examples of DAX in action
  • Building complex total calculations
  • How DAX Can Filter Data For You

  • Basics of data filtering using DAX
  • Advanced filtering strategies
  • Real-world examples of data filtering
  • What DAX Filtering Is REALLY Doing

  • In-depth exploration of DAX filtering mechanics
  • Understanding DAX operations behind the scenes
  • Enhancing data analysis with advanced DAX knowledge
  • The Types Of Filters We Can Apply To Data

  • Exploring various data filters
  • Practical applications of different filters
  • Customizing data views with filters
  • How To Create a Percentage Using A Measure

  • Creating percentage-based calculations with DAX
  • Using measures to derive insights
  • Advanced DAX techniques for complex calculations
  • How You Can Change What You See Using DAX

  • Manipulating data views with DAX
  • Customizing reports and visuals using DAX
  • Hands-on practice with DAX-driven data manipulation
  • How The Power BI Report Filters and DAX Interact

  • Understanding the interaction between report filters and DAX
  • Enhancing report accuracy with DAX
  • Practical scenarios showcasing the interplay of filters and DAX
  • What is a Collab365 Challenge?

    Blue Certified Solution

    In many cases, our Challenges are built so that you can "learn by doing". To achieve this we follow our B.L.U.E. Framework. Learn why BLUE is a superior way to learn. Here's a summary of the 4 phases.

    step 1

    BUILD IT

    Learners conceptualise and start creating the app during the ‘Build It’ phase. They tap into the Power Platform’s capabilities to design an intuitive and user-friendly interface while meeting the task’s business requirements. This hands-on experience, right from the start, deepens their understanding of the platform and its functionalities.

    step 2

    LEARN IT

    As they move into the ‘Learn It’ stage, learners realise the platform’s intricacies, discovering functionalities they were previously unaware of. This phase provides an immediate feedback loop, allowing learners to correct misconceptions, deepen their understanding, and improve their skills.

    step 3

    USE IT

    In the ‘Use It’ phase, learners experience their creations from a user’s perspective. They test the app, identifying any flaws or usability issues. This hands-on testing and usage phase provides invaluable insights into user experience, an essential aspect of any app development process.

    step 4

    ENHANCE IT

    Finally, during the ‘Enhance It’ stage, learners refine their app based on the feedback and insights gained during testing. This iterative process simulates a real-world development cycle, reinforcing the importance of continual learning and improvement in the technology industry.

    LATONYA BLOUNT | Collaboration analyst

    "Now I get to show off my skills at work!"

    I needed to understand Power Apps formulas and have an idea of the why's and order. The coach explained it clearly and put it in terms that made it easy to understand and now I get to show off my skills at work. Not only that, if asked I can explain why I did something instead of saying, "This is what I found online and this should work.", without being able to explain the why it would work.

    The pace of the course was great. I was able to complete it between leaving work and before my next call.

    The detailed explanations and the short challenges along the way for me to try first before being shown how to successfully complete were fantastic. It was a moment to show that I understood and was comfortable enough with what I had learned.

    Earn an industry-recognised certification.

    Collab365 Certification Issued in Credly

    Upon successfully completing this training, you will be awarded a prestigious Collab365 certification, issued through Credly, the leader in digital credentials. This certification serves as a testament to your newly acquired skills and your dedication to professional growth.

    The Value of a Credly Certification:

    • Global Recognition: Your Credly badge is a globally acknowledged symbol of your Power BI expertise, enhancing your professional stature on platforms like LinkedIn and beyond.
    • Digital and Shareable: Easily share your achievements across social media and professional networks, increasing your visibility to potential employers and peers.
    • Verified Skills: Each badge carries detailed, verifiable information about the skills you've mastered, adding credibility and trust to your professional profile.

    Achieving a Credly certification through our Challenges and Success Paths not only marks your mastery of valuable skills but also significantly elevates your professional presence in the digital world.

    What do I need to take the challenge?

    No Previous skills necessary

    We've built the Challenge for anyone to follow along with, so you don't need any previous skills. Knowing a bit about Excel or being a bit 'technically minded' is really helpful but we'll give you what you need along the way.

    A Windows PC or Virtual Machine

    To follow along with this Challenge, you will need a Windows PC or a virtual machine running Windows. This is because Power BI Desktop won't install on a Mac or Linux machine. 

    Access To Power BI Desktop

    To get the most out of the Challenge, you'll want to practice using Power BI Desktop. You can do this either by joining the Microsoft 365 Developer Program, giving you access to all the Microsoft 365 services . Or, you can use your own Microsoft 365 Tenant. 

    This training includes:

    • 2 hours of study
    • Power BI Workbook Download
    • Source Data File Download
    • Watch on Desktop or Mobile

    Meet your Trainer:

    Jon Manderville, Coach

    Jon Manderville, Collab365 Coach

    Jon is one of the original Collab365 Coaches and has helped build the Academy into what you see today.

    He's passionate about the Power Platform but knows first-hand what it was like to begin fresh with this technology.

    Having worked as a Scrum Master for many years, Jon is someone who spotted the potential for Microsoft 365 services to help teams visualise their results, data and processes so that they could improve all the time.

    Jon's extensive business background and desire to build no-code solutions led him to start learning the Power Platform.

    You'll be in good hands with Jon. His style is relaxed but inclusive and mindful that not everyone starts from the same place. So be prepared to get involved and have some fun along the way.

    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.

    • Personal

    • Teams

    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.