What have people tweeted recently about VirginMedia

Assignment Help Marketing Research
Reference no: EM132292691 , Length: word count:1100

Assignment - Group report: Understanding Virgin Media customer churn

Sir Richard Branson has just welcomed you into his spasious office at Virigin Media headquarters in London. Quite concerned with many of his customers switching to competitors he said: „Recently we have found out that many customers have left us for our competitors. My business intelligence department is abroad on a team-building event and until they come back I am concerned that more customers will leave. This situation requires immediate, insight-driven actions that will stop and hopefully reverse customer churn. Therefore, I have a couple of analytical tasks that I need solved in the best of your capacity. Once you create insight, I expect that you come up with a set of strategic and tactical recommendations on how to act to prevent or possibly reverse customer churn.

Task 1: Identify who of our current customers is next to leave Virgin Media. You are provided with two files (database extracts). The first one VirginMediaChurn_Jan2018.csv includes information about:

  • Customers who left Virgin Media in January 2018 - the column is called Churn
  • Services and extras that each customer has signed up for - Landline, MultipleLines, Broadband, Powerline Kit, Online Backup, Gadget Rescue, Cable TV and Video On Demand
  • Customer account information - how long they have been a customer (tenure), contract type, payment method, paperless billing, monthly charges, and total charges
  • Demographic info about customers - gender, employment and marital status and if they have any dependents

The second file is VirginMedia_Feb2018.csv includes everything listed above except Churn. Building on the knowledge obtained from the first file, try to predict who of our current customers is likely to leave. To build prediction model, choose the best prediction technique, explain which variables are most important to predicting churn and establish who will churn. Provide a detailed explanation of your analytical approach - i.e. workflow model and its elements. Explain step by sep what was done to get the best possible predictions. Provide detailed overview of the outputs and elaborate your findings. Provide links to your workflows and files (be explicit in which file you have saved predicted churners). Do not forget that my DBI team is very picky so make sure you do a rock solid modelling and analysis.

Task 2: Once you have established who is likely to churn, check if different types of churners exist. If so, establish how many segments there are, profile identified segments using available data and give appropriate names to the segments. Same like in the previous task, elaborate your approch and your findings. Provide link to your workflow model and files (be explicit in which file you have saved your classification results).

Task 3: I also want to know WHY our customer leave. Unfortunately, we cannot see this in our databases and we have no time to commission market research. Instead, I would like you to see what have people tweeted recently about VirginMedia. This might signpost to the potential churn causes. I would like to see key themes and sentiment of the tweet corpus mentioning our business name. Anything above this minimum requirement would be a big plus. Same like in the previous tasks, elaborate your approch and your findings. Provide links to your workflow models and files.

Once you have solved all the tasks, you need to provide recommendations on what actions VirginMedia should take to prevent and potentionally reverse churn. While you have creative freedom, your recommendations have to be linked with the insight you have created and other external research. Please note that there will be two audiences reading this report. First audience is made of myself and my board of directors. Given that we are extremely busy we do not like technical and leghty reports that require hours of reading. Instead we prefer intuitive infographs, with very little text that can be easily understood. We are willing to read up to 3 infographic slides. Please put these in the executive summary so that we do not have to struggle finding them in your report. The second audience is my DBI team. They will be interested to throroughly read and inspect your analytical approach and findings. Therefore, be elaborate and precise and provide links for my team to inspect your model workflows, working files and outputs. Justify your decisions in building models and demonstrate that you know how different widgets/tools function. And once again, bear in mind you do all of these analyses to help us stop the churn. Good luck!"

Note - REQUIRED TO BE COMPLETED is TASK 3 ONLY.

Attachment:- Assignment File.rar

Reference no: EM132292691

Questions Cloud

