國立高雄大學圖資館 |

Language: English

Back

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

Record Type:	Electronic resources : Monograph/item
Title/Author:	Pro DAX and data modeling in Power BIby 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.
Contained By:	Springer Nature eBook
Subject:	Dashboards (Management information systems)
Online resource:	https://doi.org/10.1007/978-1-4842-8995-2
ISBN:	9781484289952$q(electronic bk.)

Pro DAX and data modeling in Power BIcreating 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$q(electronic bk.)

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

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

722914
Dashboards (Management information systems)

LC Class. No.: HD30.213

Dewey Class. No.: 658.4038011

Pro DAX and data modeling in Power BIcreating the perfect semantic layer to drive your dashboard analytics /
LDR:03055nmm a2200325 a 4500 001 645666
003 DE-He213
005 20221125121201.0
006 m d
007 cr nn 008maaau
008 231208s2023 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 593534
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 863151
650 0 $a Dashboards (Management information systems) $3 722914
650 0 $a Business intelligence $x Computer programs. $3 257800
650 0 $a Information visualization $x Computer programs. $3 536323
650 0 $a Visual analytics. $3 285731
650 1 4 $a Microsoft. $3 915087
650 2 4 $a Business Analytics. $3 919294
650 2 4 $a Data Analysis and Big Data. $3 913147
710 2 $a SpringerLink (Online service) $3 273601
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)