Excel Power Pivot - Introduction to Power Pivot in Excel
Prerequisite: This one-day class is for people who have a good understanding of Excel and want to explore Excel’s latest Business Intelligence tools, those responsible for reporting and analysis and want to save time, and business professionals who need to mine their data using existing resources.
Course Description: Power Pivot is a relatively new Excel tool that provides powerful data analysis, modeling, and visualization tools to help you understand your data. It has the ability to import large amounts of data, create relationships between different data sets, create formulas with Data Analysis Expressions (DAX) language, and create interactive graphics that are shareable.
In this one day introductory class, we will cover: loading data into Power Pivot, introduction to calculated columns, calculated fields (measures), some basic DAX formulas, and how to create relationships between tables.