Business Intelligence

Increase Revenue by Predicting Customer Churn

Value from Predicting Customer Churn

Predicting customer churn allows businesses to leverage predictive analytics to classify customers based on how likely they are to churn.  You can divide your customers into segments.  Then get very granular such as calculating each customers probability of churn.  By using historical data from your operational systems you can mine the data to create predictive classifications.  Then using this information you can modify your operational processes to take advantage of this new insight.  And determine how best to handle your customer base customized to each customer.  While data quality is important.  When you first get started building predictive modeling you should start with the data you have.  It is more important to build a model, filter out bad data, and learn about your data and how it can improve your operations.

Using data from a fictitious telecommunication company.  You will see how data mining works to determine factors that impact churn based on each customers unique features.  The dataset contains 7000 rows with the following columns.

After running the data through a Decision Tree algorithm the data is split to show the impact of the data on churn.  By reviewing the tree you will see customers on the Month-to-Month plan with Fiber Optics have the highest probability of churn.  While customer on the Month-to-Month plan with no Internet Service has the least probability of churn.

With just level of insight you can begin to further investigate the difference in customers that use fiber optic and no internet services.  Are there factors in the products or customers that are leading to the higher attrition in fiber optic customers?  How do fiber optic customers on a Month-to-Month contract compare to other customers not on a different contract?

 

CDO Advisors Microsoft Power BI Solutions:

BI as a Service – Low Monthly Fees, Pay Per Month Per User

Executive Dashboards – Get Dashboards in 4 Weeks

Healthcare Dashboard Proof of Concept – SEE your data visualized

Microsoft Power BI Demo – Compare your current reporting to Power BI

Power BI Quick Start Solutions – Ready to start or enhance your Power BI?

Train Your Team – Remote Power BI Developer and End User Training

Use Power BI for Finance Teams – Learn how Power BI can improve operations

Virtual Chief Data Officer – Confused by all your data?  We can help

Derek

I am the founder and CEO of CDO Advisors a data and analytics consulting and training company. We specialize in helping companies get more value from their data with high value low risk projects.I have been publishing articles and books for over 20 years on SQL Server, data and architecture.

Recent Posts

3 Business Views in Power BI You Need for Every Report

3 Business Views in Power BI I often see reports that were built in Power…

2 years ago

3 Power BI Governance Best Practices

3 Power BI Governance Best Practices As you get started with Power BI for reporting…

2 years ago

Complete Power BI Consulting Services

Power BI Consulting Services Get Power BI Consulting for 50% less than Big Firms I…

2 years ago

Power BI Data Quality Dashboard Examples

Power BI Data Quality Dashboard Examples Data quality is a problem for every company.  Legacy…

2 years ago

3 Secrets to Drive Power BI Adoption

The Secrets to Drive BI Adoption Drive Power BI adoption in your enterprise with these…

2 years ago

3 Common Power BI Adoption Issues

3 Common Power BI Adoption Issues I often see companies that have spent the time…

2 years ago

This website uses cookies.