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.