<div usercontent"="" style="margin: 0px; padding: 4px; : Verdana, Arial, Helvetica, sans-serif; : x-small; line-height: 1.5em; background-color: rgb(255, 255, 255);"><div sercontent="">This comprehensive and authoritative guide will teach students the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help students master everything from table functions through advanced code and model optimization. They&#39;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&rsquo;s remarkable power and flexibility, this no-compromise &ldquo;deep dive&rdquo; is exactly what you need.<br>&nbsp;<br><b>Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI</b><br><ul><li>Master core DAX concepts, including calculated columns, measures, and error handling</li><li>Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions</li><li>Perform time-based calculations: YTD, MTD, previous year, working days, and more</li><li>Work with expanded tables, complex functions, and elaborate DAX expressions</li><li>Perform calculations over hierarchies, including parent/child hierarchies</li><li>Use DAX to express diverse and unusual relationships</li><li>Measure DAX query performance with SQL Server Profiler and DAX Studio</li></ul></div></div>   

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

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

Marco Russo

Alberto Ferrari

Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel

A digital version of the text you can personalize and read online or offline.

eTextbook

This product is a bound, printed text book.

Print

Paperback

For School

For College & University

For Work

Explore Pearson

College

Uni Students

Uni Educators

Uni Store

BTEC qualifications & short courses

Higher Nationals & Higher Technical qualifications

Apprenticeships

T Levels

Functional Skills

GCSEs

A Levels

Educator Resources & Training

For Educators

Learners - 16-18 years

Learners - 19+ years

All Learner Resources

For Learners & Parents

HE Contact for Students​

HE Contact for Educators​

HE Contact for Businesses​

HE Training for Digital Platforms​

FE Support for Colleges

Get Support

Events

BTEC Educator Blog

VQ Bulletin Blog

Learn & Connect

Browse and buy

Study Tools & Apps

Pearson eTextbook

Free Wellbeing Resource

Careers

Shop for University

Mastering

MyLab

Revel

Redeem an Access Code

HE Contact for Students

Help for University Students

Insights and Events

Student Research Community

Sign Up For Offers

Business Book Club

Blog

Webinars

All Educator Resources

Pearson eTextbooks

Find Teaching Resources

Digital Learning Platforms

Print & eTextbooks

Online Learning Units

Simulations

MyVirtuals

Beyond Labz

Featured products

Business disciplines

STEM disciplines

Law (UK)

Psychology

Explore Discipline Resources

Help for University Educators​

Support for Bookstores & Businesses​

Digital Platforms​ Training & Support

Find my Rep

 Higher Education Blog

News & Policy

Arts

Business & Economics 

Careers & Trades

Communication

Computer Science & IT

Engineering

English

Health

Helping Professions

Humanities

Languages

Mathematics

Nursing

Personal & Professional Development

Science

Social Sciences

Statistics

Teacher Education

Higher Education Subject Catalogue

Help for HE Students

Help for HE Educators

HE Help for Businesses

Help for FE Colleges

Support

Teach

Products & Services

Learn

Educators

Parents & Learners

Professional Development

 Pearson TQ - Custom Training

Workforce Skills Solutions

Learners

Learn & Connect 

For Learning Providers

For Employers

For Employees

Qualifications Support​

Resources Support​

Contact Us​

All School Support

All Work Support

Schools Support

College & University Support

Work Support

Global Rights Licensing

Global Permissions

definitive-guide-to-dax-the-business-intelligence-for-microsoft-power-bi-sql-server-analysis-services-and-excel

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