Download The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills) PDF EPUB
Author: Author
Pages: 592
Size: 3.720,13 Kb
Publication Date: October 23,2015
Category: SQL Server
This comprehensive and authoritative lead will educate you on the DAX vocabulary for business intelligence, data modeling, and analytics. You’ll learn just what happens beneath the hood when you operate a DAX expression, how DAX behaves in different ways from various other languages, and how exactly to use this understanding to create fast, robust code. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari assist you to master from table features through advanced code and model optimization. If you would like to leverage most of DAX’s impressive power and versatility, this no-compromise “deep dive” is strictly the thing you need.
Perform effective data evaluation with DAX for Microsoft SQL Server Evaluation Solutions, Excel, and Power BI
- Master core DAX principles, including calculated columns, methods, and error managing
- Understand evaluation contexts and the CALCULATE and CALCULATETABLE features
- Perform time-centered calculations: YTD, MTD, previous year, business days, and even more
- Use expanded tables, complex features, and elaborate DAX expressions
- Perform calculations over hierarchies, including parent/kid hierarchies
- Make use of DAX expressing diverse and unusual human relationships
- Measure DAX query overall performance with SQL Server Profiler and DAX Studio