Analysis-of-a-telecommunications-company

ConnectaTel – Customer Usage Analysis

An exploratory data analysis project focused on understanding mobile service usage patterns for ConnectaTel customers.

The project analyzes calls and SMS behavior, detects outliers, and builds customer segments based on usage patterns to support data-driven business decisions.

Identify usage patterns, detect atypical behaviors, and understand which customer segments show differentiated needs, in order to optimize the commercial offering and improve the user experience.

Project Objective

The goal of this project is to analyze how customers actually use mobile services in order to:

Identify usage patterns in calls and text messages
Detect outliers or abnormal behavior
Understand how usage varies by age and plan type
Create customer segments based on usage
Generate business insights to improve mobile plans

Main notebook path

`notebooks/Project-ConnectaTel_Gerardo_Olm.ipynb`

Datasets

The project uses three datasets.

`plans.csv`

Plan catalog including:

monthly price
included minutes
included data
extra usage costs

`users_latam.csv`

Customer information.

Main variables:

user_id
age
city
plan
reg_date
churn_date

Data quality issues detected:

missing values in city
invalid age values (-999)
registration dates outside expected range

`usage.csv`

User activity records.

Includes:

phone calls (duration)
text messages (length)

This dataset allows the analysis of actual service consumption.

Data quality issues detected:

0.125% Empty values in Date
55.19% Call Duration: 45% of users have made calls.
44.74% SMS Length: 55% of users have used messages included in the plan.
Possible outliers were identified in message length length that could be explored further (e.g., concatenated messages, atypical records, potential outliers).