Mobile Broadband Services Performance Evaluation and Clustering

This project aims to evaluate the performance of telecommunication services in Australia by determining the maximum download speed, upload speed and latency to consider the connection as impaired or underperforming. Segmentation of broadband services also provides choices for customer's preference and create a broadband service plan.

Data Exploration and Visualization

Capture trends and insights by visualizing the variables and distribution of service providers, technology, tiers and KPI for broadband services in different states of Australia.

Multiple
Logistic Regression

Deep dive into the KPI by acquiring the probabilities of classification values that sets the standards of being impaired and underperforming

Accuracy
Testing

Applied accuracy, precision, recall, f1, jaccard and log loss scores to determine how good our model fits our data set.

Principal Component Analysis

Implemented dimensionality reduction technique to summarize the large data set increasing interpretability while keeping the significant information.

K-Means Elbow
Method

Utilized K-Elbow method and visualization to determine the optimal number of clusters that suits the data sample.

Agglomerative
Clustering

Creates the hierarchical segmentation that make use of the variables to set profiles for each clusters.

Data Analysis Summary Findings

Analysis of retail service providers versus other categorical variables such as technology, tier, and state.

RSP vs. Technology

  • Aussie Broadband, Telstra and iNet are the major providers of Fiber to the Node connection.

  • Hybrid Fibre Coaxial and Fiber to the Premises are second preferred connection which number varies depending on the service provider. iNet tops the chart in providing Fiber to the premises while TPG tops in Hybrid Fiber Coaxial.

RSP vs. Tier

  • Telstra is our top provider of 50/20 Mbps connection which also offers 100/20 Mbps as it ranks second behind Dodo & iPrimus.

  • Launtel offers 250/100 Mbps and tops the other providers in servicing 400/50 Mbps even though it does not have a lot of subscribers in other tiers.

RSP vs. State

  • TPG, Optus and Telstra are the top three RSP in New South Wales (NSW) while Aussie Broadband tops in providing internet connection in Victoria State.

feature img feature img
feature img

Performance Evaluation

KPI investigation in terms of download speed, upload speed and latency aggregated values.

RSP vs. Maximum KPIs

  • Fidelity observation in terms of maximum upload and download speed for all service providers.

  • Aussie Broadband, Optus, TPG and iiNet have improved maximum latency during busy hour. While some of the tiers in different service providers have significant increase in latency, most of them displays a consistent value.

RSP vs. Minimum KPIs

  • Minimum download and upload speed shows that both metrics increased during busy hours which clearly observed from tiers with 250Mbps and above mininum download speed.

  • The minimum latency stays consistent during busy hours sticking its values from the all hour records for all service providers

Technology vs. Mean KPI

  • Fibre to the Curb and Fibre to the Node have the least capability for mean download and upload speed showing only select few of tiers.

  • Fibre to the Premises is the only technology that is capable of offering a technology with 100Mbps upload speed with 250Mbps and above download speed, with better latency and least average daily outages compared to other technologies.

Setting the standards

Classification of connection's impairedness and underperformance based on KPI metrics for 100/20 Mbps. Extracting the probabilities of each KPI values to determine the standard value.

With 89.5% accuracy score, the limits of the metrics to consider our service is impaired are:

  • Download speed at 23, upload speed at 5 and latency value of 13 shows impairedness in broadband connection.

With 92.1% accuracy score, the limits of the metrics to consider our service underperforming are:

  • Download speed at 16, upload speed at 5 and latency value of 16 shows underperformance in broadband connection.

feature img
feature img feature img

Broadband Segmentation Plan Profile

Cluster profiles developed using agglomerative clustering and k-elbow method.

Cluster 0:

  • Download Speed: up to 275Mbps|Upload Speed: up to 40Mbps|Latency: High

  • Broadband service description: Telstra (Service provider), Hybrid Fibre Coaxial (Technology). Commonly utilized in Victoria State and unavailable for remote services.

Cluster 1:

  • Download Speed: up to 450Mbps|Upload Speed: up to 50Mbps|Latency: Low

  • Broadband service description: Aussie Broadband or Telstra (Service provider), Fibre to the Premises (Technology). Commonly utilized in New South Wales, top choice in urban geography and unavailable for remote services.

Cluster 2:

  • Download Speed: up to 50Mbps|Upload Speed: up to 20Mbps|Latency: Average

  • Broadband service description: Aussie Broadband or TPG (Service provider), Fibre to the Node (Technology). Also commonly utilized in New South Wales and unavailable for remote services.

Cluster 3:

  • Download Speed: up to 100Mbps|Upload Speed: up to 40Mbps|Latency: Very Low

  • Broadband service description: Telstra, Aussie Broadband and iiNet (Service provider), Fibre to the Node (Technology). Commonly utilized in Victoria State and unavailable for remote services.