Supercharge Excel: When You Learn to Write DAX for Power Pivot
- 3h 34m
- Matt Allington
- Tickling Keys
- 2018
Data analysis expressions (DAX) is the formula language of Power Pivot. Learning the DAX language is key to empower Excel users so they can take advantage of these new Business Intelligence (BI) capabilities. This volume clearly explains the concepts of Power Pivot while at the same time offering hands-on practice to engage the reader and help new knowledge stick. This second edition has been updated for the Excel 2016 user interface while still providing a bridge for readers wanting to learn DAX in the Excel environment and then transfer their new DAX skills across to Power BI.
About the Author
Matt Allington is a Microsoft Data Platform MVP that specializes in teaching and helping business users leverage the Power BI suite to achieve positive business outcomes.
In this Book
-
Introduction
-
Concept—Introduction to Data Modelling
-
Concept—Loading Data
-
Concept—Measures
-
DAX Topic—SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE()
-
Concept—Filter Propagation
-
Concept—Lookup Tables and Data Tables
-
DAX Topic—The Basic Iterators SUMX() and AVERAGEX()
-
DAX Topic—Calculated Columns
-
DAX Topic—CALCULATE()
-
Concept—Evaluation Context and Context Transition
-
DAX Topic—IF(), SWITCH(), and FIND()
-
DAX Topic—VALUES() and HASONEVALUE()
-
DAX Topic—ALL(), ALLEXCEPT(), and ALLSELECTED()
-
DAX Topic—FILTER()
-
DAX Topic—Time Intelligence
-
DAX Topic—RELATED() and RELATEDTABLE()
-
Concept—Disconnected Tables
-
Concept—KPIs
-
Concept—Multiple Data Tables
-
Concept—Cube Formulas
-
Moving from Excel to Power BI
-
Next Steps on Your DAX Journey
