Virtual Advanced DAX Measures
- Start: Apr 17, 2024 9:00 AM EDT
- End: Apr 17, 2024 5:00 PM EDT
- Cost: $745.00
- Instructor: Greg Trzeciak
- Event Categories:
- Avaliable Seats: Limited seats remaining!
- Missed your change to sign up, but still want to get in on the fun? Contact us!
Event description
Welcome to our Advanced DAX Measures Bootcamp, an immersive day class meticulously crafted for data professionals and analysts keen on mastering the intricacies of Data Analysis Expressions Measures. In this intensive day-program, you'll embark on a deep exploration of DAX Measures, the powerful formula language at the heart of Power BI that allows for insightful calculations. Led by seasoned instructors, this course will empower you to harness the full potential of DAX Measures, enabling you to create sophisticated calculations, advanced business metrics, and insightful analyses. Through hands-on exercises and real-world applications, you will learn to design complex measures, understand filter context, leverage advanced Time Intelligence functions to solve intricate analytical challenges and understand Calculate. From time intelligence and rolling totals to CALCULATE and ALL, this bootcamp covers a comprehensive range of DAX measures concepts. Collaborative learning environments and interactive discussions will enhance your problem-solving skills, ensuring you leave with a deep understanding of DAX measures. Join us on this transformative journey and elevate your data analysis capabilities with the mastery of DAX measures, making you a proficient and sought-after data expert.
Prerequisites
This class is targeted for advanced power users or end-users looking to enhance their skills in Power BI and in general Data Modeling. Because this class is focused on self-service end-user solutions, previous SQL Server knowledge is not required. While it’s not mandatory, ideally students should have an intermediate understanding of database terminology such as tables, views, columns, rows, etc.
System Requirements
- Windows 10, Windows 7, Windows 8
- Microsoft Power BI Desktop requires Internet Explorer 10 or greater
- Microsoft Power BI Desktop is available for 32-bit (x86) and 64-bit (x64) platforms
- Power BI Desktop [https://aka.ms/pbiSingleInstaller](https://aka.ms/pbiSingleInstaller)
Course Outline:
- Module One- Understanding Filter Context
- Explore the impact of row and filter context on your data models
- Module Two – Developing Time Intelligence Calculations
- Analyze trends over time and make data-driven predictions
- Module Three – Understanding Calculate
- Uncover the power and nuances of the CALCULATE function
- Module Four – ALL, ALLEXCEPT, ALLSELECTED
- Learn how to remove or retain specific filters, focus on and disregard particular dimensions
- Module Five – Preforming Rolling Totals
- Creating Rolling Totals and Analyzing Cumulative Values
Add an event to your calendar
Instructor – Greg Trzeciak
Gregory Trzeciak has his master’s degree in Education from the University of Florida. He has 9 years of teaching experience in high school, college level, and summer programs where he was recognized as a top educator and leader in interactive education. As a trainer at Pragmatic Works, his primary goal is to help individuals gain confidence in using Power BI and the Power Platform. While not in the office, he enjoys fantasy football, walking his dog, and running half-marathons!