This 2-day Instructor Led course How to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. You will also explore how PowerPivot workbooks can be integrated with SharePoint 2010.
Module 1: Overview
A simple introduction module.
Lessons
Lab 1: None
After completing this module, students will be able to:
Module 2: PowerPivot Introduction
In this module we take a look at an introductory view of PowerPivot.
Lessons
Lab 1: Installing PowerPivot
After completing this module, students will be able to:
Module 3: PowerPivot Data Sources
In this module we take a look at all the possible data sources of which PowerPivot can work with!
Lessons
Lab 1: Loading Data Sources
Lab 2: Cleaning Data
Lab 3: Creating Relationships
After completing this module, students will be able to:
Module 4: PowerPivot Functions
In this module we take a look at PowerPivot Functions/DAX Expressions and how to use them!
Lessons
Lab 1: Create a Time Table
Lab 2: Using DATE Functions
Lab 3: Using TIME INTELLIGENCE Functions
Lab 4: Using STATISTICAL Functions
Lab 5: Using FILTER Functions
Lab 6: Using LOGICAL and INFORMATION Functions
Lab 7: Using TEXT Functions
After completing this module, students will be able to:
Module 5: Building Reports using PowerPivot
In this module we take a look at building reports using PowerPivot.
Lessons
Lab 1: Creating Reports
After completing this module, students will be able to:
Module 6: PowerPivot for SharePoint 2010
In this module we take a look at PowerPivot for SharePoint 2010.
Lessons
Lab 1: Installing PowerPivot for SharePoint 2010
Lab 2: Configuring PowerPivot For SharePoint 2010
After completing this module, students will be able to:
Advanced Excel users, users that want to gain familiarity with PowerPivot to build compelling reports.
This 2-day Instructor Led course How to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. You will also explore how PowerPivot workbooks can be integrated with SharePoint 2010.
Module 1: Overview
A simple introduction module.
Lessons
Lab 1: None
After completing this module, students will be able to:
Module 2: PowerPivot Introduction
In this module we take a look at an introductory view of PowerPivot.
Lessons
Lab 1: Installing PowerPivot
After completing this module, students will be able to:
Module 3: PowerPivot Data Sources
In this module we take a look at all the possible data sources of which PowerPivot can work with!
Lessons
Lab 1: Loading Data Sources
Lab 2: Cleaning Data
Lab 3: Creating Relationships
After completing this module, students will be able to:
Module 4: PowerPivot Functions
In this module we take a look at PowerPivot Functions/DAX Expressions and how to use them!
Lessons
Lab 1: Create a Time Table
Lab 2: Using DATE Functions
Lab 3: Using TIME INTELLIGENCE Functions
Lab 4: Using STATISTICAL Functions
Lab 5: Using FILTER Functions
Lab 6: Using LOGICAL and INFORMATION Functions
Lab 7: Using TEXT Functions
After completing this module, students will be able to:
Module 5: Building Reports using PowerPivot
In this module we take a look at building reports using PowerPivot.
Lessons
Lab 1: Creating Reports
After completing this module, students will be able to:
Module 6: PowerPivot for SharePoint 2010
In this module we take a look at PowerPivot for SharePoint 2010.
Lessons
Lab 1: Installing PowerPivot for SharePoint 2010
Lab 2: Configuring PowerPivot For SharePoint 2010
After completing this module, students will be able to:
Advanced Excel users, users that want to gain familiarity with PowerPivot to build compelling reports.