Overview:
In this course, see how Power Pivot and PivotTables work together. The first part demonstrates how Power Pivot can import a massive amount of data and then perform complex calculations on it. The second part explores different PivotTable commands to summarize and analye the data coming out of Power Pivot.
Areas Covered in the Session:
- Use Power Pivot to import a massive amount of data
- Perform complex calculations within Power Pivot (DAX, Measures)
- Output results from Power Pivot into PivotTables
- Explore different PivotTable commands like slicers and timelines
- Insert calculated fields and items
- Build PivotCharts
Who Will Benefit:
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals