LEADER 03864nam  22005535  450 
001 9910632473603321
005 20230224135754.0
010   $a1-4842-8995-1
024 7 $a10.1007/978-1-4842-8995-2
035   $a(MiAaPQ)EBC7147243
035   $a(Au-PeEL)EBL7147243
035   $a(CKB)25483517400041
035   $a(OCoLC)1351986727
035   $a(OCoLC-P)1351986727
035   $a(DE-He213)978-1-4842-8995-2
035   $a(CaSebORM)9781484289952
035   $a(PPN)266356885
035   $a(EXLCZ)9925483517400041
100   $a20221125d2023      u|         0
101 0 $aeng
135   $aurcnu||||||||
181   $ctxt$2rdacontent
182   $cc$2rdamedia
183   $acr$2rdacarrier
200 10$aPro DAX and Data Modeling in Power BI $eCreating the Perfect Semantic Layer to Drive Your Dashboard Analytics /$fby Adam Aspin
205   $a1st ed. 2023.
210  1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2023.
215   $a1 online resource (475 pages)
300   $aIncludes index.
311 08$aPrint version: Aspin, Adam Pro DAX and Data Modeling in Power BI Berkeley, CA : Apress L. P.,c2022 9781484289945 
327   $a1. 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.
330   $aDevelop 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.
606   $aDashboards (Management information systems)
606   $aBusiness intelligence$xComputer programs
606   $aInformation visualization$xComputer programs
606   $aVisual analytics
615  0$aDashboards (Management information systems)
615  0$aBusiness intelligence$xComputer programs.
615  0$aInformation visualization$xComputer programs.
615  0$aVisual analytics.
676   $a791.436553
700   $aAspin$b Adam$0895187
801  0$bMiAaPQ
801  1$bMiAaPQ
801  2$bMiAaPQ
906   $aBOOK
912   $a9910632473603321
996   $aPro DAX and Data Modeling in Power BI$92982330
997   $aUNINA