Pro Dax and Data Modeling in Power Bi: Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics

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

開發強大的資料模型，將來自不同來源的資料結合成一個有條理的整體。然後使用 Power BI 的查詢語言 DAX 來擴展您的資料模型，以創建可重複使用的度量，以在儀表板中提供精心製作的自定義計算。

本書首先教您如何定義和增強資料模型的核心結構，使其成為一個真正的語義層，將複雜的資料轉化為熟悉的業務術語。您將學習如何創建計算列來解決基本的分析挑戰。然後，您將進一步掌握 DAX 度量，以精確地切片和切割您的資料。

本書還展示了如何使用日期維度在 Power BI 中進行時間分析。您將看到 DAX 時間智能函數如何簡化您對時間的資料分析。最後，本書展示了如何擴展 DAX 以過濾和計算資料集，並開發 DAX 表格函數和變數來處理複雜的查詢。

您將學到什麼

- 創建清晰高效的資料模型，支援深入分析
- 在資料模型中定義核心屬性，如資料類型和標準化格式
- 定義交叉過濾設定以增強資料模型
- 使用 DAX 創建計算列和自定義表格
- 使用 DAX 擴展資料模型，創建可重複使用的計算和度量
- 使用日期維度和時間智能函數進行基於時間的分析

本書適合對象

從 CEO 到商業智能開發人員，從商業智能和資料架構師和分析師到高級用戶和 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年。在此期間，他基於Microsoft的數據和分析產品套件開發了數十個報告和分析系統。

Adam畢業於牛津大學，他的職業生涯始於出版業，後來轉向IT行業。數據庫很快成為他的熱情所在，他在這個領域的經驗涵蓋了從dBase到Oracle，從Access到MySQL，偶爾也涉足DB2的世界。然而，當使用Microsoft的數據和分析堆棧時，他最擅長的是在Azure和本地環境中。

商業智能一直是Adam過去20年的主要關注領域。他在金融、銀行、公用事業、休閒、奢侈品和製藥等領域為一系列客戶應用了他的技能。

Adam多年來一直是SQLServerCentral.com和Simple-Talk的頻繁投稿者。他經常在SQL Saturdays和SQLBits等活動上演講。作為一位流利的法語演講者，Adam在法國和瑞士工作了多年。

Adam是Apress出版的知名書籍的作者，包括《SQL Server數據集成食譜》、《使用SQL Server報告服務的商業智能》、《在Excel中使用Power View、3D Maps、Get & Transform和Power BI進行高影響力數據可視化》、《使用Power Query和M在Microsoft Excel中進行數據混合》和《Pro Power BI主題創建》。