I would like to share with you a information on Microsoft Excel Add-on (supports only 2010).
PowerPivot is a free add-on for MS Excel 2010
How it is useful?
=> helps in increasing the data analysis capability of Excel
=> Increase the data holding capacity of Excel Sheet so we can store more data in single Excel sheet.
Features:
=> We can import data from Access, SQL Server also from other data base.
=> In Normal Excel pivot allow 1millions rows and data, In PowerPivot allow to use 100 millions of rows.
=> In Normal Excel we can import data only from single data sources whereas In PowerPivot we can import data from diverse
sources and combain these data into single model.
=> Save your data and perform analysis in the familiar Excel Environment and we can copy, move & re-use the data when we needed.
=> share your analysis online where your colleagues can continue to slice and dice your data.
for more details: http://www.powerpivot.com/
Video links: http://www.powerpivot.com/videos.
No comments:
Post a Comment