Course Objective: In this course, students will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.

Prerequisites: To ensure your success, we recommend that you first take Excel Level 1, Level 2, and Excel PivotTables, or have equivalent knowledge and skills - such as a strong understanding of PivotTable, PivotCharts, Tables and the use of intermediate to advanced Excel functions.

Contact us to discuss if this class is right for you.

Lesson 1: Get Started with PowerPivot

• Explore the PowerPivot Application
• Import Data from Various Data Sources like Excel, Access or a Text file
• Refresh Data from a Data Source
• Create Refreshable Tables

Lesson 2: Manipulate PowerPivot Data

• Organize and Format Tables
• Create Calculated Columns
• Sort and Filter PowerPivot Data
• Work with Table Relationships and the Data Model

Lesson 3: Create PowerPivot Reports

• Create PivotTables from PowerPivot
• Create PivotCharts from PowerPivot
• Filter Data Using Slicers
• Present PivotTable Data Visually

Lesson 4: Introduction to DAX Measures in PowerPivot

• Differences between Calculated Columns and DAX Measures
• Create and Manage Measures
• Learn DAX Functions COUNT, COUNTA, DISTINCTCOUNT and CALCULATE
• Manipulate PowerPivot Data Using DAX Measures

Lesson 5: Perform Date and Time Sensitive Calculation in PowerPivot

• Create a Date Table
• Work with Time Dependent Data
• Handle Fiscal and Calendar Periods
• Use Time Intelligence Functions DATESYTD, DATESQTD, DATESMTD and DATEADD

Lesson 6: Distributing PowerPivot Data

• Load Data Model to Power BI
• Load Excel File to Power BI