001453378 000__ 03384cam\a2200529\i\4500 001453378 001__ 1453378 001453378 003__ OCoLC 001453378 005__ 20230314003348.0 001453378 006__ m\\\\\o\\d\\\\\\\\ 001453378 007__ cr\cn\nnnunnun 001453378 008__ 221129s2022\\\\nyua\\\\o\\\\\001\0\eng\d 001453378 019__ $$a1352448367 001453378 020__ $$a9781484289952$$q(electronic bk.) 001453378 020__ $$a1484289951$$q(electronic bk.) 001453378 020__ $$z9781484289945 001453378 020__ $$z1484289943 001453378 0247_ $$a10.1007/978-1-4842-8995-2$$2doi 001453378 035__ $$aSP(OCoLC)1351986727 001453378 040__ $$aORMDA$$beng$$erda$$epn$$cORMDA$$dEBLCP$$dGW5XE$$dYDX$$dOCLCF$$dUKAHL$$dOCLCQ$$dTOH$$dOCLCQ 001453378 049__ $$aISEA 001453378 050_4 $$aHD30.213 001453378 08204 $$a658.4/038011$$223/eng/20221129 001453378 1001_ $$aAspin, Adam,$$eauthor. 001453378 24510 $$aPro DAX and data modeling in Power BI :$$bcreating the perfect semantic layer to drive your dashboard analytics /$$cAdam Aspin. 001453378 250__ $$a[First edition]. 001453378 264_1 $$aNew York, NY :$$bApress,$$c[2022] 001453378 300__ $$a1 online resource (xxiii, 465 pages) :$$billustrations 001453378 336__ $$atext$$btxt$$2rdacontent 001453378 337__ $$acomputer$$bc$$2rdamedia 001453378 338__ $$aonline resource$$bcr$$2rdacarrier 001453378 500__ $$aIncludes index. 001453378 5050_ $$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. 001453378 506__ $$aAccess limited to authorized users. 001453378 520__ $$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. 001453378 63000 $$aMicrosoft Power BI (Computer file) 001453378 650_0 $$aDashboards (Management information systems) 001453378 650_0 $$aBusiness intelligence$$xComputer programs. 001453378 650_0 $$aInformation visualization$$xComputer programs. 001453378 650_0 $$aVisual analytics. 001453378 655_0 $$aElectronic books. 001453378 77608 $$iPrint version: $$z1484289943$$z9781484289945$$w(OCoLC)1346537507 001453378 852__ $$bebk 001453378 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-1-4842-8995-2$$zOnline Access$$91397441.1 001453378 909CO $$ooai:library.usi.edu:1453378$$pGLOBAL_SET 001453378 980__ $$aBIB 001453378 980__ $$aEBOOK 001453378 982__ $$aEbook 001453378 983__ $$aOnline 001453378 994__ $$a92$$bISE