29.04.2023
I like the explanations. I've heard of churn analyses before but had never done one so this is good experience.
We teach you how to work and analyze real data and gain insight into customer churn behavior in a subscription-based model. We also address the theory behind customer churn, retention rates, and customer flows and implement and analyze a customer churn report in Tableau.
Analyzing customer behavior based on data is becoming necessary for any business to understand its consumer base. In this course, you’ll learn how to define and analyze customer churn metrics, such as customer retention rate, customer re-subscription rate, customer lifetime value, and more. We’ll work with a real database, query it using MySQL, and create a Tableau dashboard based on the customer data. You’ll learn how to create maps and cohort tables, use Tableau filters, and more.
We’ll create a churn analysis report using Tableau. You’ll gain valuable insight into customers’ behavior of the 365 subscribers and upskill your Tableau knowledge.
This section introduces the course, covering what you’ll learn. We also touch on the prerequisites for the course: SQL and Tableau fundamentals.
Here, we introduce the relevant metrics for our customer churn journey and define key questions to answer during our analysis. These questions hold the basis for creating the outline of our report—a customer churn story in Tableau, which we’ll sketch out at the end of the section.
In this section, we’ll dedicate time to MySQL and Workbench to better understand how to query real data from a database. We’ll focus on two key queries for the net revenue and resurrected users, and you’ll learn how to export data to a CSV file.
This is where we begin to build the dashboard in Tableau. Using the CSV files obtained from the database, we first create a net revenue and refunds bar chart, followed by a new vs recurring side-by-side bar and line combination chart. This section also features a map chart and the top 10 countries by revenue chart. We also perform chart styling and formatting, add filters, and build the story and points in Tableau.
In this section, we complete the rest of the dashboard. We create a bubble and bar chart of user resurrections, cohort analysis tables for the monthly and annual plan holders, and an order frequency chart of purchases. And we show how to add KPIs and images to your report.
In this final section, we analyze the results of our customer churn analysis in Tableau. We address (among others) revenue, refunds, and churn rates and compare results to industry benchmark data. As a part of the discussion, we propose viable strategies to improve metrics and overall performance for the 365 business model. Many proposed methods can be applied and modified to fit various business settings.
Student feedback
Customer Churn Analysis with SQL and Tableau
with Elitsa Kaloyanova