--- product_id: 19222547 title: "Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI" price: "NT$185" currency: TWD in_stock: false reviews_count: 13 url: https://www.desertcart.tw/products/19222547-definitive-guide-to-dax-the-business-intelligence-with-microsoft-excel store_origin: TW region: Taiwan --- # Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI **Price:** NT$185 **Availability:** ❌ Out of Stock ## Quick Answers - **What is this?** Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI - **How much does it cost?** NT$185 with free shipping - **Is it available?** Currently out of stock - **Where can I buy it?** [www.desertcart.tw](https://www.desertcart.tw/products/19222547-definitive-guide-to-dax-the-business-intelligence-with-microsoft-excel) ## Best For - Customers looking for quality international products ## Why This Product - Free international shipping included - Worldwide delivery with tracking - 15-day hassle-free returns ## Description This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio Review: a DAX book aimed at taking people from intermediate to expert - Wow! I make a good part of my living off of Power Pivot and DAX and it's people like Alberto and Marco that have helped me all along the way - with their blog posts, conference sessions, and books. This book really stands out though. It's a very complete treatment of DAX which is the core language of all the "new" analytical tools that Microsoft has released over the past three years. DAX is a language that, at first glance, looks a lot like Excel and is pretty easy to learn for an advanced Excel user but the language quickly becomes more difficult if you haven't taken the time to understand its foundations - and that's what this book addresses ... in great detail. I've worked full-time with DAX for over three years now and I had lightbulbs going off constantly as I was reading this book. Incredible feeling, thank you. Said another way, there is knowledge in this book that will be hard to appreciate, that you'll miss entirely, unless you've had lots of experience with DAX. Beginners will get something from the book undoubtedly but it's really a book aimed at taking people from intermediate to expert. I agree with other reviewers who have suggested that DAX beginners start with Albert & Marco's other book "Microsoft Excel 2013 Building Data Models with PowerPivot" Review: The best DAX resource, I have been waiting for a long - I have been looking forward for this book to be available for shipment. Alberto and Marco's previous books were my 101's into self service BI, but after finishing them, the only resource to go deeper were only available in different online sources. I think this book is definitely a must have for all BI professionals. They are great in explaining even the most difficult concepts, and the material in this book is very much up-to-date with the new Power BI Service and Power BI Desktop. If you are beginner in DAX and BI, it might be too detailed as a starter, the authors even warn you about this, but if you want to become an expert, and want to go down into the details, this is your best resource. If you are a beginner, and especially if you are coming from the business analyst side, start with the other book - Microsoft Excel 2013 Building Data Models with PowerPivot , but buy this one as well, as definitely you will need it. ## Technical Specifications | Specification | Value | |---------------|-------| | Best Sellers Rank | #399,706 in Books ( See Top 100 in Books ) #10 in Microsoft SQL Server #67 in Microsoft Excel Guides #110 in Spreadsheet Books | | Customer Reviews | 4.7 out of 5 stars 262 Reviews | ## Images ![Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI - Image 1](https://m.media-amazon.com/images/I/91PqnIixCYL.jpg) ## Customer Reviews ### ⭐⭐⭐⭐⭐ a DAX book aimed at taking people from intermediate to expert *by A***N on November 24, 2015* Wow! I make a good part of my living off of Power Pivot and DAX and it's people like Alberto and Marco that have helped me all along the way - with their blog posts, conference sessions, and books. This book really stands out though. It's a very complete treatment of DAX which is the core language of all the "new" analytical tools that Microsoft has released over the past three years. DAX is a language that, at first glance, looks a lot like Excel and is pretty easy to learn for an advanced Excel user but the language quickly becomes more difficult if you haven't taken the time to understand its foundations - and that's what this book addresses ... in great detail. I've worked full-time with DAX for over three years now and I had lightbulbs going off constantly as I was reading this book. Incredible feeling, thank you. Said another way, there is knowledge in this book that will be hard to appreciate, that you'll miss entirely, unless you've had lots of experience with DAX. Beginners will get something from the book undoubtedly but it's really a book aimed at taking people from intermediate to expert. I agree with other reviewers who have suggested that DAX beginners start with Albert & Marco's other book "Microsoft Excel 2013 Building Data Models with PowerPivot" ### ⭐⭐⭐⭐⭐ The best DAX resource, I have been waiting for a long *by T***R on November 5, 2015* I have been looking forward for this book to be available for shipment. Alberto and Marco's previous books were my 101's into self service BI, but after finishing them, the only resource to go deeper were only available in different online sources. I think this book is definitely a must have for all BI professionals. They are great in explaining even the most difficult concepts, and the material in this book is very much up-to-date with the new Power BI Service and Power BI Desktop. If you are beginner in DAX and BI, it might be too detailed as a starter, the authors even warn you about this, but if you want to become an expert, and want to go down into the details, this is your best resource. If you are a beginner, and especially if you are coming from the business analyst side, start with the other book - Microsoft Excel 2013 Building Data Models with PowerPivot , but buy this one as well, as definitely you will need it. ### ⭐⭐⭐⭐⭐ Learn from the DAX Masters!!! *by J***Y on October 19, 2016* The Definitive Guide to DAX is the BEST, most in-depth treatment of the DAX language and DAX engine (VertiPaq). It is best suited for someone who already is familiar with the DAX language. Every aspect of the DAX language is introduced in a logical progression, including Evaluation Contexts, Time Intelligence, and Relationships. The insight and low-level details that Marco and Alberto provide are unique to this book. Later chapters describe the Vertipaq engine, and how to optimize both the data model and DAX queries. There's also plenty of examples on using DAX Studio (this is something I couldn't find in any other books). If you are looking to REALLY learn DAX, then this book is for you. It takes time and effort to get through all of this material, but it is well worth it. Marco and Alberto are the DAX Masters! Their DAX Workshop video is based upon the content in this book, and is excellent. Highly recommended. ## Frequently Bought Together - Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI - Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence --- ## Why Shop on Desertcart? - 🛒 **Trusted by 1.3+ Million Shoppers** — Serving international shoppers since 2016 - 🌍 **Shop Globally** — Access 737+ million products across 21 categories - 💰 **No Hidden Fees** — All customs, duties, and taxes included in the price - 🔄 **15-Day Free Returns** — Hassle-free returns (30 days for PRO members) - 🔒 **Secure Payments** — Trusted payment options with buyer protection - ⭐ **TrustPilot Rated 4.5/5** — Based on 8,000+ happy customer reviews **Shop now:** [https://www.desertcart.tw/products/19222547-definitive-guide-to-dax-the-business-intelligence-with-microsoft-excel](https://www.desertcart.tw/products/19222547-definitive-guide-to-dax-the-business-intelligence-with-microsoft-excel) --- *Product available on Desertcart Taiwan* *Store origin: TW* *Last updated: 2026-06-07*