• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Leveraging the Power of OLAP... > Comparing OLAP Cubes' Pivot Tables t...

Comparing OLAP Cubes' Pivot Tables to Excel Data

You've seen the basic idea of what an OLAP cube is. You've also seen that connecting to a cube is fairly simple, and that using one is very much like using pivot tables to work with raw data in an Excel worksheet. So what are the differences between using pivot tables on Excel-stored data and using pivot tables on OLAP data?

OLAP Handles More Data, Faster

The biggest difference is in the amount of data an OLAP cube can handle. As mentioned earlier, in a typical data warehouse there will be millions and more likely billions of records. Organizing aggregations of all that data into a usable structure is beyond even the amazing capabilities of Excel.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint