Managing data quality at the lo-cost airline company

Reference no: EM13946246

Mini case study

Managing data quality at the Lo-cost Airline Company

The daily data processing needed for a major international company such as the Lo-cost Airline Company is significant. Each year over 20 million passengers book flights on over 200 routes serving 60 airports. These include both consumer and business bookings. Since its inception, the Lo-cost Airline has created a database of 80 million customer profiles each containing detailed information such as:

¦ Names and addresses
¦ Travel type - business or personal
¦ Inference of travel type - city breaks, stag-nights, packaged holidays, business travel, etc.
¦ Number of tickets in booking
¦ Frequency of routes flown
¦ Booking of related services such as travel packages, car hire and insurance

The company also holds customer communication preferences such as those who opt-in for the company e-newsletter or postal mailings and investor relations.

Customer data is captured through the Website (90% of bookings) or by phone bookings and then fed into an online database known as the ‘Customer Information System' (CIS). The system screens for data quality. On average, 20 per cent of postal addresses are returned as un-mailable and a further 10 per cent are incomplete. Many of the e-mail addresses or postal addresses are incorrectly entered first time. In these cases a manual follow-up by phone is then completed to correct details where appropriate. If these details are not accurate then some of the millions of dol- lars used for direct marketing by post, e-mail and the website are wasted, either due to messages not getting through or the offers not being relevant.

The attention that the Lo-cost Airline attaches to data quality is indicated by these additional measures to improve data quality:

¦ Defined responsibilities for data quality assigned to a customer data manager who is part of a small customer intelligence team
¦ Training courses on data quality are part of all staff inductions
¦ Data quality targets are used for staff in the call-centre
¦ Data quality for customer profiles collected on the Website is reported and continuously improved
¦ Quarterly CRM mini-boards for senior managers
¦ Quarterly data quality steering groups
¦ Reporting of responsiveness of customers to direct mail and e-mail offering promotions with RFM analysis of customers (Recency, Frequency, Monetary value and also category of bookings)
¦ Follow-up procedures for when e-mail addresses or postal addresses become invalid (e-mail bounce-backs).

Reference no: EM13946246

Questions Cloud

Does interface use relationship marketing : Identify the companies that are part of the EnviroSense Consortium. Do you believe that any of these companies are as committed to sustainability as Interface? How so? Does Interface use relationship marketing? What are the pros and cons from an e..

Help understand some of the legal issues : Jim and Laura Buyer visit the local car dealership because they are interested in buying a new car. The car they currently have is aging and is starting to have mechanical problems. Jim and Laura would share the new car, and use it to go back and ..

Calculate the selling price being asked by each business : Calculate the selling price being asked by each business and the purchase price offered by Photographics. Should each business sell out to Sharp Photographics?

Distinguish eugenol from eugenyl acetate : Describe a chemical test that would allow you to distinguish eugenol from eugenyl acetate?

Managing data quality at the lo-cost airline company : Managing data quality at the Lo-cost Airline Company. The daily data processing needed for a major international company such as the Lo-cost Airline Company is significant.

Construct a pivot table to compare custom with the location : Construct a pivot table to compare the Custom with the Location. Place Custom in the rows and Location in the columns and a count of houses in the body of the table.

Accounting system and uses the encumbrance system : integrates the budget into the accounting system and uses the encumbrance system.

Is phone hacking ever acceptable : Is phone hacking ever acceptable? What are the policy issues of the information technology framework that might have prevented this from happening

Heat transfer coefficients for free convection : Estimate average values of the fin heat transfer coefficients for free convection (hc) and radiation exchange (hr). Use these values to predict the tip temperature and fin effectiveness.

User Account

All Pages