September 17, 2010

PowerPivot for Microsoft Excel 2010 – RTM (SQL Server 2008 R2)




Microsoft recently released the RTM of Microsoft SQL Server 2008 R2 - PowerPivot for Microsoft Excel 2010.

SQL Server BI users will know that Microsoft PowerPivot for Microsoft Excel 2010 is a data analysis tool that can transform mass quantities of Excel data into meaningful information, with incredible speed.

As quoted in the official download page “Microsoft PowerPivot for Microsoft Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft SharePoint 2010”

You can:

  • Process large data sets (often millions of rows) with about the same performance as processing a few hundred rows by leveraging the PowerPivot in-memory engine and its efficient compression algorithms.
  • Integrate data from a multitude of sources, including corporate databases, spreadsheets, reports, text files, and Internet data feeds.
  • Go beyond standard Excel expressions and use PowerPivot’s Data Analysis Expressions (DAX) language to perform powerful data manipulations. Follow relationships between tables as in a database and define sophisticated calculations using familiar and intuitive expressions.
  • Interactively explore, analyze, and create reports without depending on expert knowledge and specialty training by using native Excel 2010 functionality such as PivotTables, slicers, and other familiar analysis features.

Download Link - PowerPivot for Microsoft Excel 2010


Did you like this post?
kick it on DotNetKicks.com
subscribe via rss subscribe via e-mail
print this post follow me on twitter


About The Author

Suprotim Agarwal, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal

 
  Feedback:

comments

0 Responses to "PowerPivot for Microsoft Excel 2010 – RTM (SQL Server 2008 R2)"
 

Copyright © 2009-2014 All Rights Reserved for SQLServerCurry.com by Suprotim Agarwal | Terms and Conditions