With PowerPivot, Microsoft brings the dynamism of Business Intelligence tools to Excel, transforming enormous number of data/records into meaningful information. It is a Big Data tool that helps to generate rich and interactive analytics solutions.

 

Who Should Attend
This course is relevant to data analysts, business analysts, financial analysts and anyone who wants to better manage their data. Knowledge and experience in using Excel PivotTable is assumed. Participants are required to have the Microsoft Excel version 2010 and above.
 
COURSE OUTLINE
Module 1: Introduction to PowerPivot
Module 2: Getting Data into PowerPivot
Module 3: Table Relationships
Module 4: PowerPivot Windows
Module 5: Calculated Column
Module 6: PivotTables
Module 7: PowerPivot and Dashboards
Module 8: Create simple Data Analysis Expression (DAX) and Key Performance Indicators (KPI)
Module 9: Create a Hierarchy in a Table
Module 10: Create and Manage Data with Perspectives
 
*For more information, please click and refer to the brochure.