The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI eBook (2e) : 9780134865874

The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI eBook (2e)

Ferrari
 
Edition
 
2
ISBN
 
9780134865874
ISBN 10
 
0134865871
Published
 
01/07/2019
Published by
 
Pearson Higher Ed USA
Pages
 
Format
 
 
Title type
eBook
$50.99
NZ/Pacific customers only
 
 
This eText can only be purchased by people residing in New Zealand, Fiji, Samoa, Tonga or Cook Islands with a credit card from the same country. Click here to find the Pearson website for your region.
 
Description
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 optimisation. 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

The full text downloaded to your computer

With eBooks you can:

  • search for key concepts, words and phrases
  • make highlights and notes as you study
  • share your notes with friends

eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.

Upon purchase, you will receive via email the code and instructions on how to access this product.

Time limit

The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.

Table of contents
  • 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
Access Code info.

To get the most out of your eBook you need to download the VitalSource Bookshelf software. This software is free to download and use. View the VitalSource Bookshelf system requirements here.

Download Information: Once purchased, you can view and/or download your eBook instantly, either via the download link which you will receive as soon as you complete your online order or by viewing the download link against the order in the My Account area of this website.

Please note: eBooks are available for download immediately and cannot be returned once purchased.