Impact of 5G implementation

Problem statement: One leading telecom provider in India has implemented 5G plan on May 22. However, management has noticed a decline in active users and revenue growth post implementation. The management of telecom provider has requested Surflex analytics team to analyze the KPIs pre and post implementation of 5G plans. The management is keen to compare the important KPIs and make informed decisions so that they can recover the active users and other parameters. They also want to optimize the offering so that they can get more active users.

Expected tasks:

a) Compare the major key parameters like total revenue, average revenue, active users, market shares etc.

b) The analysis of churned subscribers based on different demographics and other parameters

c) Detailed analysis of plans so that those can be optimized to stop the decline in revenues, active users etc.

Technology used: Microsoft power BI, excel.csv

Key Insights:

𝗔𝗳𝘁𝗲𝗿 𝟱𝗚, 𝗥𝗲𝘃𝗲𝗻𝘂𝗲 𝗱𝗿𝗼𝗽𝗽𝗲𝗱 𝗯𝘆 -𝟬.𝟱𝟬%.

𝗔𝗳𝘁𝗲𝗿 𝟱𝗚, 𝗔𝗥𝗣𝗨 𝗶𝗻𝗰𝗿𝗲𝗮𝘀𝗲𝗱 𝗯𝘆 𝟭𝟭.𝟬𝟱%.

𝗔𝗳𝘁𝗲𝗿 𝟱𝗚, 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗔𝗰𝘁𝗶𝘃𝗲 𝗨𝘀𝗲𝗿𝘀 𝗱𝗿𝗼𝗽𝗽𝗲𝗱 𝗯𝘆 -𝟴.𝟮𝟴%.

𝗔𝗳𝘁𝗲𝗿 𝟱𝗚, 𝗖𝗵𝘂𝗿𝗻 𝗥𝗮𝘁𝗲 𝗶𝗻𝗰𝗿𝗲𝗮𝘀𝗲𝗱 𝗯𝘆 𝟭.𝟵𝟵%.

𝗔𝗳𝘁𝗲𝗿 𝟱𝗚, 𝗶𝗻𝘁𝗲𝗿𝗻𝗲𝘁 𝗰𝗼𝗺𝗯𝗼 𝗽𝗹𝗮𝗻𝘀 𝗮𝗿𝗲 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗶𝗻𝗴 𝘄𝗲𝗹𝗹.