SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010 RTM

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 same performance as processing a few […]

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 same performance as processing a few hundred rows by leveraging 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.

More Info: Download

About The Author

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he's engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.