Work with 100 million rows of data in Excel through PowerPivot

    The PowerPivot product (codename Gemini) is available for download . PowerPivot is an add-on to Excel 2010 that allows you to operate in real time with tens of millions of records in Excel spreadsheets. In addition, PowerPivot integrates with SQL Server and SharePoint to retrieve and display data. The video presents a small presentation immediately introducing the course of things:

    PowerPivot has a wonderful official website where you can find a lot of additional information, videos that are available to non-technical specialists, and remote lab work through RDP.

    If you rummage through the Internet, you can find more video materials on the topic with demonstrations of the tool.

    Official announcement

    Also popular now: