Industry
e-commerce
Skills
approach
quality
data-modelling
Tools
power-bi
Learning Objectives
Understand the need for DAX over Power Query for dynamic calculations.
Learn how to create and apply DAX measures, calculated columns, and calculated tables.
Master key DAX concepts like row context vs filter context and aggregator vs iterator.
Explore advanced DAX functions like FILTER, CALCULATE, and RANKX to solve complex business scenarios.
Overview
Prerequisites
- Willingness to dive into DAX expressions and build dynamic, complex reports.
- Experience with Excel formulas and their usage in a business context.
- Basic understanding of Power Query for data ingestion and transformation.
- Familiarity with Power BI and its basic data modeling features.