Qantas central managements wish to analyze their business performance from many different business units to maximize their revenue. They need to perform detailed analysis of their business to see the...

Qantas central managements wish to analyze their business performance from many different business units to maximize their revenue. They need to perform detailed analysis of their business to see the efficient operations and effective achievement. It has observed that a simple reporting feature built on top of their operational database is not adequate. Therefore, an enterprise data warehouse is required to assist mangers in addressing the aforementioned requirements and queries.


1.    What products are short of supply for any flights at end of trip? Has this always been the case in last three months?
2.    What are top 3 flights have the highest sales across the country in last 12 months?

3.    Identifying the most frequent repairs on components of aircraft through the history of services.

4.    Identifying the hot time period of flights for full seats flies in last 12 months, find out what flights are fully booked three months in advance.

5.    Which age group of customers is most likely using our flight at weekends? Does this vary across different location or times of the year?
6.    Finding the main occupation of those people who purchase the first class ticket in last 12 months.

7.    What particular food in Qantas lounge are the most popular? Any type of drinks in the lounge is less than 2 bottles every day in last months?  Do they share the common feature?
8.    Finding the percentage of first class or business class traveller and percentage of plenum Qantas frequent flyer to see who are using Qantas lounge more in last 3 years.
9.    Does the promotion period in Christmas month have increased the sales comparing with the same period in last year?
10.    Do customers prefer to go online purchases or buy tickets from promotions agent? Do they prefer to pay cash or credit card?