Logo - Skillwave Training

DAX Formulas for Power Pivot

Author: Ken Puls

This is the video portion of the “DAX Formulas for Power Pivot” seminar with Ken Puls. Understanding DAX formulas is what takes your Power Pivot to the next level. This course is intended to help you up your DAX game so that you can make your PivotTables show the exact aggregations you need.

Duration:
7 hours 30 minutes
Tools:
  • Excel
Skills:
  • DAX Formulas
  • Dimensional Modeling

What you'll learn?

  • Review of dimensional modelling terms and techniques and recommended practices
  • Building basic DAX measures from scratch
  • Understanding “Filter Context” and how it applies to formula calculation
  • Debugging a measure
  • Using CALCULATE() and ALL() to truly master your filter context
  • Advanced conditional logic patterns
  • Using iterator functions like SUMX() and AVERAGE()
  • Advanced time intelligence patterns
Course
Course Icon - DAX Formulas for Power Pivot

DAX Formulas for Power Pivot

$249
  • 7 hours 30 minutes of training content
  • 8 modules
  • Downloadable files and Handouts
  • Certificate of Completion

DAX Formulas for Power Pivot

$249

Course Description

While a well-related model is a core part of making Power Pivot sing, understanding DAX formulas is what really takes your Power Pivot to the next level. This course is intended to help you up your DAX game so that you can make your PivotTables show the exact aggregations you need. From creating simple measures to controlling % of grand totals which don’t lose their context upon filtering, to advanced patterns to control date period intelligence, we’ll cover it here.

If you’ve grown into Power Pivot but haven’t spent time studying DAX to any level of depth, this course is for you. After this course, you’ll be comfortable rolling your own custom measures to make your projects report EXACTLY the way you want.

Who this course is for?

  • Accountants and data professionals who are responsible for building business intelligence reports.
  • Registrants must have experience using PivotTables and Power Pivot.

Course Formats

On-Demand
This is an on-demand course, delivered via pre-recorded video modules that you can consume at your own pace. It includes all required sample files, practice sets, and handouts.

Course Content

Expand All

About the author

Ken Puls

Ken Puls

Microsoft MVP, FCPA, FCMA
Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.

FAQs

How do I access the course materials? Are they downloadable?

The videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for each lesson are downloadable.

Where are the course videos hosted?

All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.

How do I receive my Certificate of Completion?

After all the modules and lessons have been completed, you will be able to download the Certificate of Completion from the My Courses area of your Account Dashboard

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.