The Definitive Guide to DAX, 2nd Edition

Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel



Bookstore > Books > The Definitive Guide to DAX, 2nd Edition

Price$43.99 - $49.88
Rating
AuthorsMarco Russo, Alberto Ferrari
PublisherMicrosoft Press
Published2019
Pages768
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101509306978
ISBN-139781509306978
EBook Hardcover Paperback

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.


  1. (5 books)
  2. (4 books)



4 5 2

Similar Books


The Definitive Guide to MongoDB, 3rd Edition

The Definitive Guide to MongoDB, 3rd Edition

by David Hows, Eelco Plugge, Peter Membrey, Tim Hawkins

The Definitive Guide to MongoDB, Third Edition, is updated for MongoDB 3 and includes all of the latest MongoDB features, including the aggregation framework introduced in version 2.2 and hashed indexes in version 2.4. The Third Edition also now includes Node.js along with Python.MongoDB is the most popular of the "Big Data&q...

Price:  $48.19  |  Publisher:  Apress  |  Release:  2015

ActionScript for Flash MX: The Definitive Guide, 2nd Edition

ActionScript for Flash MX: The Definitive Guide, 2nd Edition

by Colin Moock

ActionScript for Flash MX: The Definitive Guide is the most complete, up-to-date reference available for the latest version of ActionScript. Author Colin Moock has added hundreds of new code examples to show new Flash MX techniques in the real world. The book's language reference alone has nearly doubled from the first edition, with mor...

Price:  $6.06  |  Publisher:  O'Reilly Media  |  Release:  2002

The Definitive Guide to MySQL 5, 3rd Edition

The Definitive Guide to MySQL 5, 3rd Edition

by Michael Kofler

Whether you're a novice or intermediate user, you will benefit from extensive coverage of core MySQL features like user administration, basic and advanced querying, and security. You will also be introduced to several standard and third-party tools, like MySQL Administrator, Query Browser, and the popular PHPMyAdmin tool.MySQL 5 is slated...

Price:  $4.86  |  Publisher:  Apress  |  Release:  2005

The Definitive Guide to Jython

The Definitive Guide to Jython

by Josh Juneau, Jim Baker, Frank Wierzbicki, Leo Soto Munoz, Victor Ng

Jython is an open source implementation of the high-level, dynamic, object-oriented scripting language Python seamlessly integrated with the Java platform. The predecessor to Jython, JPython, is certified as 100% Pure Java. Jython is freely available for both commercial and noncommercial use and is distributed with source code. Jython is ...

Price:  $44.99  |  Publisher:  Apress  |  Release:  2010

The Definitive Guide to SugarCRM

The Definitive Guide to SugarCRM

by John Mertic

SugarCRM is a leading open-source customer relations management tool and development platform with nearly 5.5 million downloads, nearly 17,000 developers, and lots more users.The Definitive Guide to SugarCRM is the first official SugarCRM book available to developers and users. This definitive book begins with a discussion of the SugarCRM...

Price:  $60.03  |  Publisher:  Apress  |  Release:  2009

The Definitive Guide to HTML5 Video

The Definitive Guide to HTML5 Video

by Silvia Pfeiffer

Plugins will soon be a thing of the past. The Definitive Guide to HTML5 Video is the first authoritative book on HTML5 video, the new web standard that allows browsers to support audio and video elements natively. This makes it very easy for web developers to publish audio and video, integrating both within the general presentation of web...

Price:  $29.11  |  Publisher:  Apress  |  Release:  2010

The Definitive Guide to Drupal 7

The Definitive Guide to Drupal 7

by Benjamin Melancon, Allie Micka, Amye Scavarda, Benjamin Doherty, Bojhan Somers, Karoly Negyesi, Jacine Rodriguez, Moshe Weitzman, Roy Scholten, Ryan Szrama, Sam Boyer, Jacine Luisi, Stephane Corlosquet, Amanda Miller-Johnson, Dan Hakimzadeh, Kasey Do

The Definitive Guide to Drupal 7 is the most comprehensive book for getting sites done using the powerful and extensible Drupal content management system. Written by a panel of expert authors, the book covers every aspect of Drupal, from planning a successful project all the way up to making a living from designing Drupal sites and to con...

Price:  $13.99  |  Publisher:  Apress  |  Release:  2011

The Definitive Guide to HTML5

The Definitive Guide to HTML5

by Adam Freeman

The Definitive Guide to HTML5 provides the breadth of information you'll need to start creating the next generation of HTML5 websites. It covers all the base knowledge required for standards-compliant, semantic, modern website creation. It also covers the full HTML5 ecosystem and the associated APIs that complement the core HTML5 language...

Price:  $5.48  |  Publisher:  Apress  |  Release:  2011