Home > Store

Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI, 2nd Edition

Register your product to gain access to bonus material or receive a coupon.

Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI, 2nd Edition

eBook (Watermarked)

  • Your Price: $35.19
  • List Price: $43.99
  • Estimated Release: Jul 27, 2018
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Description

  • Copyright 2019
  • Pages: 816
  • Edition: 2nd
  • eBook (Watermarked)
  • ISBN-10: 0-13-486589-8
  • ISBN-13: 978-0-13-486589-8

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

Sample Content

Table of Contents

Foreword
Introduction
Chapter 1: What is DAX?
Chapter 2: Introducing DAX
Chapter 3: Using basic table functions
Chapter 4: Understanding evaluation contexts
Chapter 5: Understanding CALCULATE and CALCULATETABLE
Chapter 6: DAX examples
Chapter 7: Time intelligence calculations
Chapter 8: Statistical functions
Chapter 9: Advanced table functions
Chapter 10: Advanced evaluation context
Chapter 11: Handling hierarchies
Chapter 12: Advanced relationships
Chapter 13: The VertiPaq engine
Chapter 14: Optimizing data models
Chapter 15: Analyzing DAX query plans
Chapter 16: Optimizing DAX
Index

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership