Catalog

On-Demand Video
On-Demand Video
Content Created:
Product ID:
Link:
Credits awarded per Session. See individual Sessions for further details.
Credits awarded
Type
Name
Sub type
Value

About this item

This course focuses on using the Power Pivot features to enhance data analysis. We will review the 4 features of Power Pivot (data model, calculations, hierarchies and KPI's) and you will learn how you can use each of these features. Although, the majority of the time will be spent on building the data model and using calculations. You will learn how to add data to your data model either directly into Power Pivot or from Power Query. We will discuss the benefits of the data model relationships versus using the VLOOKUP function to access data in different tables. 

Learning Objectives: 

Create a data model using Power Pivot 

Differentiate between calculated columns and measures 

Use Power Pivot for data analysis

Close
Shopping Cart
Total:  Close

Loading Shopping Cart Items...