{"product_id":"the-definitive-guide-to-dax-by-marco-russo-9780138244729","title":"The Definitive Guide to DAX","description":"\u003cdiv class=\"book-description\"\u003e\n\u003cp\u003eSeasoned experts Alberto Ferrari and Marco Russo help you master DAX for superior business intelligence solutions. \u003cem\u003eThe Definitive Guide to DAX\u003c\/em\u003e is an authoritative resource for mastering the DAX language, which is pivotal for creating measures for semantic models in Microsoft Power BI, Fabric, Analysis Services, and Excel. With years of experience since the inception of Power Pivot, the authors offer a comprehensive reference that navigates through the unique and complex concepts of DAX, making it an essential tool for BI professionals.\u003c\/p\u003e\n\n\u003cp\u003eThis third edition updates you with the latest features and provides a framework for writing efficient DAX code, enhancing your ability to customise calculations in data models.\u003c\/p\u003e\n\n\u003cp\u003eYou will gain the skills necessary to understand and apply advanced DAX concepts, structure code in user-defined functions, and leverage new calendars for time intelligence calculations. By reading this book, you will:\u003c\/p\u003e\n\n\u003cul\u003e\n    \u003cli\u003eUnderstand the foundational concepts of DAX and its unique language structure.\u003c\/li\u003e\n    \u003cli\u003eMaster the use of evaluation contexts to enhance data analysis.\u003c\/li\u003e\n    \u003cli\u003eUtilise CALCULATE and CALCULATETABLE functions effectively.\u003c\/li\u003e\n    \u003cli\u003eImplement variables to simplify complex DAX expressions.\u003c\/li\u003e\n    \u003cli\u003eLeverage classic and new calendar-based time intelligence functions.\u003c\/li\u003e\n    \u003cli\u003eWork with iterators to perform advanced calculations.\u003c\/li\u003e\n    \u003cli\u003eApply visual calculations to improve report interactivity.\u003c\/li\u003e\n    \u003cli\u003eCreate and manage calculation groups for dynamic reporting.\u003c\/li\u003e\n    \u003cli\u003eHandle complex hierarchies and relationships in data models.\u003c\/li\u003e\n    \u003cli\u003eAuthor DAX queries for testing and troubleshooting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eAbout This Book:\u003c\/p\u003e\n\n\u003cp\u003eFor BI professionals and Excel power users eager to deepen their understanding of DAX and enhance their data modelling capabilities with advanced techniques. Suitable for data analysts and IT specialists seeking to optimise their use of Microsoft Power BI, Fabric, Analysis Services, and Excel for more efficient and insightful data analysis.\u003c\/p\u003e\n\u003c\/div\u003e","brand":"Ingram Book Company","offers":[{"title":"Default Title","offer_id":47479688560876,"sku":"9780138244729","price":138.0,"currency_code":"NZD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0705\/7784\/8556\/files\/9780138244729-the-definitive-guide-to-dax.jpg?v=1775593126","url":"https:\/\/bookhero.co.nz\/products\/the-definitive-guide-to-dax-by-marco-russo-9780138244729","provider":"Book Hero","version":"1.0","type":"link"}