Preview

Managing Data Resources

Powerful Essays
Open Document
Open Document
1839 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
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.

You May Also Find These Documents Helpful

  • Powerful Essays

    MIS 563 COURSE PROJECT

    • 2795 Words
    • 12 Pages

    This finding has ABC University seeking a streamlined way to manage their data and for users to access the data that is clean. With this, the University has proposed the creation and implementation of a data warehouse to house all the data from each one of these operational databases into one central location where all students, staff and faculty can access the data using a self service tool such as a report or a data connection to Microsoft Excel to pull data into pivot tables.…

    • 2795 Words
    • 12 Pages
    Powerful Essays
  • Satisfactory Essays

    This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    VIRGIN MOBILE USA – ‘FIRST PRICE’ STRATEGY (An analysis of the Pricing Decision alternatives that Virgin has to undertake to create an alternate customer segment and monetize their buying power)VIRGIN XTRAS – OVERVIEWThe Virgin Mobile USA service involved content, features and entertainment, called “Virgin Xtras”.Collaboration with MTV networks as it was the most recognized youth brands in the country and unparalleled reach forthe under-30 market segment: Exclusive, multiyear content and marketing agreement. MTV network to deliver music, games and other MTV-, VH1-, and Nickelodeon based content to Virgin Mobile subscribers. Subscribers would have access to MTV- branded accessories and phones, graphics, ring tones, text alerts and voice mails. Promotional airtime on MTV’s channels and website. Virgin mobile subscribers to vote for their favorite videos on a few MTV shows.Other Virgin Mobile services that aimed to appeal to the youth market, generate additional usage and create loyaltywere: Text Messaging Online Real- Time Billing Rescue Ring Wake- Up Call Ring Tones Fun Clips The Hit List Music Messenger MoviesTraditional Channel Virgin’s ChannelServices sold at own proprietary retail outlets, kiosks in Services sold where youth shop especially consumermalls, high-end electronic stores, speciality stores etc. electronic goods in stores like Target, Sam Goody music stores, Best Buy.High-touch sales people who were paid high sales Products packaged in consumer electronics packaging, placedcommission to ensure hands-on service. on a bright red clamshell, which gave it visibility and no salesperson was required.Cost per handset from Nokia, Motorola, Samsung etc. - Cost per handset from Kyocera- $60-$100. Lesser subsidy$150-$300. Entailed substantial subsidy from the entailed by the company.handset makers, a component of acquisition cost.Distributors’ industry avg. Commission- $100/phone Distributors commission- $30/phone.The…

    • 3044 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    Demand for fixed line telephony is in decline, with the rate of decline in lines used by business nearly twice as high as that in the residential fixed telephony market. There is a trend for businesses to replace fixed line telephony with voice-over-internet-protocol, or VoIP, telephony, while residential customers are tending to migrate from fixed line to mobile telephony. However, Virgin Media’s fixed line customers may not migrate to the company’s mobile phones and it may eventually lose its fixed line customers to other providers of mobile telephone services. Such a migration could have a material adverse effect on Virgin Media’s ARPU, results of operations and financial condition. Across the industry, the landline subscriptions have been declining. According to industry estimates, landline subscriptions in the UK fell by over one million in 2010, with the business market hit hardest with a 5% drop. Ongoing negative trends in the fixed telephony market will negatively impact the company’s revenues.…

    • 1114 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Bis Midterm Sheet

    • 1467 Words
    • 6 Pages

    A data warehouse is to extract and clean data from operational systems and other sources to store and catalog that data for processing by BI tools. Data warehouses can include external data purchased from outside sources. Meta data is kept in the data warehouse. Physically, a data warehouse consists of a few fast computers with very large storage devices.…

    • 1467 Words
    • 6 Pages
    Good Essays
  • Better Essays

    Santa Cruz Beach Boardwalk, the best beach in the world with food, roller coasters, and an extraordinary view of an ocean. Everywhere smelling either like fish or funnel cakes. Screaming and yelling with full of joy going down a steep hill on a rollercoaster. Saltwater waves crashing into the golden, rocky sand. People everywhere chilling in their colorful tents with barbecue cooking with a slight burning smell. Laughing and smiling with friends and families in all directions.…

    • 723 Words
    • 3 Pages
    Better Essays
  • Good Essays

    Virgin Mobile - Case Study

    • 1052 Words
    • 5 Pages

    Despite a mature US market, the cellular service industry has a market penetration of only about 15% in the segment comprising of users aged between 15 and 19 years. This segment is characterized by inconsistent cell phone usage, low credit ratings and usage pattern different from the typical businessperson. Hence, Virgin Mobile USA is looking to penetrate this segment and create brand loyalty through attractive pricing and additional feature in mobile entertainment. Based on our analysis, we recommend the following:…

    • 1052 Words
    • 5 Pages
    Good Essays
  • Good Essays

    In offering these combined services, the company has substantial economies of scale as it is able to combine many of its generic roles such as administration and finance, thus allowing the company to price more competitively for the benefit of its customers. Due to its perceived leading brand name in the media, Virgin Media has managed to secure an ongoing contract with Sky, extending further still its inclusive offering to its customers. Technical ability and infrastructure are also two of the key internal strengths of the company, which have been exploited to produce a market leading position.…

    • 515 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Virgin Mobile has strategically shaped its marketing mix to appropriately target the younger demographic. First, lets look at it’s the product element. The younger demographic is more open to new things like text messaging, downloading information from their phones, ring tones, faceplates, graphics, having access to popular entertainment on their phone, etc. For younger people, phones are less of a tool and more of a fashion accessory or personal statement. To appeal to these needs, Virgin Mobile created “VirginXtras,” which involve the delivery of popular content, features, and entertainment. They signed an exclusive, multi-year content and marketing agreement with MTV networks to deliver music, games, and other such content to Virgin Mobile subscribers. Consumers have access to branded accessories and phones, graphics, ring tones, text alerts, and voice mail. In addition to the MTV-branded content, Virgin Mobile also included the following VirginXtras: text messaging, online real-time billion, rescue ring (a prearranged “escape” call such as to avoid a bad date), wake up calls, fun audio clips, a hit list of top 10 songs in which subscribers can listen to and vote for, a music messenger that allows subscribers to shoot a message to their friends so that they listen to a song, and a movie application that provides descriptions, show times, and ticket purchases in advance. All of these features appeal to the youth market, and generate additional usage and loyalty.…

    • 783 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Virgin Atlantic

    • 2159 Words
    • 9 Pages

    Problem Statement Virgin will enter the US mobile market in July 2002 and needs to define a pricing strategy that would attract and retain one million subscribers by the end of year one and three million subscribers by the end of year four without triggering off competitive reactions. Situation Analysis Virgin is one of the most recognized brands in the UK with over 200 brand extensions that stand for fun, honesty and value for money. Despite a recent failure in Singapore, the company wanted to enter the US mobile market in 2001, which had six national carriers and several regional and affiliate providers1. This was considered a mature market with a penetration rate of 50% and a total of 130 million subscribers. However, a specific customer segment aged 15 to 29 had a lower penetration2 rate of approximately 15% and had the highest projected growth. Other companies decided not to target this specific market because the consumers had a poor credit quality. Additionally, since the average customer acquisition cost was $370 and their consumption was low when compared to business users, they were not seen as a business opportunity. Contrary to other companies, Virgin concluded that this underserved segment was indeed a good opportunity. The calling patterns of the youth segment were significantly different from the business users and followed new trends such as text messaging, ringtones and wake-up call among others3. Rather than a device, a mobile phone represented a fashion accessory and a personal statement to them. To develop a value proposition for this niche market, Virgin signed a multiyear agreement with MTV to include music, games and new mobile content. They called these services “VirginXtras” and they believed that these new features would increase brand loyalty and usage. Regarding Virgin’s initial costs, the company would be charged on an as-used basis for the lease of Sprint’s network space, creating a flexible cost structure without the need of huge…

    • 2159 Words
    • 9 Pages
    Powerful Essays
  • Better Essays

    Critically analyse and evaluate the macro environment in which Virgin Mobile (VM) operates. What do you believe to be the key drivers affecting the mobile segment in the UK?…

    • 813 Words
    • 3 Pages
    Better Essays
  • Powerful Essays

    Aventura

    • 1125 Words
    • 5 Pages

    The lack of customer information is due to inadequate information management processes and systems. Port Aventura does not currently have the infrastructure needed to properly collect and manage large amounts of customer data or the ability to strategically analyze that...…

    • 1125 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Virgin Mobile and Market

    • 888 Words
    • 4 Pages

    In terms of the risk associated with this TM, we concluded that virgin is very ‘gutsy’ with their move. Not only that they are narrowing their potential market, but are risking the virgin image in the U.S. For example, individuals who find the whole ‘VirginXtras’ as a gimmick rather than a value proposition, or even associating Virgin branding with teenage characteristics; unreliable, unpredictable, experimental. In addition, due to the nature of teenagers being ‘tech-savvy’ and ‘easily bored’ increases the level of risks associated with this market. Not only that is costly for virgin to retain their customer (further more with handset subsidies), these segment possesses a great chance of trialling other services or even moving from one provider to another.…

    • 888 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Virgin, a leading branded venture capital organization, is one of the world’s most recognized and respected brands. Conceived in 1970 by Sir Richard Branson, the virgin group has gone on to grow very successful businesses in sectors ranging from mobile telephony, to transportation ,travel,financial services,leisure,music,holidays,publishing and retailing. Virgin has created more than 200 branded companies worldwide employing approximately 50000 people in 29 countries.Mumbai,on Sunday,Sir Richard Branson launched the virgin mobile brand in India through franchisee agreement in Tata Teleservices.TTSL which is the second largest CDMA operator with 22 million customers,will sell the youth based mobile service under the brand name of virgin mobile.…

    • 860 Words
    • 4 Pages
    Satisfactory Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    In the 1990s, as businesses grew more complex, corporation spread globally, and competition became fiercer, business executives became desperate for information to stay competitive and improve the bottom line. Data warehousing technologies have been successfully deployed in many industries: manufacturing (for order shipment and customer support), retail (for user profiling and inventory management), financial services (for claims analysis, risk analysis, credit card analysis, and fraud detection), transportation (for fleet management), telecommunications (for call analysis and fraud detection), utilities (for power usage analysis), and healthcare (for outcomes analysis). This paper presents a roadmap of data warehousing technologies, focusing on the special requirements that data warehouses place on database management systems (DBMSs).…

    • 2507 Words
    • 11 Pages
    Best Essays