• Explore every aspect of using Microsoft PowerPivot

Module 1: Overview

A simple introduction module.

Lessons

• None

Lab 1: None

• None

After completing this module, students will be able to:

• Understand your course, classroom, classmates, facility and instructor.

Module 2: PowerPivot Introduction

In this module we take a look at an introductory view of PowerPivot.

Lessons

• Excel 2010 Features
• PowerPivot Introduction

Lab 1: Installing PowerPivot

• Install PowerPivot for Excel

After completing this module, students will be able to:

• Install PowerPivot for Excel
• Be able to navigate the PowerPivot windows
• Understand the new features of Excel 2010

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

• Supported Data Sources

Lab 1: Loading Data Sources

• Load Data From SQL Server
• Load Data From Text Files
• Load Data via Copy and Paste
• Load Data via Data Feeds
• Load Data via Reporting Services

Lab 2: Cleaning Data

• Cleaning data in PowerPivot

Lab 3: Creating Relationships

• Create Relationship between Data Sources

After completing this module, students will be able to:

• Import various data sources into PowerPivot
• Understand how to clean imported data

Module 4: PowerPivot Functions

In this module we take a look at PowerPivot Functions/DAX Expressions and how to use them!

Lessons

• PowerPivot Expressions

Lab 1: Create a Time Table

• Create a Time Table for future labs

Lab 2: Using DATE Functions

• Use DATE Function
• Use DATEVALUE Function
• Use the DAY, MONTH, YEAR, HOUR, MINUTE, SECOND Functions
• Use EDATE Function
• Use EOMONTH Function
• Use NOW and TODAY Functions
• Use TIME and TIMEVALUE Functions
• Use WEEKDAY and WEEKNUM Functions

Lab 3: Using TIME INTELLIGENCE Functions

• Use FIRST* and LAST* Functions
• Use DATE* Functions
• Use STARTOF* and ENDOF* Functions
• Use CLOSING* and OPENING* Functions
• Use LASTOF* and FIRST* Functions
• Use PREVIOUS* and NEXT* Functions

Lab 4: Using STATISTICAL Functions

• Use AVERAGE* Functions
• Use COUNT* Functions
• Use MAX* and MIN* Functions

Lab 5: Using FILTER Functions

• Use ALL, ALLEXCEPT and ALLNOBLANKROW
• Use CALCULATE, CALCULATETABLE
• Use DISTINCT and VALUES
• Use EARLIER and EARLIEST
• Use FILTER
• Use RELATED

Lab 6: Using LOGICAL and INFORMATION Functions

• Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)
• Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)

Lab 7: Using TEXT Functions

• Use TEXT Functions

After completing this module, students will be able to:

• Be able to describe all the new PowerPivot Expressions
• Use and apply many of the PowerPivot Expressions

Module 5: Building Reports using PowerPivot

In this module we take a look at building reports using PowerPivot.

Lessons

• PowerPivot Reports

Lab 1: Creating Reports

• Use PivotCharts
• Use Slicers
• Use Sparklines

After completing this module, students will be able to:

• Describe the different Report types in PowerPivot
• Be able to create Slicers and Sparklines for more engaging reports

Module 6: PowerPivot for SharePoint 2010

In this module we take a look at PowerPivot for SharePoint 2010.

Lessons

• Reports and Email
• PowerPivot for SharePoint 2010

Lab 1: Installing PowerPivot for SharePoint 2010

• Install PowerPivot for SharePoint 2010
• Configure PowerPivot for SharePoint

Lab 2: Configuring PowerPivot For SharePoint 2010

• Publish to SharePoint 2010
• Configure PowerPivot for SharePoint 2010

After completing this module, students will be able to:

• Describe the integration points between PowerPivot and SharePoint 2010
• Be able to publish and setup workbook data refresh in SharePoint 2010

Advanced Excel users, users that want to gain familiarity with PowerPivot to build compelling reports.

• General Excel and Report building skills