Power Pivot is a powerful data analysis tool in Microsoft Excel 2010. This feature enables you to import large amount of data from multiple data sources into one single Excel workbook and create relationships between heterogeneous data. Apart from that, you can also create calculated columns and measures using formulas to further manipulate it for your business objectives. The beauty of building Pivot Table and Pivot Chart is to allow you to analyze the data so that you can make timely and prompt decision.
Upon successful completion of this 1-day course, students should be able to:
Become familiar with the Power Pivot application and import data.
Manipulate data in a Power Pivot worksheet.
Create reports using Power Pivot data.
Use DAX functions in Power Pivot.
Import data from multiple data sources.
Create linked data.
Create relationships between data from different data sources.