This Power Pivot Intermediate course is designed to give users an understanding of the more complex features within Power Pivot including, advanced calculated columns and a detailed look at DAX measures.
It goes beyond reporting with Power Pivot by also including Power Query, used to seamlessly collect data from different sources, clean it, then export to Power Pivot. It also looks at Microsoft Power BI Desktop where you can seamlessly run your reports online.
We will look deeper into relationships to get greater analysis from your data and how to merge disjointed sets of data into unified reports. You will learn how to make certain columns in a Pivot Table behave as if filtered, while other columns in the same table do not (seeing this helps better understand it).
We look at creating time-intelligent calculations such as “Year over Year” and "Year to Date" analysis, and how formulas can be reused across reports of completely different shapes.
Attendees are required to be familiar with the Power Pivot Introduction content before attending this course.