Course Description
Course Objective: You will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.
Upon successful completion of this course, students will be able to:
- become familiar with the PowerPivot application and import data.
manipulate data in a PowerPivot worksheet.
create reports using PowerPivot data.
use DAX functions in PowerPivot.
distribute PowerPivot Data.
Agenda
Lesson 1: Getting Started with PowerPivotTopic 1A: Explore the PowerPivot Application
Topic 1B: Import Data from Various Data Sources
Topic 1C: Refresh Data from a Data Source
Topic 1D: Create LinkedTables
Lesson 2: Manipulating PowerPivot DataTopic 2A: Organize and Format Tables
Topic 2B: Create Calculated Columns
Topic 2C: Sort and Filter PowerPivot Data
Topic 2D: Create and Manage Table Relationships
Lesson 3: Creating PowerPivot ReportsTopic 3A: Create a PivotTable
Topic 3B: Create PivotCharts
Topic 3C: Filter Data Using Slicers
Topic 3D: Present PivotTable Data Visually
Lesson 4: Using DAX Functions in PowerPivotTopic 4A: Manipulate PowerPivot Data Using DAX Functions
Topic 4B: Extract Data from Tables Using Functions
Topic 4C: Work with Time Dependent Data
Lesson 5: Distributing PowerPivot DataTopic 5A: Protect Reports
Topic 5B: Save Reports in Different File Formats