Pivot tables have always been the key reason why data analysts choose Excel. So in all their awesomeness two key shortages have lingered in the background.
Then in 2009 Power Pivot came around and it was a game changer. All of a sudden the user could create data models with multiple data sources and calculate “time intelligent” calculations and running totals with ease and then include all these calculations in a single(!) pivot table.
So this course is all about Power Pivot and empowering attendees with a workshop style learning process by building a Sales Data Model getting data from multiple sources.
Attendees should have Excel Professional Plus (Pro Plus) 2010 or higher. If they use Excel 2016 Pro Plus or 2013 Pro Plus they need no extra installations, for version 2010 Pro Plus Power Pivot Add-Inn for Excel 2010 will need to be installed.
Data Model
DAX language and creation of calculations (Measures)
Advanced Data Modelling Techniques
Sales Data Model