Atliqo Telecom Analysis

Goals-

AtliQo is one of the leading telecom providers in India and launched its 5G plans in May 2022 along with other telecom providers.Create the comparison report and provide insights to the executive team in the telecom domain.

Business Needs-

Atliqo 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.

Insights-

• 5G implementation done on May.
• Active users is decreased by 9.03%.
• Average ARPU increases by 11.05%.
• Unsubscribed users increases by 23.50%.
• Mumbai has highest revenue before and after 5G.
• Revenue from Delhi is highly decreased after 5G above all the cities
• Before 5G launch market share of atliqo is decreases in March-April.
• After 5G launch market share of atliqo is increases in June-July and then decreases in August-September.

LinkedIn Post