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

Chapter 7. Introducing Online Analytical... > Using OLAP Data to Make Better Busin...

Using OLAP Data to Make Better Business Decisions

If you know the names of the dimensions, levels, and measures in an OLAP cube, you can ask some fairly complex business questions of the data. Using the sample car sales database as an example, you might want to ask business questions such as

  • In which quarter were car sales the greatest when viewed by payment type?

  • Year over year, what was the average standard car type sale in the individual states of the West region as compared to average deluxe car type sales?

  • What was the best day of the month to sell sport utility vehicles for cash in Oregon, and how much income was generated from these sales compared to sport utility sales in Washington ?

  • Month over month, what were the largest and smallest sticker prices for each of the combinations of car series, car types, colors, and payment types for California car buyers?


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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