{"product_id":"optimizing-dax-improving-dax-performance-in-microsoft-power-bi-and-analysis-services-paperback","title":"Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services - 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\u003eAlberto Ferrari\u003c\/b\u003e (Author), \u003cb\u003eMarco Russo\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eThis book is the state of the art of optimizing DAX expressions in Power BI and Analysis Services semantic models. Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eUse tools like Power BI Desktop Performance Analyzer and DAX Studio\u003c\/li\u003e\n\u003cli\u003eUnderstand the DAX formula engine \u003c\/li\u003e\n\u003cli\u003eLearn characteristics of different storage engines (VertiPaq, DirectQuery over SQL)\u003c\/li\u003e\n\u003cli\u003eRead DAX query plans\u003c\/li\u003e\n\u003cli\u003eOptimize common DAX constructs\u003c\/li\u003e\n\u003cli\u003eSolve security performance issues\u003c\/li\u003e\n\u003cli\u003eImprove DirectQuery response time\u003c\/li\u003e\n\u003cli\u003eControl the data placement in composite models to avoid bottlenecks\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e: proficiency in DAX and SQL (for DirectQuery), understanding of the Tabular engine used by semantic models, and familiarity with DAX Studio.\u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 818\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 1.62 x 9.25 x 7.5 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e April 30, 2024\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":52494181564723,"sku":"9781735365220","price":106.36,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0300\/5595\/6612\/files\/bNVo95Q_UL9781735365220.webp?v=1759974829","url":"https:\/\/www.vysn.com\/en-ca\/products\/optimizing-dax-improving-dax-performance-in-microsoft-power-bi-and-analysis-services-paperback","provider":"VYSN","version":"1.0","type":"link"}