Buying Options

Kindle Price:	$34.61
	includes tax, if applicable

Redeem a promotion code or gift card

Share <Embed>

Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel (Business Skills) by [Russo Marco, Ferrari Alberto]

Follow the Authors

Marco Russo

Alberto Ferrari

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

by Russo Marco (Author), Ferrari Alberto (Author) Format: Kindle Edition

501 ratings

See all formats and editions Hide other formats and editions

Amazon Price

New from

Used from

Kindle

"Please retry"

$34.61

—

Paperback, Import

"Please retry"

$67.35

$65.72

—

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

Length: 768 pages	Enhanced Typesetting: Enabled	Page Flip: Enabled
Language: English

Kindle e-Readers

Kindle (5th Generation)

Kindle Keyboard

Kindle DX

Kindle (2nd Generation)

Kindle (1st Generation)

Kindle Paperwhite

Kindle Paperwhite (5th Generation)

Kindle Touch
Kindle Fire Tablets

Kindle Fire HDX 8.9''

Kindle Fire HDX

Kindle Fire HD

Fire HD 10

Fire HD 8

Fire
Free Kindle Reading Apps

Kindle for Windows 8

Kindle Cloud Reader

Kindle for Android Phones

Kindle for Android Tablets

Kindle for iPhone

Kindle for iPod Touch

Kindle for iPad

Kindle for Mac

Kindle for PC
See all supported devices
Due to its large file size, this book may take longer to download

Customers who bought this item also bought

Page 1 of 1 Start overPage 1 of 1

Raviv Gil
221
Kindle Edition
$15.04
Marco Russo
129
Kindle Edition
$40.66
Ferrari Alberto
174
Kindle Edition
$29.22
Ken Puls
349
Kindle Edition
$14.28
Matt Allington
146
Kindle Edition
$15.08
Matt Allington
158
Kindle Edition
$13.96

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

--This text refers to an out of print or unavailable edition of this title.

Product details

ASIN : B07TS4FPZM
Publisher : Microsoft Press; 2 edition (2 July 2019)
Language : English
File size : 145577 KB
Simultaneous device usage : Up to 5 simultaneous devices, per publisher limits
Text-to-Speech : Enabled
Enhanced typesetting : Enabled
X-Ray : Not Enabled
Word Wise : Not Enabled
Print length : 768 pages
Page numbers source ISBN : 9353945488

Best Sellers Rank: 40,247 in Kindle Store (See Top 100 in Kindle Store)
- 2 in Microsoft SQL Server
- 5 in Microsoft Excel
- 6 in Spreadsheet Software

Customer Reviews:
501 ratings

What other items do customers buy after viewing this item?

Page 1 of 1 Start overPage 1 of 1

Customer reviews

5 star		86%
4 star		10%
3 star		3%
2 star 0% (0%)		0%
1 star		1%

How are ratings calculated?

Review this product

Write a customer review

Top reviews from Australia

There was a problem filtering reviews right now. Please try again later.

Amazon Customer

It's Like Having My Own Personal Tutor

Reviewed in Australia on 28 November 2020

Verified Purchase

This book is brilliant. In very easy to understand language, it takes a deep dive into DAX, explaining the seemingly inexplicable and making sense of complex concepts. This is a book that any-one who plans to write DAX should buy.

So as not to mislead you, the book expects you to have a basic understanding of DAX. If you are new to DAX, start off with an introductory book. Soon, you will want to know more and then this is the book for you.

Thank-you to the authors for great context and communication.

One person found this helpful

Helpful

Sean Fernandez

Missing content

Reviewed in Australia on 26 August 2020

Verified Purchase

This version is missing images when it comes to code, graphs etc. Not recommended. I'm sure the physical cooy does not have these issues

Helpful

Amazon Customer

Great book

Reviewed in Australia on 11 November 2019

Verified Purchase

Well written, easy to follow and understand

Helpful

Vijay Dasari

Detailed information

Reviewed in Australia on 5 June 2020

Verified Purchase

Excellent. Found what I was looking for.

Helpful

Top reviews from other countries

Matt P

Advanced

Reviewed in the United Kingdom on 21 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.

4 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.

LenkaW

Great book ❤️

Reviewed in the United Kingdom on 9 December 2020

Verified Purchase

It has it all! Everything in detail and very well written! I have been using Power Bi for the past 5 months and needed to understand how the DAX engine works in detail. This book is great for it!

Francisco Gutiérrez González

The bible of DAX

Reviewed in the United Kingdom on 8 January 2021

Verified Purchase

If you want to masters DAX, it’s the perfect book. They explain complicated things very well. Also they give multiple examples. It’s for all the public, from beginners to experts.

cwar

It's all here!

Reviewed in the United Kingdom on 23 August 2020

Verified Purchase

What an impressive book. It's a bit of a mind bender for me. I'm not sure how I'm going to use it. It's got everything in here that I need. I just need to figure out how to extract it!!!

See all reviews

Buying Options

Follow the Authors

Similar authors to follow

Similar authors to follow

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

Customers who bought this item also bought

Product description

About the Author

Product details

What other items do customers buy after viewing this item?

Customer reviews

Review this product

Top reviews from Australia

There was a problem filtering reviews right now. Please try again later.

Top reviews from other countries