The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)

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 handlingUnderstand evaluation contexts and the CALCULATE and CALCULATETABLE functionsPerform time-based calculations: YTD, MTD, previous year, working days, and moreWork with expanded tables, complex functions, and elaborate DAX expressionsPerform calculations over hierarchies, including parent/child hierarchiesUse DAX to express diverse and unusual relationshipsMeasure DAX query performance with SQL Server Profiler and DAX Studio

From the brand

Microsoft Press is a publishing alliance between Microsoft Corporation and Pearson.

Since 1984, Microsoft Press has helped IT professionals, developers, and home office users advance their technical skills and knowledge with books and learning resources.

What do we publish?

Resources for studying for certifications, new technologies, best practices for developers, and easy-to-follow guides on Microsoft software applications.

Who are the authors?

Leading authorities from Microsoft and other industry innovators write and contribute to the various titles and series that make up the Microsoft Press product family.

Are these books authoritative?

Microsoft reviews each title for accuracy and approves them for inclusion.

Find more from Microsoft Press

Exam Ref

Official Microsoft exam reference focusing on the critical skills and knowledge as measured by Microsoft certification exams.

Step by Step

Step by Step books guide you to build your skills, from fundamentals to specialized tasks.

Developer’s Reference

Core topics and essential techniques for professional developers.

Business Skills

Designed for intermediate to advanced Office and Windows customers and IT professionals who want to optimize their work and advance.

Publisher ‏ : ‎ Microsoft Press; 2nd edition (20 July 2019)
Language ‏ : ‎ English
Paperback ‏ : ‎ 768 pages
ISBN-10 ‏ : ‎ 1509306978
ISBN-13 ‏ : ‎ 978-1509306978
Dimensions ‏ : ‎ 18.75 x 3.86 x 23.11 cm