Intro to DAX course teaches DAX fundamentals and advanced functions, empowering you to enhance Power BI or Tabular data models with complex calculations.
DAX is a both a programming and query language that gives you the ability to extend what is possible in either your Power BI or Tabular data models. The Introduction to DAX course is designed to teach the fundamentals of DAX while emphasizing the basic building blocks required to author more complex DAX calculations. This video based course quickly moves from basic DAX functions to more advanced functions like CALCULATE and iterator functions like SUMX.
Course Outline ( Free Preview)
Module 01 - Introduction
Angelica welcomes you to the course and outlines what you’ll learn about DAX and how it fits into Power BI. You’ll get a quick roadmap of calculated columns, measures, and common function types, plus what you should understand by the end so you can apply DAX confidently in real reports.
Module 02 - Data Modeling
Before writing formulas, you need a model that supports them. Angelica explains why relationships, table structure, and clean fields matter for DAX results. You’ll learn the basics of how a good model makes calculations easier, faster, and more predictable.
Module 03 - What Is DAX?28 min.
Learn what DAX is and why it’s so powerful for analytics in Power BI. Angelica breaks down what DAX is used for, how it differs from Excel formulas in practice, and the kinds of problems it solves, like dynamic totals, custom KPIs, and logic that responds to filters.
Module 04 - Creating Calculated Columns48 min.
Start building with calculated columns and understand when they’re the right tool. Angelica walks through how columns are calculated row by row, where they live in the model, and how they can be used for grouping, categorizing, or building relationships and logic fields.
Module 05 - Loading in Data6 min.
Bring data into Power BI so you can practice DAX with something real. Angelica walks through a basic loading workflow and highlights the key checks that matter before you calculate, data types, column names, and ensuring your tables are ready to support formulas.
Module 06 - Logical Functions21 min.
Learn how to create smarter calculations using logical functions. Angelica demonstrates common logic patterns like IF-style decisions, handling blanks, and building conditions that change results based on rules. This module helps you move from basic math into real business logic.
Module 07 - Creating Calculated Measures17 min.
Measures are where DAX becomes truly dynamic. Angelica shows how measures respond to filters and visuals, and how to write calculations that change based on the context of a report. You’ll build practical measures and learn when a measure is better than a column.
Module 08 - Table Functions17 min.
Explore table functions that help you filter, shape, and summarize data inside DAX. Angelica introduces the idea of returning tables as part of a calculation and shows how table functions unlock more flexible logic for totals, lists, and advanced measure behavior.
Module 09 - Class Wrap Up1 min.
Wrap up with a recap of what you learned, modeling foundations, columns, measures, and core function types. Angelica reinforces key takeaways and shares next steps for practicing DAX so you can keep building confidence and expand into more advanced topics.
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.
.png)