The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI, 2/e (Paperback)
Marco Russo, Alberto Ferrari
- 出版商: MicroSoft
- 出版日期: 2019-07-20
- 定價: $2,200
- 售價: 9.0 折 $1,980
- 語言: 英文
- 頁數: 816
- 裝訂: Paperback
- ISBN: 1509306978
- ISBN-13: 9781509306978
-
相關分類:
Excel、MSSQL、Power BI、SQL
-
相關翻譯:
DAX 權威指南:運用 Power BI、SQL Server Analysis Services 和 Excel 實現商業智能分析, 2/e (The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI, 2/e) (簡中版)
立即出貨 (庫存=1)
買這商品的人也買了...
-
$414$393 -
$383RabbitMQ實戰:高效部署分佈式消息隊列
-
$450$383 -
$1,782XML and JSON Recipes for SQL Server: A Problem-Solution Approach
-
$380$296 -
$407Power BI 數據分析:報表設計和數據可視化應用大全
-
$620$527 -
$356商業智能數據分析:從零開始學 PowerBI 和 Tableau 自助式BI
-
$1,000$850 -
$403Power BI 權威指南
-
$305商業智能:Power BI數據分析
-
$450$355 -
$450$351 -
$450$383 -
$620$527 -
$403RPA 開發與應用
-
$450RPA 學習指南:使用 UiPath 構建軟件機器人與自動化業務流程 (Learning Robotic Process Automation)
-
$505數據挖掘與機器學習 : PMML 建模 (下)
-
$1,080$853 -
$1,128$1,072 -
$450$383 -
$700$595 -
$2,025High Performance MySQL: Proven Strategies for Operating at Scale, 4/e (Paperback)
-
$2,100$1,995 -
$1,850$1,758
相關主題
商品描述
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
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查詢性能