Getting Started with Power Pivot and the Data Model

Overview:

This on-demand course is designed to help the viewer navigate the powerful feature of the Data Model and how it can be managed with the Power Pivot Add-in. It is intended for those who are already familiar with the process of creating and configuring Pivot Tables. The course explores the concept of the Data Model in Excel, and how Power Pivot helps to view and manage the Data Model, as well as some of the new features that are enabled when Pivot Tables are created using the Data Model as a data source. Viewers can practice along with supplied data.

Course Content:

In this course, you will gain knowledge about the following topics:  

• Explore what is the meaning of a Data Model 
• Understand how to enable Power Pivot and work with a Data Model 
• Learn how to construct Data schema and nuances around data relationships 
• Get exposure to using Calendar or Date Tables with your Data Model 
• Construct a Pivot Table using the Data Model as the source and explore some of the new features that are available including how to perform non-symmetric analysis of data 

Learning Objectives:

Upon completing this course, you will be able to:

• Explore the importance of data relationships instead of flat data
• Explore what is the Data Model
• Learn about the Power Pivot Add-in and how to enable it and use it 
• Learn some techniques associated with the Data Model when using Power Pivot to manage it 

Who Will Benefit: 

Those who are proficient in Pivot Tables; need to work with various sources of data; and want to explore how the data model might be able to help and bring in efficiencies by creating a Data Model and Pivot Tables from it.