Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
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
 Windows 8
 Adobe CS6
 CCNA 2012
 CCNP 2012
 Web Design
 Project Management
 Mobile Devices
 Windows Server 2012
 SQL Server 2012
Economics and Business
 Business Information Systems
 Human Resources

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: $46.95 (includes GST)

Paperback package 816

34%Off Retail Price

You save: $24.00

This item is available to backorder. Usually ships within 7 - 10 working days

Retail Price: $70.95

Publisher: Pearson Education,22.07.19


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

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