Customer Churn Analysis with SQL and Tableau

with Elitsa Kaloyanova
4.8/5
(164)

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.

4 hours 36 lessons
Start course
36 High Quality Lessons
9 Practical Tasks
4 Hours of Content
Certificate of Achievement

Course Overview

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.

Topics covered

Bar chartBubble chartCohort analysis tableCustomer churnDashboarddata analysisdata visualizationLine chartMapsMySQL queryOrder frequency tableTableau

What You'll Learn

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.

Data visualization
Tableau story
MySQL query
Gather insights from data
Propose strategies to improve business objectives

Curriculum

Student feedback

4.8/5

164 ratings
5 stars
140 (85%)
4 stars
18 (11%)
3 stars
3 (2%)
2 stars
0 (0%)
1 star
3 (2%)
Filter by rating
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
Sort
  • Newest
  • Oldest
07.07.2023
Gaining some comprehensive view of online e-learning is so valuable to someone like me, not only need a project to present but also wondering about how to actually use sql, tableau in real scenario. For me personally, the course would even be better if the speed can slow down a little bit when draging object or click on some items in tableau. Some functions like fix() may need further explaination to really understand. Nontheless, I'm appreciate to your great project, Elitsa. Thank you!
01.08.2023
Very good course other than there are sometimes strange jumps between lessons. We make a chart in tableau looking a certain way and then in the next lecture its already styled differently + in a dashboard + added to a story. Other than that was a great practical real-life learning project
16.08.2023
it's super great, I have been searching for valuable content that explains the customer churn concepts and its most important metrics. and there you are making me feel fantastic. thanks a lot
29.04.2023
I like the explanations. I've heard of churn analyses before but had never done one so this is good experience.
03.05.2023
Some of the quiz questions are not relevant to the course that is directly ahead of the quiz.
  • 1
  • 2
  • 3
  • 4
  • ...
  • 6
Elitsa Kaloyanova

“To become a successful data analyst, you must first be comfortable with extracting, analyzing, and intuitively visualizing data. Furthermore, you should be able to gain insight from that data and utilize said insights to formulate strategic business objectives.”

Elitsa Kaloyanova

Head of Data Content at 365 Data Science

Courses You May Like

Customer Churn Analysis with SQL and Tableau

with Elitsa Kaloyanova

Start Course