Question

For an airlines company, identify three operational applications that would feed into the data warehouse. What would be the data load and refresh cycles for each? data warehousing

Answer 1

For an airlines company, three operational applications that need to be fed into the data warehouse are:

• Pricing system Integration: This data helps in generating insights related to price points that work on different routes and elasticity of demand in relation to price. The data load and refresh cycles need to be near real-time. Seat pricing is dynamic.
• CRM system Integration: This holds the data of customers that fly with the airline's company. An example of usage of this data could be - Regular buyers can be targeted with promotions to ensure their retention with airline's and non-regular flyers can be given an incentive to fly with airlines. The data load can be weekly and refresh cycle can be done bi-weekly. Latest customer data may be required for planning promotions.
• Operations system including performance measurement systems integration: This includes data related to flight times, %age booked flight (seats booked), on-time flights vs delayed flights, reasons of flight delay and operational performance. The data is required on a daily basis to observe the issues that are causing operational losses and take necessary actions to rectify problems.