Visual Calculations for DAX in Power BI

Learn to simplify DAX in Power BI with visual calculations. Instructor Greg Trzeciak guides through tips, techniques, and templates to enhance data analysis, covering custom visuals, DirectQuery, and more in this essential course.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

Welcome to our Visual Calculations for DAX in Power BI course, led by instructor Greg Trzeciak! This course is designed to simplify DAX (Data Analysis eXpression) through visual calculations. It also offers students a wealth of tips and techniques to enhance their Power BI skills. Participants will learn how to enable and utilize visual calculations in Power BI, explore the interface, and leverage templates/functions to streamline their data analysis processes. The course also covers the integration of visual calculations with custom visualizations, DirectQuery, and calculation groups, while addressing conditional formatting and general limitations. With a focus on making DAX easier and more accessible, this course promises to expedite the data modeling process, making it an essential learning path for those looking to improve their Power BI proficiency.

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Module 00 - Class Files

Module 01 - Introduction to Visual Calculations 5 min.

Module 02- What are Visual Calculations? 3 min.

Module 03 - How to enable Visual Calculations 5 min.

Module 05 - Introduction to Templates 36 min.

Module 04 - Anatomy of Visual Calculations 7 min.

Module 06 - YTD, QTD, MTD 7 min.

Module 07 - Moving Sum Demonstration 5 min.

Module 08 - IF Statements 3 min.

Module 09 - Power BI Service 6 min.

Module 10 - Custom Visuals 5 min.

Module 11 - Direct Query and Calculation Groups 1 min.

Module 12 - Conclusion 1 min.

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Greg Trzeciak

Power BI Trainer

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!

Learn More

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

1+ hours hours of training
Access on mobile and browser
Certificate of Completion