Work with 100,000,000 rows of data in Excel through PowerPivot
The PowerPivot product (code name Gemini) is available for download. PowerPivot is an add-in to Excel 2010 that allows you to operate in real time with tens of millions of records in Excel tables. In addition, PowerPivot integrates with SQL Server and SharePoint to retrieve and display data. The video presents a small presentation immediately introducing up to date:
PowerPivot has a wonderful official website where you can find a lot of additional information, videos that are available to understand non-technical experts, and remote laboratory work through RDP. ')
If you dig on the Internet, you can find more video materials on the topic with demonstrations of the tool.