PowerPivot 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 PowerPivot application and import data.
Manipulate data in a PowerPivot worksheet.
Create reports using PowerPivot data.
Use DAX functions in PowerPivot.
Import data from multiple data sources.
Create linked data.
Create relationships between data from different data sources.