Vidhath Shetty’s Post

Unlocking Insights: Wavecon Telecom's 5G Impact Analysis 📊   We've delved deep into Wavecon Telecom's journey with 5G, uncovering pivotal insights that shape the telecom landscape. Here's a snapshot of our findings:   📈 Revenue Dynamics: While total revenue dipped by 0.5% post-5G, we observed a remarkable 11.05% increase in Average Revenue Per User (ARPU). Ahmedabad emerged as a frontrunner in ARPU growth.   📉 User Trends: Active user base witnessed an 8.28% decline, alongside a significant surge in plan unsubscribes by 23.5%. Lucknow, Jaipur, and Pune topped the list for unsubscribed users, while Mumbai retained a loyal customer base.   🌐 Market Insights: PIO_MS secured the lion's share of the market, with Dadaphone_MS and Others_MS trailing behind. The market landscape continues to evolve, offering strategic opportunities for growth.   📱 Plan Performance: Plan P1 demonstrated revenue growth, particularly thriving in Mumbai, Kolkata, and Delhi. Conversely, Plan P11 stole the spotlight post-5G launch, boasting significant revenue and customer traction in key cities like Mumbai, Delhi, and Kolkata.   🏙️ City Dynamics: City-wise analysis revealed varying performance metrics across regions. Mumbai, Delhi, and Bangalore emerged as strongholds for revenue generation across multiple plans, while Patna, Coimbatore, and Gurugram faced challenges in user engagement. #codebasicsvirtualinternship

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.

GCC spree pushes up demand for data centres, enters list of top sectors ! GCCs operating in the technology and telecom vertical constitute about 27 percent of the data centre demand, followed by banking, financial services, and insurance (BFSI) at 20 percent. Another reason why GCCs are rapidly availing the services of data centres is the recent data localisation requirements, which are part of the Digital Personal Data Protection Act, 2023. GCCs, which are dedicated offshore centres set up by a company to in-source IT and other related business functions, have come into the spotlight of late due to their hiring spree, which has outpaced that of IT service companies. GCCs, which are dedicated offshore centres set up by a company to in-source IT and other related business functions, have come into the spotlight of late due to their hiring spree, which has outpaced that of IT service companies. Currently, India’s operational data centre capacity stands at 1.1 gigawatts, with another 1.7 gigawatts either under construction or planned in the coming five years, according to data from Cushman & Wakefield. Currently, India is the 13th largest data centre hub in the world. Despite the concentration of data centres in major metropolitan hubs such as Mumbai, Chennai, and Bengaluru, there is a growing recognition of the untapped potential in Tier II and III cities. “Because of the GCC spread, Tier II and III cities such as Pune, Nagpur, Kolkata, Kochi, Coimbatore and Vadodara are becoming hub spots for data centres,” Loliwala said. #gcc # datacenter #gcctech #gcctelecom #gccindia

The Q4 2023 micro market analysis of Bangalore indicates that North Bangalore holds the forefront in sales value, with West Bangalore closely behind. Conversely, South Bangalore emerges as the leader in transaction volume, with North Bangalore following. For comprehensive insights and to remain at the forefront of market trends, delve into our detailed analysis. Explore further now: https://bit.ly/49mtBup #SquareYards #Bangalore #PropertyAnalysis #RealEstateTrends #BangaloreRealEstate #BangaloreProperty #MarketTrends #DataIntelligence

🚀 Excited to share my very first LinkedIn post, where I present my WaveCon Telecom 5G Impact Analysis, completed as part of the #CodeBasicsVirtualInternship. Using an existing Power BI dashboard, I analyzed WaveCon Telecom’s performance after the 5G launch. 🔍 Revenue Insights: Major cities like Mumbai, Delhi, and Kolkata saw significant growth in revenue post-5G launch, while Chandigarh and Raipur underperformed. City-wise breakdown of active and unsubscribed users provided key insights into customer behavior and plan preferences. 📊 KPI Performance: Identified KPIs that underperformed after the 5G rollout, helping focus efforts on areas needing improvement. Plans like the Mini Data Saver Pack and Rs.99 Full Talktime Combo Pack are struggling, and recommendations were made to discontinue these and shift to more data-centric offerings to align with customer preferences in the 5G era. 📈 Plan Performance: High-performing plans saw a 33% revenue increase, while others dropped by 72%, indicating a clear need for reevaluation of lower-performing options. With the 5G rollout, data demands surged, and the Xstream Mobile Data Pack emerged as a key area of concern due to its low performance. We suggested discontinuation and replacement with larger, more competitive data packages. 🔑 Actionable Recommendations: Revamping and refining plan offerings to capitalize on 5G's high bandwidth and data usage potential. Focusing on user-centric approaches to ensure customer satisfaction and increased retention rates. I want to extend my gratitude to the Codebasics team ,Dhaval Patel and Hemanand Vadivel for their guidance and for providing such an enriching learning experience. Looking forward to applying these insights and enhancing my data analysis skills further! #TelecomAnalysis #5GRevolution #DataAnalytics #PowerBI #Codebasics #Telecom #CustomerExperience

Session Highlights: Amit Singh, Sr. Vice President, CtrlS Datacenters Ltd at the #TechSabha 2024 | 1st March 2024 | Kolkata | Presenting Partner: Samsung Electronics | Powered by Google Cloud   Topic: Take Control of Digital Transformation [1] GenAl has the potential to add $1.5 trillion to India's GDP over the next 7 years.   [2] Tier II and Tier III markets are set to witness strengthened digital connectivity with Edge data centers.   [3] Low-latency and seamless content delivery across the country, with enhanced user experience, signify the importance of edge data centers.   [4] Our company offers and operates in hyperscale, colocation, and edge data centers in key technology hubs.   [5] CtrIS has Rated-4 data centers spread across the top technology hubs of India - Mumbai, Hyderabad, Bengaluru, Chennai, Noida, Lucknow, and Patna.   [6] We are sustainable at heart and have disposed of more than 77,000 kgs of battery waste and 2.35 tons of e-waste in an environmentally friendly manner in the last 3 years.

🚀 𝙏𝙚𝙡𝙚𝙘𝙤𝙢 𝘿𝙤𝙢𝙖𝙞𝙣 𝘼𝙣𝙖𝙡𝙮𝙩𝙞𝙘𝙨 𝙋𝙧𝙤𝙟𝙚𝙘𝙩: 𝙋𝙤𝙨𝙩-5𝙂 𝙇𝙖𝙪𝙣𝙘𝙝 𝘼𝙣𝙖𝙡𝙮𝙨𝙞𝙨,, #CodeBasics #ResumeChallenge3 📊 I’m thrilled to share my latest project, where I analyzed the performance of AtliqO, one of India’s leading telecom providers, post their 5G launch in May 2022. The management sought insights to compare key KPIs between the pre- and post-launch periods, aiming to understand the challenges and opportunities brought by the 5G rollout. 🗝️ 𝙆𝙚𝙮 𝙄𝙣𝙨𝙞𝙜𝙝𝙩𝙨 𝙛𝙧𝙤𝙢 𝙈𝙮 𝘼𝙣𝙖𝙡𝙮𝙨𝙞𝙨: 𝗥𝗲𝘃𝗲𝗻𝘂𝗲 𝗜𝗺𝗽𝗮𝗰𝘁: A slight decline of 0.26% in revenue post-5G launch. 𝗔𝗰𝘁𝗶𝘃𝗲 𝗨𝘀𝗲𝗿𝘀: Unsubscribed users increased by 𝟭𝟬.𝟱𝟮%, active users decreased by 𝟰.𝟯𝟮%. 𝗣𝗹𝗮𝗻 𝗖𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗶𝗼𝗻𝘀: Plans P1, P2, and P11 generated 36.10% of the total revenue from May to September. 𝗨𝗻𝘀𝘂𝗯𝘀𝗰𝗿𝗶𝗯𝗲𝗱 𝗨𝘀𝗲𝗿𝘀: Delhi saw the highest unsubscriptions (7.80%) consistently from June to September. 𝗠𝗮𝗿𝗸𝗲𝘁 𝗦𝗵𝗮𝗿𝗲: AtliqO held the 3rd rank in market share from June to September. 🌍 𝙂𝙚𝙤𝙜𝙧𝙖𝙥𝙝𝙞𝙘𝙖𝙡 𝙄𝙣𝙨𝙞𝙜𝙝𝙩𝙨: 𝗛𝗶𝗴𝗵𝗲𝘀𝘁 𝗥𝗲𝘃𝗲𝗻𝘂𝗲: Mumbai 𝗟𝗼𝘄𝗲𝘀𝘁 𝗥𝗲𝘃𝗲𝗻𝘂𝗲: Raipur Cities like Mumbai, Kolkata, and Pune show great potential for 5G adoption. Delhi and Bangalore show limited interest in 5G services. 🚀 𝘊𝘩𝘦𝘤𝘬 𝘰𝘶𝘵 𝘵𝘩𝘦 𝘧𝘶𝘭𝘭 𝘱𝘳𝘰𝘫𝘦𝘤𝘵 𝘥𝘦𝘵𝘢𝘪𝘭𝘴 𝘢𝘯𝘥 𝘷𝘪𝘴𝘶𝘢𝘭𝘴 𝘩𝘦𝘳𝘦: 📂 https://lnkd.in/gMwdiwsu 👇 𝘓𝘪𝘯𝘬 𝘰𝘧 𝘵𝘩𝘦 𝘎𝘪𝘵 𝘙𝘦𝘱𝘰𝘴𝘪𝘵𝘰𝘳𝘺 𝘏𝘦𝘳𝘦: https://lnkd.in/gCiPB6K9 📉 𝘽𝙪𝙨𝙞𝙣𝙚𝙨𝙨 𝙄𝙢𝙥𝙡𝙞𝙘𝙖𝙩𝙞𝙤𝙣𝙨: These insights provide actionable recommendations to optimize AtliqO’s 5G plans, recover active users, and enhance revenue growth by targeting cities with higher adoption potential.  Working on this project helped me strengthen my skills in data analysis, Power BI, and understanding real-world business challenges in the telecom domain. Feel free to share your thoughts or experiences in analyzing similar trends! #DataAnalytics #TelecomDomain #PowerBI #5G #BusinessInsights #LearningJourney

Hello all, For my Week 3 of the 90 Data Analysis Challenge, I have been tasked with creating a report and dashboard for Atliqo, one of leading telecom providers in India. After performing this task, I have gain some valuable insights on how they can start increasing their revenue and number of active users again. Key Insights: -Focus on increasing user retention and acquisition in high revenue cities like Mumbai, Delhi, Kolkata, and Bangalore -Tailor affordable plans and targeted promotions in cities with lower revenues such as Raipur, Chandigarh, and Gurgaon -Optimize and bundle mid-tier plans (p4-p6) for better engagement while revising low-performing plans (p8-p10) to offer more value -Launch targeted marketing campaigns focusing on key cities and user needs - Analyze behavior and feedback post 5-G launch to better understand why there was a decline in users and address specific service or pricing concerns @Codebasics @Dhaval Patel @Hermanand Vadivel #daroadmap24

[#MarketDynamics] [#India] In the first half of 2024, India data centers experienced significant growth, with the total IT capacity increasing by 21% (YoY), data centers added approximately 71MW of capacity during H1-2024. This growth builds on the momentum from 2023 when the country’s data center capacity grew by approximately 255 MW, this is expected to continue with projections at a rate of 25-30% annual growth in the coming years. Current Market Trend: · #Mumbai remains the dominant market holding over 54% of the total capacity, as this city is known for its role as the financial capital of India. · #Chennai follows with more than 12% of the capacity, leveraging its strategic position on the East Coast. · #Bangalore, #Pune, and #Hyderabad together account for over 30% of the market share, these locations are also expected to see significant growth in the coming years. In the remaining months of 2024, demand is projected to reach 400 MW, indicating a 14.28% shortfall compared to the expected supply. This demand was mainly driven by hyperscalers, Banking, Financial Service and Insurance (BFSI), IT & ITeS, and service sectors. This significant growth is driving an increasing demand in the workforce for the data center industry. NV5 Data Centre & Mission Critical India’s experience mirrors this trend – our team in India grew 20% in the last year, with the addition of the Hyderabad office and the expansion of the Bangalore office. Data Source: https://lnkd.in/gZVaMMwC #DataCenter #Market #Workforce #Growth #MissionCritical 

As the data centre industry rapidly expands in India, we're witnessing growth beyond the usual hubs like Mumbai and Chennai. Here's why emerging cities are becoming new hotspots for data centres: 1. New Strategic Locations: Cities such as Kochi, Jaipur, Ahmedabad, Lucknow, Patna, and Visakhapatnam are gaining traction due to their strategic positioning and improved infrastructure. These locations offer: - Enhanced power supply - Upgraded fibre and cable connectivity 2. Proximity to Growing User Base: By expanding to Tier-2 cities, companies can serve a more distributed user base, leading to: - Faster response times - Reduced latency for time-sensitive applications 3. Cost Efficiency: - Cheaper land and construction costs in these emerging locations compared to major metro cities - Significant savings for companies investing in these regions 4. Network Resilience: Diversifying data center locations: - Spreads economic benefits across more regions - Strengthens overall network resilience by reducing the risks of clustering in a few areas While cities like Mumbai and Chennai continue to dominate due to their reliable power supply, proximity to submarine cable landings, and large end-user markets, Delhi-NCR and Hyderabad are also seeing increased demand. Regulatory incentives and the substantial demand from government organizations drive this growth. Rounak Real Estate Consultants stays ahead of these trends, offering strategic guidance for data center investments in established and emerging regions. (Data Centres, Commercial Real Estate, EmergingMarkets, Tech Infrastructure, Rounak Real Estate Consultants)