What You Will Need

To begin working with PowerPivot for Excel, you first need to establish a development environment. Fortunately, the installation of PowerPivot for Excel is self-contained. The primary requirement for using the PowerPivot add-in is having Microsoft Office Excel 2010 installed. A wide spectrum of computers, from commodity desktops to high-end workstations can effectively run both Excel 2010 and the PowerPivot add-in. This makes a compelling argument for PowerPivot for Excel as a tool for business users who are not always on the leading edge of hardware acquisition. One of the most compelling demonstrations for PowerPivot for Excel is executing a sort on a 100-million row dataset deployed on an otherwise off-the-shelf Intel Atom-based ...

Get PowerPivot for Business Intelligence Using Excel and SharePoint now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.