LEADER 04130nam 22005775 450 001 9910300361103321 005 20240516111717.0 010 $a9781484234778 010 $a1484234774 024 7 $a10.1007/978-1-4842-3477-8 035 $a(CKB)4100000002891934 035 $a(MiAaPQ)EBC5335439 035 $a(DE-He213)978-1-4842-3477-8 035 $a(CaSebORM)9781484234778 035 $a(PPN)225554127 035 $a(OCoLC)1033544366 035 $a(OCoLC)on1033544366 035 $a(EXLCZ)994100000002891934 100 $a20180331d2018 u| 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aBeginning DAX with Power BI $eThe SQL Pro?s Guide to Better Business Intelligence /$fby Philip Seamark 205 $a1st ed. 2018. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2018. 215 $a1 online resource (270 pages) 311 08$a9781484234761 311 08$a1484234766 327 $aChapter 1: Introduction to DAX -- Chapter 2: Variables -- Chapter 3: Context -- Chapter 4: Summarizing and Aggregating -- Chapter 5: Joins -- Chapter 6: Filtering -- Chapter 7: Dates -- Chapter 8: Debugging and Optimizing -- Chapter 9: Practical DAX. 330 $aAttention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling challenges. Beginning DAX with Power BI teaches key concepts such as mapping techniques from SQL to DAX, filtering, grouping, joining, pivoting, and using temporary tables, all aimed at the SQL professional. Join author Philip Seamark as he guides you on a journey through typical business data transformation scenarios and challenges, and teaches you, step-by-step, how to resolve challenges using DAX. Tips, tricks, and shortcuts are included and explained, along with examples of the SQL equivalent, in order to accelerate learning. Examples in the book range from beginner to advanced, with plenty of detailed explanation when walking through each scenario. What You?ll Learn: Turbocharge your Power BI model by adding advanced DAX programming techniques Know when to use calculated measures versus calculated columns Generate new tables on the fly from existing data Optimize, monitor, and tune Power BI to improve performance of your models Discover new ideas, tricks, and time-saving techniques for better models This book is for business intelligence developers, business analysts, or any SQL user who wants to use Power BI as a reporting tool. A solid understanding of SQL is recommended, as examples throughout the book include the DAX equivalents to SQL problem/solution scenarios. Philip Seamark,a Senior BI architect with Trade Me and a Microsoft Data Platform MVP with more than 25 years of commercial experience delivering business applications across multiple technologies. He is an experienced database and BI professional with a deep understanding of the Microsoft stack and extensive knowledge of data warehouse (DW) methodologies and enterprise data modeling. Philip writes for the Power BI community site, and is a speaker at many industry events, Microsoft Ignite, Data Insights, Power BI User Groups, SQL Saturdays, and more. 606 $aMicrosoft software 606 $aMicrosoft .NET Framework 606 $aBig data 606 $aMicrosoft and .NET$3https://scigraph.springernature.com/ontologies/product-market-codes/I29030 606 $aBig Data/Analytics$3https://scigraph.springernature.com/ontologies/product-market-codes/522070 615 0$aMicrosoft software. 615 0$aMicrosoft .NET Framework. 615 0$aBig data. 615 14$aMicrosoft and .NET. 615 24$aBig Data/Analytics. 676 $a658.054 700 $aSeamark$b Philip$4aut$4http://id.loc.gov/vocabulary/relators/aut$01060070 801 0$bUMI 801 1$bUMI 801 2$bUMI 906 $aBOOK 912 $a9910300361103321 996 $aBeginning DAX with Power BI$92544849 997 $aUNINA