Pro Dax and Data Modeling in Power Bi: Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics
暫譯: Pro Dax 與 Power BI 中的數據建模：創建完美的語義層以推動您的儀表板分析
Aspin, Adam
商品描述
Develop powerful data models that bind data from disparate sources into a coherent whole. Then extend your data models using DAX-the query language that underpins Power BI-to create reusable measures to deliver finely-crafted custom calculations in your dashboards.
This book starts off teaching you how to define and enhance the core structures of your data model to make it a true semantic layer that transforms complex data into familiar business terms. You'll learn how to create calculated columns to solve basic analytical challenges. Then you'll move up to mastering DAX measures to finely slice and dice your data.
The book also shows how to handle temporal analysis in Power BI using a Date dimension. You will see how DAX Time Intelligence functions can simplify your analysis of data over time. Finally, the book shows how to extend DAX to filter and calculate datasets and develop DAX table functions and variables to handle complex queries.
What You Will Learn
- Create clear and efficient data models that support in-depth analytics
- Define core attributes such as data types and standardized formatting consistently throughout a data model
- Define cross-filtering settings to enhance the data model
- Make use of DAX to create calculated columns and custom tables
- Extend your data model with custom calculations and reusable measures using DAX
- Perform time-based analysis using a Date dimension and Time Intelligence functions
Who This Book Is For
Everyone from the CEO to the Business Intelligence developer and from BI and Data architects and analysts to power users and IT managers can use this book to outshine the competition and create the data framework that they need and interactive dashboards using Power BI
商品描述(中文翻譯)
開發強大的數據模型，將來自不同來源的數據整合成一個連貫的整體。然後，使用 DAX（支撐 Power BI 的查詢語言）擴展您的數據模型，以創建可重用的度量，為您的儀表板提供精心設計的自定義計算。
本書首先教您如何定義和增強數據模型的核心結構，使其成為真正的語義層，將複雜數據轉換為熟悉的商業術語。您將學習如何創建計算列以解決基本的分析挑戰。接著，您將掌握 DAX 度量，以精細地切割和分析您的數據。
本書還展示了如何使用日期維度在 Power BI 中處理時間分析。您將看到 DAX 時間智能函數如何簡化您對數據隨時間變化的分析。最後，本書展示了如何擴展 DAX 以過濾和計算數據集，並開發 DAX 表函數和變數以處理複雜查詢。
**您將學到什麼**
- 創建清晰且高效的數據模型，以支持深入分析
- 在整個數據模型中一致地定義核心屬性，如數據類型和標準化格式
- 定義交叉過濾設置以增強數據模型
- 利用 DAX 創建計算列和自定義表
- 使用 DAX 擴展您的數據模型，進行自定義計算和可重用的度量
- 使用日期維度和時間智能函數執行基於時間的分析
**本書適合誰**
從 CEO 到商業智能開發人員，從 BI 和數據架構師及分析師到高級用戶和 IT 經理，所有人都可以使用本書來超越競爭對手，創建所需的數據框架和使用 Power BI 的互動儀表板。
作者簡介
Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for 17 years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft data and analytics product suite.
A graduate of Oxford University, Adam began his career in publishing before moving into IT. Databases soon became a passion, and his experience in this arena ranges from dBase to Oracle, and Access to MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe when using the Microsoft data and analytics stack-both in Azure and on-premises.
Business Intelligence has been Adam's principal focus for the last 20 years. He has applied his skills for a range of clients in the areas of finance, banking, utilities, leisure, luxury goods, and pharmaceuticals.
Adam has been a frequent contributor to SQLServerCentral.com and Simple-Talk for several years. He is a regular speaker at events such as SQL Saturdays and SQLBits. A fluent French speaker, Adam has worked in France and Switzerland for many years.
Adam is the author of popular Apress books: SQL Server Data Integration Recipes; Business Intelligence with SQL Server Reporting Services; High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform, and Power BI; Data Mashup with Microsoft Excel Using Power Query and M; and Pro Power BI Theme Creation.
作者簡介(中文翻譯)
亞當·阿斯平（Adam Aspin） 是一位位於英國的獨立商業智慧顧問。他在 SQL Server 上工作了 17 年。在這段時間內，他基於微軟的數據和分析產品套件開發了數十個報告和分析系統。
亞當畢業於牛津大學，最初在出版行業開始他的職業生涯，隨後轉入資訊科技領域。數據庫很快成為他的熱情所在，他在這個領域的經驗涵蓋了 dBase、Oracle、Access 和 MySQL，偶爾也涉獵 DB2 的世界。然而，當使用微軟的數據和分析堆疊時，他最感自在，無論是在 Azure 還是本地環境中。
商業智慧是亞當在過去 20 年的主要專注領域。他為金融、銀行、公用事業、休閒、奢侈品和製藥等多個客戶應用他的技能。
亞當在 SQLServerCentral.com 和 Simple-Talk 上貢獻頻繁，已經有好幾年了。他是 SQL Saturdays 和 SQLBits 等活動的常客演講者。亞當流利地講法語，並在法國和瑞士工作多年。
亞當是幾本受歡迎的 Apress 書籍的作者，包括：SQL Server 數據整合食譜； 使用 SQL Server Reporting Services 的商業智慧； 在 Excel 中使用 Power View、3D 地圖、獲取與轉換及 Power BI 的高影響力數據可視化； 使用 Power Query 和 M 的 Microsoft Excel 數據混合； 以及 Pro Power BI 主題創建。
