Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I keep reading how PowerPivot lets Excel process "millions of rows" (!!). I'm already doing this with a regular old pivot table hooked up to a (relational) SQL database. What does PowerPivot do differently?

share|improve this question
    
PowerPivots are like by marketing more, so they got a better name. – music2myear Aug 5 '11 at 14:39

PowerPivot features:

  1. Take advantage of familiar Excel tools and features
  2. Process massive amounts of data in seconds
  3. Load even the largest data sets from virtually any source
  4. Use powerful new analytical capabilities, such as Data Analysis Expressions (DAX)
  5. Make the most of multi-core processors and gigabytes of memory

You can read the datasheet for more info.

In short, it seems that it was built more efficiently, to handle larger data loads, automatically parallelizes across cores, and has more analysis tools.

share|improve this answer
    
Ouch, fixing that now. Thanks for telling me. – soandos Aug 2 '11 at 14:35
    
No problem. . . – Mehper C. Palavuzlar Aug 2 '11 at 14:37

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .