Managing Data Resources
Managing Data Resources
Case: Better data help Virgin Mobile Australia win the customer wars
Virgin mobile Australia is a major player in the Australian mobile industry. It had grown aggressively by pioneering new products and services, including a prepaid service that did not require a contract, free voice mail, and billing all calls by second. Other operators followed suit, leaving Virgin Mobile Australia wondering how it could maintain its competitive lead. The answer lay in making better use of the company’s data.
Senior management wanted a better picture of the Virgin Mobile’s customer base and how well the company was operating. This was no easy task. Virgin Mobile Australia had many different systems, each with different pieces of data that could solve only part of the puzzle. It had an enterprise system, a customer relationship system, and systems for prepaid cell phone service as well as service that was billed to customer each month. The company needed to develop a single enterprise wide view of the data in all of these systems to produce “one version of the truth”.
The company created a data warehouse that reorganized the data from all of these systems in a massive data base to produce the company wide information management required. The data warehouse runs on Oracle 9i database management software and was developed using Oracle 9i Designer to define the systems data model and Oracle 9i Warehouse builder to design the data warehouse.
With the data warehouse, Virgin Mobile Australia can pull data from multiple systems together to obtain an integrated view of its customer and services. Every morning Virgin mobile executives can check indicators such as the number of new connections made the previous day, the demographic profile of new customers, and the handsets they purchased. Management can also find out the performance of each store and point of sales campaign, customer reaction to new products and services, and customer attrition rates.
Case: Better data help Virgin Mobile Australia win the customer wars
Virgin mobile Australia is a major player in the Australian mobile industry. It had grown aggressively by pioneering new products and services, including a prepaid service that did not require a contract, free voice mail, and billing all calls by second. Other operators followed suit, leaving Virgin Mobile Australia wondering how it could maintain its competitive lead. The answer lay in making better use of the company’s data.
Senior management wanted a better picture of the Virgin Mobile’s customer base and how well the company was operating. This was no easy task. Virgin Mobile Australia had many different systems, each with different pieces of data that could solve only part of the puzzle. It had an enterprise system, a customer relationship system, and systems for prepaid cell phone service as well as service that was billed to customer each month. The company needed to develop a single enterprise wide view of the data in all of these systems to produce “one version of the truth”.
The company created a data warehouse that reorganized the data from all of these systems in a massive data base to produce the company wide information management required. The data warehouse runs on Oracle 9i database management software and was developed using Oracle 9i Designer to define the systems data model and Oracle 9i Warehouse builder to design the data warehouse.
With the data warehouse, Virgin Mobile Australia can pull data from multiple systems together to obtain an integrated view of its customer and services. Every morning Virgin mobile executives can check indicators such as the number of new connections made the previous day, the demographic profile of new customers, and the handsets they purchased. Management can also find out the performance of each store and point of sales campaign, customer reaction to new products and services, and customer attrition rates.