Enamul K. B.
After 365:
Accounting Manager | JFE Engineering Corporation
See all reviews
Online Course
Customer Churn Analysis with SQL and Tableau
with
Elitsa Kaloyanova
Gain first-hand data analyst experience: Use SQL and Tableau to tackle real-world business challenges
2870 students already have enrolled
Skill level:
Intermediate
Duration:
3 hours
-
Lessons (3 hours)
-
Practice exams (20 minutes)
- Lessons (3 hours)
- Practice exams (20 minutes)
CPE credits:
4.5
CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of
professionals must earn to maintain their licenses and stay current with regulations and best
practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's
official website: www.nasbaregistry.org
CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of
professionals must earn to maintain their licenses and stay current with regulations and best
practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's
official website: www.nasbaregistry.org
Accredited:
certificate
What You Learn
- Improve your SQL and Tableau proficiency by tackling real-world business data.
- Perform churn analysis for a SaaS business and uncover revenue insights.
- Create professional multi-page Tableau dashboards with polished formatting.
- Identify customer churn metrics, lifetime value, and revenue breakdowns.
- Add a unique project to your portfolio with professional data visualizations.
Topics & tools
tableaudashboardmysql querybar chartdata visualizationcustomer churndata analysisorder frequency tablebubble chartcohort analysis tableline chartmapsSQLdashboard reportingbusiness skills
Your instructor
Senior Data Scientist at 365 Data Science | Computational Biologist | Data Visualization Expert
Track record
Bringing real-world expertise from leading global companies
Academic background
Master's degree, Bioinformatics
Course OVERVIEW
Description
CPE Credits: 4.5
Field of Study: Specialized Knowledge
Delivery Method: QAS Self Study
Delivery Method: QAS Self Study
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.
Prerequisites
- Any SQL environment (such as SQLite, MySQL Workbench, or an online SQL editor).
- Tableau Desktop or Tableau Public
- Python (version 3.8 or later), pandas library, and a code editor or IDE (e.g., Jupyter Notebook, Spyder, or VS Code)
Advanced preparation
Curriculum
39 lessons
4 exercises
2 exams
- 2. Intro to the case study36 MinHere, 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.Motivation - Our Story FreeIntro to the business case FreeExercise FreeBasic Terminology - Net Revenue, Refunds, New vs Recurring Revenue FreeTypes of customers FreeExercise FreeBasic Terminology - Customer Churn and Customer Retention FreeExercise FreeDefining key questions for the customer churn analysis FreePractice exam FreeCreating an outline of the dashboard Free
- 3. Data Preparation28 MinIn 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.
- 4. Creating a customer churn story in Tableau part I44 MinThis 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.Bar Chart - Net Revenue and RefundsCharts Formatting: Styling Tips for Business Dashboards in TableauCustomer Churn—Line Chart in TableauTelling a Story with Data: Create a Dashboard to Add to the Tableau StoryCreating a date filter for page one of the reportNew vs Recurring Revenue—Combination Charts in TableauRevenue by Country—Map Charts in TableauTop 10 Countries by Revenue—Tables in TableauChart Formatting and Creating the Dashboard in Tableau
- 5. Creating a customer churn story in Tableau part II27 MinIn 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.User Ressurections - Bubble Chart in TableauUser Ressurections – Bar Chart in TableauAssignment 2 – User Upgrades Bubble and Bar ChartBuilding the Tableau Dashboard - Page 5Annual Subscribers - Order Frequency Combination Chart in TableauAssignment 3 – Monthly subscribersAnnual Subscribers – Cohort Analysis Table in TableauBuilding the Tableau Dashboard – Page 6
- 6. Dashboard Interpretation49 MinIn 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.Dashboard Interpretation – Net Revenue and RefundsDashboard Interpretation – Churn RatesDashboard Interpretation – New vs Recurring RevenueDashboard Interpretation – Maps and Revenue by Country – Top 10Dashboard Interpretation – Maps and Revenue by Country – Average Order Value (AOV)Dashboard Interpretation – User UpgradesDashboard Interpretation – User ResurrectionsDashboard Interpretation – Order Frequency Table and Cohort Analysis – Annual SubscriptionsDashboard Interpretation – Order Frequency Tables and Cohort Analysis – Monthly CustomersWhat more is out there?
- 7. Course exam85 Min
Free preview
1.1 Introduction to the course
5 min
2.1 Motivation - Our Story
5 min
2.2 Intro to the business case
3 min
2.3 Basic Terminology - Net Revenue, Refunds, New vs Recurring Revenue
3 min
2.4 Types of customers
4 min
2.5 Basic Terminology - Customer Churn and Customer Retention
7 min
96%
of our students recommend
365 Data Science.
9 in 10
people walk away career-ready
with practical data and AI skills.
$29,000
average salary increase
after moving to an AI and data science career
ACCREDITED certificates
Craft a resume and LinkedIn profile you’re proud of—featuring certificates recognized by leading global
institutions.
Earn CPE-accredited credentials that showcase your dedication, growth, and essential skills—the qualities
employers value most.
Certificates are included with the Self-Study learning plan.
How it WORKS
Student REVIEWS
