Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
 Search:   
Call our store: 9955 5567 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
 
Browse by Subject
 TAFE Accounting
 TAFE I.T./Computing
 TAFE - Other
I.T
 .NET
 Windows 8
 Adobe CS6
 Cisco
 CCNA 2012
 CCNP 2012
 Java
 VB
 ASP
 Web Design
 E-Commerce
 Project Management
 ITIL
 Macintosh
 Mobile Devices
 Linux
 Windows Server 2012
 SQL Server 2012
 SAP
Certification
 MCITP
 MCTS
Economics and Business
 Accounting
 Business Information Systems
 Economics
 Finance
 Management
 Marketing
 TAX
 Human Resources
Academic
 Law
 Nursing
 Medical
 Psychology
 Engineering

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

by: Russo, Marco & Ferrari, Alberto

Notify me when in stock

On-line Price: $59.46 (includes GST)

Paperback package 816

15%Off Retail Price

You save: $10.49

PRE-ORDER now! This title is due to release in the near future... It is on order and we will charge/ship as soon as it arrives.

Retail Price: $69.95

Publisher: Pearson Education,24.01.19

Category: COMPUTER SCIENCE Level: B/I/A

ISBN: 1509306978
ISBN13: 9781509306978

Add to Shopping Cart

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

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