High Level Design

Overview

Keeping the customers we already have is usually better and cheaper than trying to find and win new ones. This is why most businesses aim to convert first-time buyers into long-term profitable customers. Customer Churn is a powerful analysis as part of the retention efforts, and takes into account the percentage of subscribers to a service who discontinue their subscriptions to that service within a given time period.

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

Customer Churn - Customer Service Dashboard

Goals

Retain as many customers as possible.

Objectives

Reduce customer churn by 20% from past year.

KPI Architecture

Objectives KPIs Measures Data Source
Reduce customer churn by 20% from past year. Customer Churn Rate Customers Acquisitions Customers base dimension table, Date dimension table and our Transactions fact table
Customers Ceased
Customers Revenue
Demographic Churn Analysis

Data Modeling (Elasticube Design)

Suggested data model for customer churn analysis