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

Benefits of OLAP Cubes

In Chapter 9, “Using External Data Sources for Your Pivot Table,” you learned how to use external data sources to handle datasets larger than 65,536 records. An Access database or SQL server might be able to deliver a few hundred thousand records to an Excel pivot table. What happens if you have a lot more data? Millions, or even billions of records?

Here are two contrasting examples. In a very small bank with just a few branches, you might have only a few thousand customers. You can easily create a dataset that would fit in Excel about those customers' balances and loans. You could then use pivot tables to generate all sorts of interesting aggregations.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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