東華大學圖書館 |

Language: English

Help

回圖書館首頁

手機版館藏查詢

Back

Switch To: Labeled | MARC Mode | ISBD

Pro DAX and data modeling in Power B...

Aspin, Adam.

Linked to FindBook

Google Book

Amazon

博客來

Pro DAX and data modeling in Power BI = creating the perfect semantic layer to drive your dashboard analytics /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Pro DAX and data modeling in Power BI/ by Adam Aspin.
Reminder of title:	creating the perfect semantic layer to drive your dashboard analytics /
Author:	Aspin, Adam.
Published:	Berkeley, CA :Apress : : 2023.,
Description:	xxiii, 465 p. :ill., digital ;24 cm.
[NT 15003449]:	1. Using Power BI Desktop to Create a Data Model -- 2. Extending The Data Model -- 3. The Semantic Layer -- 4. Calculated Columns -- 5. Calculating Across Tables -- 6. DAX Logical Functions -- 7. Date and Time Calculations in Columns -- 8. Introduction to Measures -- 9. Filtering Measures -- 10. CALCULATE() Modifiers -- 11. The Filter() Function -- 12. Iterators -- 13. Creating and Applying a Date Dimension -- 14. Time Intelligence -- 15. DAX Variables -- 16. Table Functions -- 17. Extending the Data Model -- 18. Evaluation Context -- Appendix A: Sample Data.
Contained By:	Springer Nature eBook
Subject:	Dashboards (Management information systems) -
Online resource:	https://doi.org/10.1007/978-1-4842-8995-2
ISBN:	9781484289952

Pro DAX and data modeling in Power BI = creating the perfect semantic layer to drive your dashboard analytics /
Aspin, Adam.

Pro DAX and data modeling in Power BIcreating the perfect semantic layer to drive your dashboard analytics /[electronic resource] :by Adam Aspin. - Berkeley, CA :Apress :2023. - xxiii, 465 p. :ill., digital ;24 cm.

1. Using Power BI Desktop to Create a Data Model -- 2. Extending The Data Model -- 3. The Semantic Layer -- 4. Calculated Columns -- 5. Calculating Across Tables -- 6. DAX Logical Functions -- 7. Date and Time Calculations in Columns -- 8. Introduction to Measures -- 9. Filtering Measures -- 10. CALCULATE() Modifiers -- 11. The Filter() Function -- 12. Iterators -- 13. Creating and Applying a Date Dimension -- 14. Time Intelligence -- 15. DAX Variables -- 16. Table Functions -- 17. Extending the Data Model -- 18. Evaluation Context -- Appendix A: Sample Data.

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.

ISBN: 9781484289952

Standard No.: 10.1007/978-1-4842-8995-2doiSubjects--Uniform Titles:

Microsoft Power BI (Computer file)
Subjects--Topical Terms:

2148753
Dashboards (Management information systems)

LC Class. No.: HD30.213

Dewey Class. No.: 658.4038011

Pro DAX and data modeling in Power BI = creating the perfect semantic layer to drive your dashboard analytics /
LDR:03055nmm a2200325 a 4500 001 2315183
003 DE-He213
005 20221125121201.0
006 m d
007 cr nn 008maaau
008 230902s2023 cau s 0 eng d
020 $a 9781484289952 $q (electronic bk.)
020 $a 9781484289945 $q (paper)
024 7 $a 10.1007/978-1-4842-8995-2 $2 doi
035 $a 978-1-4842-8995-2
040 $a GP $c GP $e rda
041 0 $a eng
050 4 $a HD30.213
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 658.4038011 $2 23
090 $a HD30.213 $b .A841 2023
100 1 $a Aspin, Adam. $3 2072187
245 1 0 $a Pro DAX and data modeling in Power BI $h [electronic resource] : $b creating the perfect semantic layer to drive your dashboard analytics / $c by Adam Aspin.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2023.
300 $a xxiii, 465 p. : $b ill., digital ; $c 24 cm.
505 0 $a 1. Using Power BI Desktop to Create a Data Model -- 2. Extending The Data Model -- 3. The Semantic Layer -- 4. Calculated Columns -- 5. Calculating Across Tables -- 6. DAX Logical Functions -- 7. Date and Time Calculations in Columns -- 8. Introduction to Measures -- 9. Filtering Measures -- 10. CALCULATE() Modifiers -- 11. The Filter() Function -- 12. Iterators -- 13. Creating and Applying a Date Dimension -- 14. Time Intelligence -- 15. DAX Variables -- 16. Table Functions -- 17. Extending the Data Model -- 18. Evaluation Context -- Appendix A: Sample Data.
520 $a 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.
630 0 0 $a Microsoft Power BI (Computer file) $3 3449087
650 0 $a Dashboards (Management information systems) $3 2148753
650 0 $a Business intelligence $x Computer programs. $3 812285
650 0 $a Information visualization $x Computer programs. $3 1374878
650 0 $a Visual analytics. $3 907655
650 1 4 $a Microsoft. $3 3593799
650 2 4 $a Business Analytics. $3 3592362
650 2 4 $a Data Analysis and Big Data. $3 3538537
710 2 $a SpringerLink (Online service) $3 836513
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-8995-2
950 $a Professional and Applied Computing (SpringerNature-12059)