Book description
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX's remarkable capabilities? This no-compromise "deep dive" is exactly what you need.
Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel
· Master core DAX concepts, including calculated columns, measures, and calculation groups
· Work efficiently with basic and advanced table functions
· Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions
· Perform time-based calculations
· Use calculation groups and calculation items
· Use syntax of variables (VAR) to write more readable, maintainable code
· Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters
· Master advanced optimization techniques, and improve performance in aggregations
· Optimize data models to achieve better compression
· Measure DAX query performance with DAX Studio and learn how to optimize your DAX
Table of contents
- Cover Page
- Title Page
- Copyright Page
- Contents at a Glance
- Contents
- Foreword
- Acknowledgments
- Introduction to the second edition
- Introduction to the first edition
- Chapter 1. What is DAX?
- Chapter 2. Introducing DAX
- Chapter 3. Using basic table functions
- Chapter 4. Understanding evaluation contexts
- Chapter 5. Understanding CALCULATE and CALCULATETABLE
- Chapter 6. Variables
- Chapter 7. Working with iterators and with CALCULATE
- Chapter 8. Time intelligence calculations
- Chapter 9. Calculation groups
-
Chapter 10. Working with the filter context
- Using HASONEVALUE and SELECTEDVALUE
- Introducing ISFILTERED and ISCROSSFILTERED
- Understanding differences between VALUES and FILTERS
- Understanding the difference between ALLEXCEPT and ALL/VALUES
- Using ALL to avoid context transition
- Using ISEMPTY
- Introducing data lineage and TREATAS
- Understanding arbitrarily shaped filters
- Conclusions
- Chapter 11. Handling hierarchies
- Chapter 12. Working with tables
- Chapter 13. Authoring queries
- Chapter 14. Advanced DAX concepts
-
Chapter 15. Advanced relationships
- Implementing calculated physical relationships
- Implementing virtual relationships
- Understanding physical relationships in DAX
- Using bidirectional cross-filters
- Understanding one-to-many relationships
- Understanding one-to-one relationships
- Understanding many-to-many relationships
- Choosing the right type of relationships
- Managing granularities
- Managing ambiguity in relationships
- Conclusions
- Chapter 16. Advanced calculations in DAX
- Chapter 17. The DAX engines
- Chapter 18. Optimizing VertiPaq
- Chapter 19. Analyzing DAX query plans
- Chapter 20. Optimizing DAX
- Index
- Code Snippets
Product information
- Title: Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel, 2nd Edition
- Author(s):
- Release date: August 2019
- Publisher(s): Microsoft Press
- ISBN: 9780134865867
You might also like
book
Data Analysis with Microsoft Power BI
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
Mastering Microsoft Power BI
Design, create and manage robust Power BI solutions to gain meaningful business insights About This Book …
book
Microsoft Power BI Cookbook
Get more out of Microsoft Power BI turning your data into actionable insights About This Book …
book
Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI
Prepare for Microsoft Exam 70-778-and help demonstrate your real-world mastery of Power BI data analysis and …