About This Course
PivotTables and PivotCharts are some of the Excel's most powerful features for analyzing data. This course takes PivotTables to the next level, teaching you how to use Power Pivot: a free add-in available only strating from Microsoft Excel 2010. Power Pivot links in with PivotTables, however the data used, can be manipulated and managed as though you were using a Relational Database (such as SQL or Access).
Learning Objectives
By the end of the course, learner will be able to:
- become familiar with the Power Pivot application and import data
- manipulate data in a Power Pivot worksheet
- create reports using Power Pivot data
- use DAX functions in Power Pivot
- distribute Power Pivot Data
Prerequisites
Before attending this course, learners need to be able to:
- good knowledge of Microsoft Excel
- basic knowledge of Database Relationships (preferable but not unnecessary)
- good knowledge of Excel formula/function to manipulate data
- understand the features of PivotTables, such as the areas designed for fields
Target Audience
This course is designed for advanced Microsoft Excel users who may work or be interested in the domains of finance, statistics, project analysis, market analysis or general data manipulation. They will have a need to create PivotTables on a regular basis and to produce reports with multiple PivotTables/PivotCharts to produce 'Business Intelligent' type dashboard reports.
Training Outline
- Introduction to Power Pivot
- Add Data to Power Pivot Workbook
- Create Relationships Between Tables
- Calculated Column
- Hierarchies in Power Pivot
- Create a PivotTable from Power Pivot Data
- Create a PivotChart from Power Pivot Data
- Measures in Power Pivot
- KPIs in Power Pivot
- Perspectives in Power Pivot (for Excel 2010 only; for Excel 2013/2016, SharePoint 2013 with Excel Services is needed to be implemented)
- Overview of Data Analysis Expressions (DAX)