Data Analyst | Power BI | Excel | SQL | Python | Microsoft Certified Data Analyst Associate
Completed a comprehensive analysis of a telecom company's business and the impact of 5G on its revenue. Here are my observations: - After the 5G launch, the revenue dropped by 0.5%, and the TAU decreased by 8.3%. - However, the ARPU increased by 11.1% to 211.3 INR per user. - Plan p1 remains the top plan with 22% of the total monthly revenue. - Tier 1 cities like Mumbai, Delhi, Kolkata, Chennai, and Bangalore combined contribute to more than 55% of every plan. (ARPU-Average Revenue Per User, TAU-Total Active Users) Based on my analysis, here are my recommendations for Wavecon Telecom: - Discontinue plan p7 immediately, as its revenue fell by 77% after the 5G launch. - Focus on gaining market share in tier 2 and tier 3 cities, as the top 5 cities contributed 55% of the total revenue, while the other 11 cities combined contributed the remaining 45%. - Additionally, many tier 2 and tier 3 cities are generating more ARPU compared to tier 1 cities. - To scale up further, the company needs to focus on increasing TAU, which fell by 8.3% and regain last year's unsubscribed users by 25%. Check out my presentation for more details: https://lnkd.in/gWAQJi9f. This project is part of my #codebasicsvirtualinternship under the guidance of Dhaval Patel and Hemanand Vadivel.
