PowerPivot in Excel 2010: Millions of rows! (Insert Dr. Evil laugh here….)

 

PowerPivot for Excel is an Excel 2010 add-in that allows users to pull data from multiple sources, mash them up, and then build reports using regular pivot tables. You can even share these reports with others in Microsoft SharePoint (via PowerPivot for SharePoint). In this demo, Julie Strauss, Program Manager for Microsoft SQL Server Analysis Services, shows just how easy it is to get a better view into your data. Watch for the part where she sorts 100 million rows of data instantly. 100 million rows. Not a typo. You can download the PowerPivot add-in at the Microsoft Download Center. More info at powerpivot.com.