The sale revenues have generated for the targeted flights. • Have the ticket sales under promotion increased during the promotional period? • Which agents have more sales during the promotions? Does...

The sale revenues have generated for the targeted flights. • Have the ticket sales under promotion increased during the promotional period? • Which agents have more sales during the promotions? Does this vary across different months or event types? • What tickets were on promotion but did not sell in full capacity? Managements want to analyse the agent performance and the distributions among agents. 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? 11. Any flights have not been sold out during the promotion period? 12. How many percentages of customers are Qantas frequent flyers among those travellers in last 3 months? 13. Which promotion agent earns the highest commission?