Excel Business Intelligence: Power Pivot and DAX

Course details

Data Analysis Expressions (DAX) allow Microsoft Excel users to create powerful calculated fields in Power Pivot. In this course—the third and final installment of the Excel Business Intelligence series—experienced Excel trainer Chris Dutton spells out how to use the DAX language and Power Pivot to explore and analyze relational data models. Chris picks up where he left off in the previous installment of the series, demonstrating how to add calculated columns and measures to data models in Excel. He highlights the differences between calculated columns and DAX measures, covers common DAX formulas and functions, and discusses best practices for working with DAX and Power Pivot.

Instructor

  • Click here to view Chris Dutton’s instructor page

    Chris Dutton

    Founder & COO, Maven Analytics

    Chris Dutton is a certified Excel MOS Expert, edtech entrepreneur, and best-selling instructor.

    Chris has spent 10+ years specializing in data visualization and business intelligence. As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft, HuffPost, Entrepreneur.com, and the New York Times, reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics seeks to empower everyday people to change the world with data. Chris graduated summa cum laude and received the Charles G. Bluhdorn Prize in Economics at Tufts University.

Skills covered in this course

Contents