Telcom Analysis

Tools Used in Project

- SQL for analyzing the business problem statement.

- Power BI for visualization of business problems.

- MS Word for documentation.

Monthly Charges:

Fiber optic service has the highest average monthly charge at 64.76.

DSL service has a significantly lower average monthly charge at 32.17.

The total sum of monthly charges is 456,120.

Customer Churn:

7043 customers have churned.

The majority of customers (73.46%) have not churned.

Fiber optic service has the highest churn rate (26.54%).

Customer Distribution by Internet Service:

The majority of customers (62.11%) have fiber optic service.

30.84% of customers have DSL service.

Only a small portion of customers (7.05%) have no internet service.

Payment Methods:

Electronic check is the most common payment method used by customers.

Paperless billing is preferred by most customers.

Overall, the dashboard highlights that fiber optic service is the most popular but also has the highest churn rate. The company may want to investigate why customers are churning from fiber optic service and take steps to improve customer satisfaction.