Reference no: EM1368896
THL is in car renting business in three countries.
Describe a report or OLAP cube that would best enable you to answer the following questions.
a. What is the brand generates the most revenue?
b. Which brand genereates the most revenue for each country?
c. What is the average revenue per day, per brand, for all rental?
d. what is the average revenue per day, per brand for each month for all rentals in each country?
e. which locations (rental offices in cities in countries in which THL is active) generate the most business? Assume a rental office rents just one brand of vehicle.
f. which locations generate the most business per season?
g. Which locations generate the most business per season and year?
h. Examine your answers in a-g and explain the criteria you used in determining whether you needed a report or an OLAP cube?