{"product_id":"beginning-dax-with-power-bi-the-sql-pros-guide-to-better-business-intelligence-paperback","title":"Beginning Dax with Power Bi: The SQL Pro's Guide to Better Business Intelligence - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003ePhilip Seamark\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003eAttention 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. \u003c\/p\u003e\u003cp\u003e\u003ci\u003eBeginning \u003c\/i\u003e\u003ci\u003eDAX with Power BI\u003c\/i\u003e 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.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eWhat You'll Learn\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eTurbocharge your Power BI model by adding advanced DAX programming techniques\u003c\/li\u003e\n\u003cli\u003eKnow when to use calculated measures versus calculated columns\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eGenerate new tables on the fly from existing data\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eOptimize, monitor, and tune Power BI to improve performance of your models\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eDiscover new ideas, tricks, and time-saving techniques for better models\u003cbr\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eWho This Book Is For\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBusiness 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.\u003c\/p\u003e\u003ch3\u003eBack Jacket\u003c\/h3\u003e\u003cp\u003eAttention 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.\u003c\/p\u003e\u003cp\u003e\u003ci\u003eBeginning \u003c\/i\u003e\u003ci\u003eDAX with Power BI\u003c\/i\u003e 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.\u003c\/p\u003e\u003cp\u003eWhat You'll Learn: \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eTurbocharge your Power BI model by adding advanced DAX programming techniques\u003c\/li\u003e\n\u003cli\u003eKnow when to use calculated measures versus calculated columns\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eGenerate new tables on the fly from existing data\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eOptimize, monitor, and tune Power BI to improve performance of your models\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eDiscover new ideas, tricks, and time-saving techniques for better models\u003c\/li\u003e\n\u003c\/ul\u003e\u003cb\u003eThis book is for\u003c\/b\u003e 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.​\u003cbr\u003e\u003cb\u003ePhilip Seamark, \u003c\/b\u003ea 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.\u003cbr\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cb\u003ePhilip Seamark \u003c\/b\u003eis an experienced Data Warehouse and BI Consultant with a deep understanding of the Microsoft stack and extensive knowledge of data warehouse (DW) methodologies and enterprise data modeling. He is recognized for his analytical, conceptual, and problem-solving abilities with more than 25 years of commercial experience delivering business applications across a broad range of technologies. His expertise runs the gamut from project management, dimensional modeling, performance tuning, ETL design, development and optimization, report and dashboard design to installation and administration. \u003c\/p\u003e\u003cp\u003eIn 2017 he received a Microsoft Data Platform MVP award due to his contributions to the PowerBI community site, as well as speaking at many data, analytic, and reporting events around the world. Philip is also the founder and organizer of the Wellington Power BI User Group.\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 264\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.6 x 10 x 7 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eIllustrated:\u003c\/strong\u003e Yes\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e March 31, 2018\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":52479709479219,"sku":"9781484234761","price":77.18,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0300\/5595\/6612\/files\/aG5lRWQvekFySHZ5TW1SWWxVYk02Zz09.webp?v=1759694323","url":"https:\/\/www.vysn.com\/en-ca\/products\/beginning-dax-with-power-bi-the-sql-pros-guide-to-better-business-intelligence-paperback","provider":"VYSN","version":"1.0","type":"link"}