Project Date : Jan 2023
AtliQo Telecom Analysis
Problem Statement:
AtliQo is one of the leading telecom providers in India and launched its 5G plans in May 2022 along with other telecom providers.
However, the management noticed a decline in their active users and revenue growth post 5G launch in May 2022.
AtliQo’s business director requested their analytics team to provide a comparison report of KPIs between pre and post-periods of the 5G launch.
The management is keen to compare the performance between these periods and get insights that would enable them to make informed decisions to recover their active user rate and other key metrics.
They also wonder if they can optimize their internet plans to get more active users. Peter Pandey, a junior data analyst, is assigned to this task.
Solution:
They also wonder if they can optimize their internet plans to get more active users. Peter Pandey, a junior data analyst, is assigned to this task. This Report will highlight the impact of 5G Launch, identify areas of improvement, and provide recommendations to optimize internet plans and improve customer satisfaction, retention, ARPU.
Navigate to the Interactive dashboard Link ( https://www.novypro.com/project/code-basics-resume-challenge-dashboard-1 )
Lets Dive deep into Each and Every insight.
Note: Jan, Feb, Mar, Apr - Before 5G launch | Jun, July, Aug, Sep - After 5G launch
The first section of Atliqo's dashboard showcases essential metrics such as ARPU (Average Revenue Per User), Average Revenue, Active Users, and Unsubscribed Users for the year 2022.
The graph illustrates a significant increase in the company's Average Revenue per User, though a decrease in Active Users after the 5G launch. Furthermore, the graph highlights an overall increase in Unsubscribed Users after the 5G launch, indicating a crucial area of concern for the company.
ARPU
Revenue
Active Users
Unsubscribed Users
The matrix displays the Average Revenue per User (ARPU) city-wise, highlighting notable changes after the launch of 5G. Out of 15 cities, Rajpur recorded the highest increase percentage of ARPU at 22.25%, closely followed by Ahmedabad and Patna. However, two cities, namely Chennai and Pune, witnessed a decrease in ARPU by 2.59% and 12%, respectively. These findings showcase the varying impact of the 5G launch on different cities and can help Atliqo Telecom tailor their strategies accordingly.
The revenue analysis indicates a general increase in revenue for nine cities, although the percentage increase is relatively low, ranging from a minimum of 0.11% to a maximum of 1.51%. However, the remaining six cities experienced a decline in revenue, with a minimum decrease of 1.29% to a maximum of 2%. These results demonstrate the importance of analyzing revenue data at the city level to identify areas that require improvement and adjust business strategies accordingly.
The data reveals that only three cities experienced an increase in Active Users following the launch of 5G - Pune, Lucknow, and Chennai. Conversely, all other cities observed a decline in Active Users. These findings emphasize the need for a city-specific approach to enhance user engagement and retention.
Mumbai was the only city that managed to control customer unsubscribing, with a decrease of only 12.63%. However, all other cities witnessed a significant loss of customers after the launch of 5G, ranging from a minimum of 12% to a staggering maximum of 77%. This substantial loss of customers poses a significant challenge for the company and underscores the need for effective retention strategies.
The Market Analysis section of the dashboard reveals that the Total Market Value of Atliqo Telecom Company has increased after the launch of 5G, albeit with a slight difference. These findings signify a positive trend for the company and showcase the impact of 5G technology on the telecommunications industry.
The Market Analysis section also indicates a decrease in Atliqo Telecom's market share percentage compared to its competitors after the launch of 5G. Specifically, the share percentage has decreased by 0.68%. These results highlight the intense competition in the telecommunications industry and the need for Atliqo to develop effective strategies to regain its market share.
Total Market value by month shows that their is increase in percentage of Atliqo company, after the launch of 5G.
Product Analysis
plan name plan_description
p1 Smart Recharge Pack (2 GB / Day Combo For 3 months)
p2 Super Saviour Pack (1.5 GB / Day Combo For 56 days)
p3 Elite saver Pack (1 GB/ Day) Valid: 28 Days
p4 Mini Data Saver Pack (500 MB/ Day) Valid: 20 Days
p5 Rs. 99 Full Talktime Combo Pack
p6 Xstream Mobile Data Pack: 15GB Data | 28 days
p7 25 GB Combo 3G / 4G Data Pack
p8 Daily Saviour (1 GB / Day) validity: 1 Day
p9 Combo TopUp: 14.95 Talktime and 300 MB data
p10 Big Combo Pack (6 GB / Day) validity: 3 Days
p11 Ultra Fast Mega Pack (3GB / Day Combo For 80 days)
p12 Ultra Duo Data Pack (1.8GB / Day Combo For 55 days )
p13 Mini Ultra Saver Pack (750 MB/Day for 28 Days)
Atliqo Telecom has a range of products these are those products, including various plans that have garnered significant revenue. An analysis of their performance before and after the launch of 5G reveals interesting insights. Additionally, Atliqo Telecom has also introduced new plans following the advent of 5G, which are worth exploring to assess their impact on the company's revenue..
Before the launch of 5G, the top 5 revenue-generating plans were Plan 1, Plan 2, Plan 3, Plan 4, and Plan 5, all of which collected revenue of more than 100 crores
After the launch of 5G, there has been a change in the top 5 revenue-generating plans, with Plan 11 replacing the position of Plan 2 in 2nd place, followed by Plan 12 replacing the position of Plan 4 in the 5th position. These top 5 plans have collected revenue of more than 100 crores and it is noteworthy that Plans 11 and 12 are newly launched plans, indicating a high level of customer interest in these plans.
The Bar Chart analysis reveals a significant increase in the Total Plans Revenue of Atliqo Telecom Company following the launch of 5G. Specifically, the company generated an additional 186 crores in revenue.
The chart analysis clearly indicates that Atliqo Telecom's newly launched plans - p11, p12, - have performed remarkably well in the months following their introduction. Specifically, in the month of July, these three plans generated a total revenue of 85 crores across all cities, which was further followed by significant increases in August and September. These findings highlight the success of Atliqo's recent product offerings