Buy new:

S$62.89

In stock.

US imports may differ from local products. Additional terms apply. Learn More.

[{"displayPrice":"S$62.89","priceAmount":62.89,"currencySymbol":"S$","integerValue":"62","decimalSeparator":".","fractionalValue":"89","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"WpTMxzjlVVCpkstn7DZC1hGAYm5J7GflH8jqZU9uGWmCSaOezPGZJqY240Z7H%2F5tZYdcbx%2BVytlBNAK2lS3lEpp3Lqqsim9zbMrnZ8D1vOaWBSZu2xPcN9qHMnjjwKC%2F0e3qEM71u1K4zADUOyURgZktXAe1Lu5nQdEBLKW7EAPmE%2BT%2F8WcHPHvgfUp%2Bvh5U","locale":"en-SG","buyingOptionType":"NEW"}]

S$S$62.89 () Includes selected options. Includes initial monthly payment and selected options. Details

Secure transaction

Ships from and sold by Amazon US.

Have one to sell?

Sell on Amazon

Other Sellers on Amazon

Added

Not added

S$68.06
FREE Delivery. No Minimum order value for first order in this category Details

Sold by: Amazon SG

Added

Not added

S$111.49
& FREE Delivery

Sold by: Book Reach (USA)

See this image

Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Paperback – Illustrated, 20 July 2019

by Marco Russo (Author), Alberto Ferrari (Author)

982 ratings

See all formats and editions

Amazon Price

New from

Used from

Paperback, Illustrated

""

S$62.89

S$65.47

Paperback
S$62.89

3 Used from S$65.47 6 New from S$62.89

Enhance your purchase

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

ISBN-10

1509306978
ISBN-13

978-1509306978
Edition

2
Publication date

20 July 2019
Language

English
Print length

768 pages
See all details

Frequently bought together

+

Total Price:

To see our price, add these items to your cart.

One of these items is shipped sooner than the other.

Show details Hide details

Choose items to buy together.

by Marco Russo Paperback
S$62.89
In stock.
Ships from and sold by Amazon US.
Get it Feb 16 - 17
by Gil Raviv Paperback
S$57.16
Only 3 left in stock.
Ships from and sold by Amazon SG.

Gil Raviv
345
Paperback
9 offers from S$50.65
Marco Russo
196
Paperback
11 offers from S$63.95
Alberto Ferrari
287
Paperback
5 offers from S$40.70

Product description

About the Author

Marco Russo and Alberto Ferrari are the founders of sqlbi.com, where they regularly publish articles about Microsoft Power BI, Power Pivot, DAX, and SQL Server Analysis Services. They have worked with DAX since the fi rst beta version of Power Pivot in 2009 and, during these years, sqlbi.com became one of the major sources for DAX articles and tutorials. Their courses, both in-person and online, are the major source of learning for many DAX enthusiasts.

They both provide consultancy and mentoring on business intelligence (BI) using Microsoft technologies. They have written several books and papers about Power BI, DAX, and Analysis Services. They constantly help the community of DAX users providing content for the websites daxpatterns.com, daxformatter.com, and dax.guide.

Marco and Alberto are also regular speakers at major international conferences, including Microsoft Ignite, PASS Summit, and SQLBits. Contact Marco at marco.russo@sqlbi.com, and contact Alberto at alberto.ferrari@sqlbi.com

Product details

Language ‏ : ‎ English
Paperback ‏ : ‎ 768 pages
ISBN-10 ‏ : ‎ 1509306978
ISBN-13 ‏ : ‎ 978-1509306978

Best Sellers Rank: 26,291 in Books (See Top 100 in Books)
- 57 in Computing & Internet Databases
- 90 in Software & Graphics
- 281 in Graphics & Multimedia Software

Customer reviews:
982 ratings

Customer reviews

4.7 out of 5

982 global ratings

5 star		83%
4 star		12%
3 star		3%
2 star		1%
1 star		1%

How are ratings calculated?

Review this product

Write a customer review

Top reviews from other countries

Matt P

Advanced

Reviewed in the United Kingdom 🇬🇧 on 20 February 2020

Verified Purchase

This is a clear, well-written book but the title/blurb is somewhat misleading, as I would consider it to be aimed specifically at advanced/heavy users - or people intending to be advanced users - and it spends all its time on DAX and mostly ignores PowerBI itself. There is a fair amount of material on writing code for which a simple PowerBI off-the-shelf measure or trick already exists, for example. A large part of the book is devoted to optimising queries, which assumes your dataset is 5m+ rows.

There is a lot of material related to workarounds for some pretty obscure needs. For some reason the authors are obsessed with correctly calculating percentages of subgroups in tables and there are pages and pages on that throughout the book.

Perhaps the most frustrating part is that there is one chapter on basically "how to solve real-world problems with DAX" - for example, making sure your year-on-year comparisons are accurate, or honing your year-to-date analysis - but this is very short; I wish it had been the whole book.

13 people found this helpful

Andrzej Leszkiewicz

The DAX Bible

Reviewed in the United Kingdom 🇬🇧 on 5 February 2021

Verified Purchase

This books doesn't require a lot of comments. It's the DAX Bible. The Definitive Guide to DAX means what it says - it's The Definitive Guide to DAX. You'll find (almost) everything about DAX in this book. It's not a book for fast reading. This book will stay with you for a while. Use this book to read about DAX, to understand DAX, to practice your DAX (using companion content, which includes a demo database), to optimize your data models and DAX. The book is not easy reading, because DAX is not just a list of functions, DAX is based on the fundamental concepts we need to understand. To understand the concepts of DAX you'll need help of an expert. Marco Russo and Alberto Ferrari are the best DAX experts and their consulting time is really expensive. But they put all their knowledge into this book which will cost you less than $40-50. If you're going to work with DAX you must have this book.

One person found this helpful

Richard S

The DAX Bible

Reviewed in the United Kingdom 🇬🇧 on 8 January 2022

Verified Purchase

I've found this pretty brilliant so far, I've studied through to chapter 6. They say that chapters 4 and 5, on contexts and CALCULATE respectively, are the absolute key ones to nail and the difficulty does ramp up at this point, but apparently once mastered you're well over halfway there. Some chapters necessitate multiple readings, and you'll need to take notes.

The style makes the first reading very easy but re-reading for note taking purposes is slightly more long winded as you have to skip through the educational "wrong" bits to keep only the actual correct stuff. I like this balance though because first read of new concepts in DAX can be very dispiriting.

I feel that understanding this book cover to cover will make me a genuine DAX guru, and I would recommend it to you if that's your goal also

One person found this helpful

Remmyjulius

Takes you from newbie to expert-ish

Reviewed in the United Kingdom 🇬🇧 on 22 September 2021

Verified Purchase

Amazing book, very well written and organised. I normally prefer watching training videos for learning but this has been far better. Concepts are clearly explained. For me, the biggest thing is that you not only learn how, you also learn why. This is very crucial

One person found this helpful

D

Best complete Dax language guide

Reviewed in the United Kingdom 🇬🇧 on 4 June 2021

Verified Purchase

Best book for learning Dax thoroughly, later chapters more technical. I started learning with a more beginners book but when I needed deeper explanation and more advanced material this book is all you need. It’s a Dax bible that should be on everyone’s shelf who wants to learn the untracked of the Dax language

See all reviews

Amazon Web Services Scalable Cloud Computing Services	Amazon Fresh Groceries & More Right To Your Door	Goodreads Book reviews & recommendations

Shopbop Designer Fashion Brands	AbeBooks Books, art & collectables	Alexa Actionable Analytics for the Web

Book Depository Books With Free Delivery Worldwide	IMDb Movies, TV & Celebrities	DPReview Digital Photography

Buy new:

S$62.89

Amazon International Store

Other Sellers on Amazon

Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Paperback – Illustrated, 20 July 2019

Enhance your purchase

Frequently bought together

Customers who bought this item also bought

Product description

About the Author

Product details

Customer reviews

Review this product

Top reviews from Singapore

Top reviews from other countries

Buy new: S$62.89

Amazon International Store

Other Sellers on Amazon

Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Paperback – Illustrated, 20 July 2019

Enhance your purchase

Frequently bought together

Customers who bought this item also bought

Product description

About the Author

Product details

Customer reviews

Review this product

Top reviews from Singapore

Top reviews from other countries

Buy new:

S$62.89