The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI, 2/e (Paperback)

Marco Russo, Alberto Ferrari

買這商品的人也買了...

商品描述

This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading 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, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need.
 
Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI
  • Master core DAX concepts, including calculated columns, measures, and error handling
  • Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions
  • Perform time-based calculations: YTD, MTD, previous year, working days, and more
  • Work with expanded tables, complex functions, and elaborate DAX expressions
  • Perform calculations over hierarchies, including parent/child hierarchies
  • Use DAX to express diverse and unusual relationships
  • Measure DAX query performance with SQL Server Profiler and DAX Studio

商品描述(中文翻譯)

這本全面且權威的指南將教你如何使用DAX語言進行商業智能、數據建模和分析。領先的Microsoft BI顧問Marco Russo和Alberto Ferrari將幫助你掌握從表函數到高級代碼和模型優化的一切。你將學到當你運行DAX表達式時發生的一切,DAX與其他語言的不同行為,以及如何利用這些知識來編寫快速、健壯的代碼。如果你想充分利用DAX的強大功能和靈活性,這本「深入探討」是你所需要的。

使用DAX進行Microsoft SQL Server Analysis Services、Excel和Power BI的強大數據分析
- 掌握核心DAX概念,包括計算列、度量和錯誤處理
- 理解評估上下文和CALCULATE、CALCULATETABLE函數
- 執行基於時間的計算:YTD、MTD、去年同期、工作日等
- 使用擴展表、複雜函數和精緻的DAX表達式
- 在層次結構中進行計算,包括父/子層次結構
- 使用DAX表達多樣且不尋常的關係
- 使用SQL Server Profiler和DAX Studio測量DAX查詢性能