How do ethical issues affect decision making : How do ethical issues affect decision making and what ethical issues do you see in the decision about whether to pay college athletes for their time and work?
What is the connection between a company''s strategy : What is the connection between a company's strategy and its quest for sustainable competitive advantage?
Discuss how the organization keeps its members informed : Discuss how the organization keeps its members informed of health care changes and changes to practice that affect the specialty area.
What are the five forces of competition model : What are the five forces of competition model? How they can be used to explain how above-average returns can be earned through each business-level strategy?
What have people tweeted recently about VirginMedia : Assignment - Group report: Understanding Virgin Media customer churn. what have people tweeted recently about VirginMedia
Successfully implementing an international strategy : Identify three basic benefits Starbucks achieved by successfully implementing an international strategy.
Research and define and discuss social responsibility : Research, define and discuss social responsibility, what it means, and its role in business.
Determining what is not known in the evidence : A literature review analyzes how current research supports the PICOT, as well as identifies what is known and what is not known in the evidence. Students will.
Explain the difference in negotiation strategies : Explain the difference in negotiation strategies according to Weiss if a negotiator has a low level of familiarity with a culture as opposed to a high level of

Reviews

len2292691

4/24/2019 11:34:58 PM

Word Count -1100. Instructions: Attaching the assignment tasks re Virgin Media. He answers I have attached - just in case the writer needs to refer to them (file Assignment 2 Virgin Media.docx) What is REQUIRED TO BE COMPLETED is TASK 3 ONLY. Please, can the work be completed within the tight turnaround period, with the work to have a low similarity index and well referenced? The writer may use the solution to Task 1 if required.

len2292691

4/24/2019 11:34:53 PM

Once you have solved all the tasks, you need to provide recommendations on what actions VirginMedia should take to prevent and potentionally reverse churn. While you have creative freedom, your recommendations have to be linked with the insight you have created and other external research. Please note that there will be two audiences reading this report.

len2292691

4/24/2019 11:34:25 PM

Further instructions and expectation - All analyses must be performed in Orange Data Mining software. If necessary install add-ons that will assisst you in completeing your tasks. In explaining your analytical approach you are allowed to insert workflow screenshots. It is vital that your data mining models are well annotated and made available for your tutors to download. Therefore, save all your workflows and data files in cloud (Dropbox, Google drive etc.) and provide links to each task's solution so that your tutors can inspect it when marking.

len2292691

4/24/2019 11:34:17 PM

When making infographics you can use any software you want. Please note, you are not allowed to write to or call Virgin Media or Sir Richard Branson in any way or form. Please note, producing digital business intelligence report is a very demanding task. Start working on it as soon as possible and make sure that you do not delegate tasks back to the client.

len2292691

4/24/2019 11:34:12 PM

For each task please provide a link to your workflows and working files. These can be stored on Dropbox, Google drive or any other cloud based drive/location. Once your report is submitted you are not allowed to alter your workflows and files. Dates on files will be checked. Screenshots of your workflows and your actual workflows must not differ. Otherwise your tasks will not be marked at all.

Write a Review

Marketing Research Questions & Answers

  A business plan: gift shop

A business plan for a gift shop contains so many constraints and aspects to be taken into consideration before start up with something.

  Managerial decision making

This assignment is based on Managerial Decision Making. Compare and contrast the theoretical and practical differences between "formal research" and "business proposals".

  London congestion charge

Generate revenue for city are under consideration. The two proposals are London Congestion Charge and Charging for Firefighting.

  Market research

The director of market research at a large department store chain wanted to prepare a survey throughout a metropolitan area to calculate the amount of time working women spend shopping for clothing in a typical month.

  Producing quality steel by stressing sound management

Nucor Corporation- Producing Quality Steel by Stressing Sound Management Practices

  Monitor and review the performance of members of a team

Monitor and review the performance of members of a team.

  Scientific research and informal research

Differences between scientific research and some informal research

  Dilmah ceylon tea: market development in australia

Dilmah Ceylon Tea: Market Development in Australia.

  Quantitative analysis based on a excessive research

Zara is part of a multi-national conglomerate and it is operating in many countries worldwide. There are a total number of 1770 Zara stores world wide in regions of Africa, Asia, Central America and The Caribbean, Europe, North America, and South Ame..

  Market research report

Market Research Report

  Designing a lunchbox menu for children

Marketing Plan- Designing a lunchbox menu for Children

  Case study:moet hennessy louis vuitton

Case study:Moet Hennessy Louis Vuitton

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd