Sujith Jayaprasad的动态

查看Sujith Jayaprasad的档案

Data Analyst | Diploma in Data Science Graduate at LIBA ?? | Excel | Power BI, DAX, Data Modeling, ETL, Dashboard ?? | SQL | Python ?? | Machine Learning ?? | Delivering Data-Driven Insights to Drive Business Growth ??

Week 2 at AtliQ Technologies was a fantastic learning experience! Thanks to Dhaval Patel, Hemanand Vadivel and Codebasics team for the opportunity to work on the Wavecon Telecom Analysis project. I enjoyed diving into the data, uncovering insights, and presenting my findings to the team. Excited to continue growing and contributing at AtliQ! Project Link: https://lnkd.in/gFjwTrhn Video/Audio Presentation : https://lnkd.in/gGPFfzxC Project Introduction: Wavecon Telecom, a leading telecommunications company, successfully launched its 5G network in June 2022, marking a significant technological advancement. This project aims to evaluate the effectiveness of this launch by analyzing Key Performance Indicators (KPIs) such as Revenue, Average Revenue Per Users (ARPUs), Active Users, Unsubscribed Users and market share. By examining data from multiple cities, we aim to understand the overall performance and identify trends, challenges, and opportunities arising from the 5G rollout. Insights ??: 1. Overall Revenue Drop: Total revenue decreased slightly by -(0.50%) from 15,997 million to 15,897 million after the 5G launch. 2. Top Performing Cities: Lucknow 1.82%, Gurgaon 1.51%, Patna 1.48%, Raipur 1.15% showed positive revenue growth. 3. Cities with Revenue Decline: Delhi (-2.83%), Chennai (-2.59%), Ahmedabad (-2.02%), Hyderabad (-1.29%) experienced revenue decreases. 4. Active User Decline: Total Active Users (TAU) has dropped by (-8.28%) since the 5G launch. 5. Plan P7 (25 GB Combo 3G/4G Data Pack) has been severely impacted by the introduction of 5G technology. Revenue has decreased significantly by (-73.3%) 6. Significant Impact: Cities like Ahmedabad, Delhi, Raipur, Patna, Mumbai, Bangalore, Gurgaon have experienced the steepest decline in active users, exceeding 13%. Recommendation: Discontinuing Plan P7 (25 GB Combo 3G/4G) appears to be the most strategic decision. By concentrating on plans that meet the demands of the 5G market, we can secure our future success. #atliqtechnologies #codebasicsvirtualinternship #telecom #dataanalysis #learningandgrowing

要查看或添加评论,请登录