Search  for anything...
Microsoft

The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)

  • Based on 1,251 reviews
Condition: New
Checking for the best price...
$43.99 Why this price?
Holiday Deal · 25% off was $58.99

Buy Now, Pay Later

As low as $10 / mo
  • – 4-month term
  • – No impact on credit
  • – Instant approval decision
  • – Secure and straightforward checkout

Ready to go? Add this product to your cart and select a plan during checkout.

Payment plans are offered through our trusted finance partners Klarna, Affirm, Afterpay, Apple Pay, and PayTomorrow. No-credit-needed leasing options through Acima may also be available at checkout.

Learn more about financing & leasing here.

Selected Option

Free shipping on this product

This item is eligible for return within 30 days of receipt

To qualify for a full refund, items must be returned in their original, unused condition. If an item is returned in a used, damaged, or materially different state, you may be granted a partial refund.

To initiate a return, please visit our Returns Center.

View our full returns policy here.

Availability: In Stock.
Fulfilled by Amazon
Arrives Thursday, Dec 18
Order within 14 hours and 27 minutes
Available payment plans shown during checkout
Protection Plan Protect Your Purchase
Checking for protection plans...

Recently Viewed

Format: Paperback


Description

Now expanded and updated with modern best practices, this is the most complete guide to Microsoft’s DAX language for business intelligence, data modeling, and analytics. Expert 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, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX’s remarkable capabilities? This no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel· Master core DAX concepts, including calculated columns, measures, and calculation groups· Work efficiently with basic and advanced table functions· Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions· Perform time-based calculations· Use calculation groups and calculation items· Use syntax of variables (VAR) to write more readable, maintainable code· Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters· Master advanced optimization techniques, and improve performance in aggregations· Optimize data models to achieve better compression· Measure DAX query performance with DAX Studio and learn how to optimize your DAX Read more


Publisher ‏ : ‎ Microsoft Press; 2nd edition (July 2, 2019)


Language ‏ : ‎ English


Paperback ‏ : ‎ 768 pages


ISBN-10 ‏ : ‎ 1509306978


ISBN-13 ‏ : ‎ 78


Item Weight ‏ : ‎ 3 pounds


Dimensions ‏ : ‎ 7.38 x 1.73 x 9.13 inches


Best Sellers Rank: #32,977 in Books (See Top 100 in Books) #3 in Microsoft SQL Server #9 in Microsoft Excel Guides #10 in Spreadsheet Books


#3 in Microsoft SQL Server:


#9 in Microsoft Excel Guides:


Frequently asked questions

If you place your order now, the estimated arrival date for this product is: Thursday, Dec 18

Yes, absolutely! You may return this product for a full refund within 30 days of receiving it.

To initiate a return, please visit our Returns Center.

View our full returns policy here.

  • Klarna Financing
  • Affirm Pay in 4
  • Affirm Financing
  • Afterpay Financing
  • PayTomorrow Financing
  • Financing through Apple Pay
Leasing options through Acima may also be available during checkout.

Learn more about financing & leasing here.

Similar Products

Top Amazon Reviews

    • 5.0 out of 5 stars Great book for people using Power BI
Bought this book as a gift to my wife who uses PowerBI in her job. Super helpful. Great book
Reviewed in the United States on June 4, 2023 by RZM
    • 5.0 out of 5 stars excellent learning material for Dax developers
Review Image by Ronald García Ronald García
I highly recommend this book for those who want to improve power bi skills and go deeper in DAX language
Reviewed in the United States on April 5, 2023 by Ronald García Ronald García
    • 5.0 out of 5 stars Amazing Book
I have been reading this book for 5 months. I am not finished. I spend a half hour every day. Marco Russo and Alberto Ferrari are teachers and very good ones. There is so much effort put into this book it feels like they actually care about you and your DAX journey. I have gotten so much out of this book. Though I can't say that I truly understand it. Yet I see that my DAX has improved quite a bit. With many mysteries still remaining. I am just an average person trying to be a bit above average and I thank the authors for helping me in my quest. I highly recommend this book. Though if I were starting off from scratch I would read Matt Allington's book Supercharge Power BI and possibly Power Pivot and Power BI by Rob Collie and Avichal Singh though that book is a bit older. In summation: my lack of understanding is my issue, the book itself is extremely comprehensive and well written. So I will continue on my DAX journey and hopefully will continue to improve as I make my way through the final 3rd of the book. ... show more
Reviewed in the United States on May 19, 2020 by Robert Wolf
    • 5.0 out of 5 stars Great reference
Very happy I picked this up.
Reviewed in the United States on October 20, 2022 by Tyler
    • 5.0 out of 5 stars The most holy text of the DAX religion...
Reading this book makes me realize how little I know about the things I thought I knew. I've been writing DAX for years, having started with PowerPivot (no spaces in the name, that's how old) for Excel 2010, and in my job I still find new, interesting problems to solve. This book is an amazing reference for anyone interested in pushing the calculation envelope in DAX and their models. I've built models spanning billions of records with the expert guidance this book provides. I would almost consider this a holy book of the DAX religion. If you ever wanted someone to explain why god created CALCULATE() and how we should observe it daily in our lives, this is the book, and the Italians preach adeptly. I'm a big believer, and you will be too. ... show more
Reviewed in the United States on June 2, 2020 by Anonymous
    • 5.0 out of 5 stars Excellent Resource!
I love this book! The authors know their audience. It's written in such a way that the reader feels as though they're being taught by instructors. They give helpful learning tips along the way and know when a certain topic is especially difficult. For example, at the end of a certain arduous chapter, the conclusion starts, "In this final section of a long and difficult chapter..." Upon completion, it is easy to go back and use as a guide for specific topics as they arise. ... show more
Reviewed in the United States on August 17, 2021 by Sarah Elrays
    • 5.0 out of 5 stars Now I really know what's happening under the hood
This was a really important book for my understanding of Dax formulas. I watched a lot of videos online, and forums can often give you formulas that will solve your problem but I never fully understood what was happening. I feel very confident now after reading this book. I can visualize what is happening with my model and it has made writing Dax much easier. I'm not saying that I'm an expert or that it's easy now, but I know how it works and the functions that are available to me. If you really want to know what's happening, this is the book for you. ... show more
Reviewed in the United States on December 11, 2019 by S. Bellomo
    • 5.0 out of 5 stars Mastering DAx
A good accompaniment to the Mastering DAX videos. Thanks to the Authors Marco Russo and Alberto Ferrari.
Reviewed in the United States on April 18, 2022 by Michael Lenenkokuai

Can't find a product?

Find it on Amazon first, then paste the link below.
Checking for best price...