DAX Cookbook
暫譯: DAX 食譜

Name: DAX Cookbook
Price: 1368 TWD
Availability: InStock
Author: Deckler, Greg
ISBN: 1839217073

Deckler, Greg

出版商: Packt Publishing
出版日期: 2020-03-19
定價: $1,520
售價: 9.0 折 $1,368
語言: 英文
頁數: 552
裝訂: Quality Paper - also called trade paper
ISBN: 1839217073
ISBN-13: 9781839217074
相關分類: 大數據 Big-data、Data Science

立即出貨 (庫存=1)

商品描述

DAX provides an extra edge by extracting key information from the data that is already present in your model. Filled with examples of practical, real-world calculations geared toward business metrics and key performance indicators, this cookbook features solutions that you can apply for your own business analysis needs.

You'll learn to write various DAX expressions and functions to understand how DAX queries work. The book also covers sections on dates, time, and duration to help you deal with working days, time zones, and shifts. You'll then discover how to manipulate text and numbers to create dynamic titles and ranks, and deal with measure totals. Later, you'll explore common business metrics for finance, customers, employees, and projects. The book will also show you how to implement common industry metrics such as days of supply, mean time between failure, order cycle time and overall equipment effectiveness. In the concluding chapters, you'll learn to apply statistical formulas for covariance, kurtosis, and skewness. Finally, you'll explore advanced DAX patterns for interpolation, inverse aggregators, inverse slicers, and even forecasting with a deseasonalized correlation coefficient.

By the end of this book, you'll have the skills you need to use DAX's functionality and flexibility in business intelligence and data analytics.

商品描述(中文翻譯)

DAX 提供了額外的優勢，通過從您模型中已存在的數據中提取關鍵信息。這本食譜書充滿了針對商業指標和關鍵績效指標的實用、現實世界計算的範例，提供了您可以應用於自身商業分析需求的解決方案。

您將學會撰寫各種 DAX 表達式和函數，以了解 DAX 查詢的運作方式。書中還涵蓋了有關日期、時間和持續時間的部分，幫助您處理工作日、時區和班次。接著，您將發現如何操作文本和數字，以創建動態標題和排名，並處理度量總和。稍後，您將探索財務、客戶、員工和項目的常見商業指標。這本書還將向您展示如何實施常見行業指標，例如供應天數、平均故障時間、訂單週期時間和整體設備效率。在最後幾章中，您將學會應用協方差、峰度和偏度的統計公式。最後，您將探索用於插值、反向聚合器、反向切片器，甚至使用去季節性相關係數進行預測的高級 DAX 模式。

在本書結束時，您將具備使用 DAX 在商業智慧和數據分析中所需的功能和靈活性的技能。

作者簡介

Greg Deckler is Vice President of the Microsoft Practice at Fusion Alliance and has been a professional technology systems consultant for over 25 years. Internationally recognized as an expert in Power BI, Greg Deckler is a Microsoft MVP for Data Platform and a superuser within the Power BI community with over 100,000 messages read, more than 11,000 replies, over 2,300 answers, and more than 75 entries in the Quick Measures Gallery. Greg founded the Columbus Azure ML and Power BI User Group (CAMLPUG) and presents at numerous conferences and events, including SQL Saturday, DogFood, and the Dynamic Communities User Group/Power Platform Summit

作者簡介(中文翻譯)

Greg Deckler 是 Fusion Alliance 的 Microsoft 實踐副總裁，並且擁有超過 25 年的專業技術系統顧問經驗。Greg Deckler 在 Power BI 領域被國際公認為專家，是 Microsoft Data Platform 的 MVP，並且在 Power BI 社群中是一位超級使用者，已閱讀超過 100,000 則訊息，回覆超過 11,000 次，提供超過 2,300 個答案，並在 Quick Measures Gallery 中有超過 75 個條目。Greg 創立了 Columbus Azure ML 和 Power BI 使用者小組 (CAMLPUG)，並在多個會議和活動中發表演講，包括 SQL Saturday、DogFood 和 Dynamic Communities 使用者小組/Power Platform 峰會。