Virtual Advanced DAX Measures
- Start: Jan 29, 2025 9:00 AM EST
- End: Jan 29, 2025 5:00 PM EST
- Cost: $745.00
- Instructor: Angelica Choo Quan
- Event Categories:
- Available Seats: Limited seats remaining!
- Tickets: Get your ticket HERE
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 01- Understanding Filter Context
- Explore the impact of row and filter context on your data models
- Module 02 – Developing Time Intelligence Calculations
- Analyze trends over time and make data-driven predictions
- Module 03 – Understanding Calculate
- Uncover the power and nuances of the CALCULATE function
- Module 04 – ALL, ALLEXCEPT, ALLSELECTED
- Learn how to remove or retain specific filters, focus on and disregard particular dimensions
- Module 05 – Preforming Rolling Totals
- Creating Rolling Totals and Analyzing Cumulative Values
Get tickets:
| Ticket type | Price | Quantity |
|---|---|---|
| Virtual Advanced DAX Measures (Jan 29, 2025 – 1/29/25) | $745.00 | |
Add an event to your calendar
Instructor – Angelica Choo Quan
Shortly after graduating from the University of Florida in 2012, Angelica moved to Jacksonville and began her career as a high school Biology teacher. As a trainer at Pragmatic Works, her primary goal is to help individuals feel more comfortable and confident using Power BI. While not in the office, she enjoys traveling around the city of Jax to check out local eateries, live music events, and performing arts.