Data Analysis Using SQL

Telecom Customer Churn

Data for a fictional Telecommunications company that provides phone and internet services to 7,043 customers in California, and includes details about customer demographics, location, services, and current status

Recommended Analysis:

1.How many Customers joined,stayed and Churned in last year?

2.What age groups are likely stay with the telecom company?

3.Display the Cities with the highest population and with only JOINED status?

All the Analysis have done by using Microsoft SQL Server Studio.

At first Downloaded the dataset from Maven Analytics website which is in Excel CSV format.And then the downloaded dataset was imported to SQL studio for further analysis.Generally After the Importing the data ,cleaning of data would be recommended but here the data set does not require any of data cleaning process.So i directly moved onto data analysis part.

The following are the queries which will derive insights for the above analysis

Insight 1:The below is the query which returns the status of customer and how many customers belong to each status last year.

Insight 2:

The below is the query which age group are most likely interested in telecom company.According to analysis age group 19-30 are more interested to stay with this telecom company.

Insight 3:The below query displays the highest population with the customer status joined and city the customer belongs to.