Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.