
Excel Introduction to PowerPivot
Course Objectives
This course is designed for people who need to create Pivot tables based on data sets that have millions of rows and need to use multiple data sources to form the data. PowerPivot allows you to analyse and add data to the model extremely fast and efficient.
Who Should Attend
This course is suitable for any existing Excel user who has to manipulate, analyse and report on massive amounts of data.
Course Syllabus
GETTING STARTED WITH POWERPIVOT
- Introduction to PowerPivot
- Exploring the PowerPivot Tab
- Exploring the PowerPivot window
- Introduction to the PowerPivot Data Model
CONNECTING TO VARIOUS DATA SOURCES
- Creating a data model
- Data Sources supported in PowerPivot
- Import data from existing files such as Excel and Excel
- Import data using Excel Linked Tables
- Import data using Text (txt) files such as Notepad
- Import data using Comma Separated Values (csv)
- Import data using the Paste option
MANIPULATING THE DATA IN THE DATA MODEL
- Add a new column
- Rename the field
- Resize the field
- Assign or change the Data Type
- Moving columns
- Deleting columns
- Sorting Data
- Filtering Data
- Paste data into the model using Paste Append and Paste Replace
MANAGING RELATIONSHIPS IN POWERPIVOT
- Understanding the process of relating tables
- Create and edit links
- View relationship links between the tables
- Create Hierarchies
CREATING A PIVOT TABLE FROM THE POWERPIVOT DATA MODEL
- Create a Pivot table
- Assign fields to the Pivot Table
- Rearrange the fields
- Introduction to slicers to filter the table
- Creating Pivot Charts
OVERVIEW OF DAX FORMULAS FOR POWERPIVOT
- Calculated Columns in the Data Model
- Creating Measures (Calculated fields) in the Pivot table
- Overview of creating KPI’s