Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AnalyticsAAA Customer Churn Case Study AnalyticsAAA is an Australia-based world-leading commercial data analytics company that essentially collects, prepares, analyzes, and visualizes data for various clients

AnalyticsAAA Customer Churn Case Study

AnalyticsAAAis an Australia-based world-leading commercial data analytics company that essentially collects, prepares, analyzes, and visualizes data for various clients such as businesses and governments.AnalyticsAAAprides itself on offering personalized information for all levels of management and business operations. They collect comprehensive organizational (and external) data to provide a analysis and present it in a way that the audience (whoever it may be) understands.

After graduating from college, you joinedAnalyticsAAAas an analyst. Due to your excellent education, you are progressing quickly in the company. While the recognition is also financially expressed, it also means that you have started to receive a broad range of tasks and duties (ranging from data extraction, transformation, and visualizations to statistical data analyses). In order to progress to the next step, Business Analytics lead, you need to show that you are capable of not only performing the individual task but also supporting evidence-based strategic decision-making through your business knowledge and communicating your conclusions effectively.

EcommerceABC,a leading E-commerce company, has contactedAnalyticsAAAregarding their challenges related to customer churn. As customerchurnhas increased over the past,EcommerceABCis struggling financially. The company's management believes that it needs to know and predict the customers who are likely to churn so that it can approach these customers to offer promotions accordingly. The churn rate, also known as the rate of attrition or customer churn is the rate at which customers stop doing business with an entity.EcommerceABCmeasures customer churn by looking at whether a customer discontinues the service with them. Customers churn meansEcommerceABCloses customers as they stop doing business withEcomerceABCand move to another online provider. The churn rate and growth rate are diametrically opposite factors, as the former measures the loss of customers and the other measures the acquisition of customers.

EcommerceABCapproachedAnalyticsAAAand asked for analytics services to understand the drivers of their customer churn and inform their decision-making. They have sentAnalyticsAAAall sorts of data and - since it is a major client with an urgent problem -AnalyticsAAAhas decided to put their best people on the case. Therefore, you are responsible for completing the analysis and preparing a report thatEcommerceABC can use to minimize customer churn.

  1. Descriptive analysis of customer churn via PBI

Your business analytics team is requested to integrate data and develop a PowerBI report for analytical purposes to illustrate answers to key managerial questions from the marketing department and the product management teams. The data required for this task is "powerbi_data.csv". For each question, (1) include a screenshot of only the relevantvisualization(s) (2.1.1,2.2.1, and2.3.1) and (2) provide an answer in the respective deliverable section (2.1.2,2.2.2, and2.3.2).

Below are some examples of visualizations and a visualization dashboard

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foodservice Management Principles And Practices

Authors: June Payne Palacio, Monica Theis

13th Edition

0133801101, 9780133801101

More Books

Students also viewed these General Management questions

Question

=+ Do not make promises that you might not be able to fulfil.

Answered: 1 week ago

Question

1. What does this mean for me?

Answered: 1 week ago