Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

MKTG6001 (2023 S2) – Final Individual Assignment (30 pts)

The final individual assignment consists of two parts as detailed below.

Part 1 – Reflective Essay (10pts, word limit 2 pages, 12-point font with 1.5 spacing, not including the appendices)

Reflection on reflections: In this reflective essay, you must choose one of your weekly reflections and one workshop content from week 1 to week 12. The purpose of this reflective essay is to demonstrate how your knowledge about marketing research has progressed across the semester in ways that have helped you better appreciate and understand marketing research.

Part 1A – Reflection on Canvas Learning Modules (1 page)

Within your weekly Canvas modules, you are asked to reflect (think) about your current understanding and also what you have learned at the end of the module - to capture your understanding directly after learning the new material. Please review your reflection collection and choose ONE reflection that was the most illuminating moment that really advanced your understanding of marketing research. Describe the weekly reflection that allowed you to see new, interesting and important ideas of marketing research. You should copy and paste the most illuminating reflection into an appendix (a screenshot of your weekly reflection)

· A reflection should NOT just be a description of what you have learned, description is only one part of a good reflection.

· You should reflect on

o What you thought and felt about what you learned

o What you think and feel for now about what you learned

o How what you have learned has changed how you think

o How what you have learned has changed what you intended to do in the future

Part 1B – Reflection on Workshop Activities (1 page)

We have learned a number of practical skills and techniques for marketing research throughout the semester: data visualisation (weeks 2 and 4), focus group interview (week 3), survey questionnaire design using Qualtrics (weeks 5 and 6), A/B testing (week 8), text analysis using Python (week 9), data analysis and statistical tests (weeks 10 and 11), and predictive analytics using RapidMiner (week 12). Please review the workshop activities and choose ONE workshop activity that you find most interesting and useful.  You should reflect on

· What you thought and felt about what you learned from the workshop

· How what you have learned has changed how you think about marketing research

· How what you have learned has changed what you intended to do in the future. For example, what skills you intend to develop further in the future and why?

Part 2 – 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 Equifax Inc. It is an American multinational consumer credit reporting agency headquartered in Atlanta, Georgia, one of the three largest consumer credit reporting agencies in the world, along with Experian and TransUnion (so called “Big 3”). Equifax collects and aggregates information on over 800 million individual consumers and more than 88 million businesses worldwide. In addition to credit and demographic data and services to business, Equifax sells credit monitoring and fraud prevention services directly to consumers. Equifax operates or has investments in 24 countries in the Americas, Europe, and Asia Pacific. With over 14,000 employees worldwide, Equifax has nearly US$5 billion in annual revenue and is traded on the New York Stock Exchange (NYSE) under the symbol EFX.

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 (Equifax) and the two major competitors (Experian and Transunion), and (4) to improve customer experience and complaint management system at the Equifax.

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 current 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), issues, or other factors?

o How effectively have complaint cases been managed over time (compensation provision, timely response, and customer dispute rate)?

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 (Equifax) and major competitors (Experian and TransUnion). 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 Equifax 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 Equifax and its competitors have managed consumer complaints.

o Produce a couple of recommendations for Equifax 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.