[SOLVED] Data Case Analysis C/C

Data Case Analysis (20pts, word limit 8 pages, 12-point font with 1.5 spacing, including all components such as figures, graphs and tables)

Overview

The objective of data case analysis is threefold. One is to provide you with an opportunity to demonstrate your ability to draw marketing insights by using real world data involving real business challenges. The second is to evaluate your ability to conduct critical marketing research including the entire processes of marketing research such as data preparation, data analysis, and communication and presentation of the key findings. Note that we do not expect any advanced statistical tests for this data case analysis. Remember that you should be professional by achieving effective visual and written communication. Data case analysis should be no longer than 8 pages (Word document), including all components such as tables, figures, references, although we don’t penalize upon the word count and page length.

Scenario

You are leading the headquarter marketing research team at the TransUnion LLC. TransUnion is an American consumer credit reporting agency. TransUnion collects and aggregates information on over one billion individual consumers in over thirty countries including “200 million files profiling nearly every credit-active consumer in the United States”. Its customers include over 65,000 businesses. Based in Chicago, Illinois, TransUnion’s 2014 revenue was US$3.83 billion. It is one of the three largest credit agencies, along with Experian and Equifax (known as the “Big Three”)

Currently, your team is undertaking an important marketing research project which aims (1) to understand the state of customer dissatisfaction about the credit reporting services in the United States, (2) to quantify and visualize the historical and geographical trends in the consumer complaints, (3) to understand the state of consumer dissatisfaction towards the Big 3 credit reporting agencies including your company (TransUnion) and the two major competitors (Experian and Equifax), and (4) to improve customer experience and complaint management system at the TransUnion.

Data

A dataset about consumer complaints about financial products and services are obtained from the Consumer Financial Protection Bureau (CFPB: https://www.consumerfinance.gov/) which is an agency of the United States government responsible for consumer protection in the financial sector. Each week CFPB sends thousands of consumer complaints about financial products and services to companies for response. Data from those complaints helps to understand the financial marketplace and protect consumers. For further information of CFPB and its databases, you must explore their website (https://www.consumerfinance.gov/). The database includes general and descriptive information of about 500,000 consumer complaints and company responses about the Big 3 credit reporting companies in the U.S. The information available in the database can be found here. This dataset is enhanced further with US census data which includes a number of socio-demographic information at the county-level (FIPS) from SVI. A complete dictionary and description for the variables in the dataset is provided on Canvas (Data Dictionary).

Note that you will be provided with a different dataset depending on your SID. Please check your SID and the last digit of SID, and download and use an appropriate dataset. Don’t try to collaborate with other students as it is an individual assignment involving different datasets. In addition, you are expected to bring different and unique angles to the dataset.

Key Deliverables in Data Case Analysis

Task 1 (10 pts): In the first task, you must provide “thick descriptions” of the state of customer dissatisfaction about the financial products and services in the United States. For this task, you may consider the following questions to answer, but you can attempt to generate other insights about the state of customer dissatisfaction about credit reporting services in the United States.

o What is the state of customer dissatisfaction? Quantify and visualize the historical and geographical trend in the complaint volume and complaint rate by location (e.g., ZIP, FIPS, or States) or issues?

o How effectively have complaint cases been managed over time?

o Are there any event-related (i.e., Covid-19) or seasonal effects on the volume of complaints?

o Are there any socio-demographic factors influencing consumer complaints about credit reporting services?

Task 2 (10 pts): In the second task, you want to understand customer dissatisfaction about your company (TransUnion) and major competitors (Experian and Equifax). In other words, you have to provide some descriptive insights that can be translated into prescriptive insights for customer management and complaint handling system.  Note that Task 2 is a very open-ended question, meaning that you can communicate any strategic insights you find important and interesting. Below are some example questions you may try to address:

o How many complaints have TransUnion and its major competitors received? And where do such complaints come from? What is the historical trend in the complaint volume by company or before and after Covid-19?

o What kinds of key performance metrics you would use to evaluate the complaint management performance? Based upon some metrics, discuss and compare how effectively TransUnion and its competitors have managed consumer complaints.

o Produce a couple of recommendations for TransUnion to manage consumer complaints better than its competitors.

Tips…. The above answers are examples only. You may decide on focus on other questions not mentioned above. Consider the use of Tableau.