top of page

Pre vs. Post 5G Launch Performance Comparison Report

Aim

  • Evaluate Pre and Post 5G launch performance

Tools & Skills

  • Microsoft Power BI

  • Power Query

  • Data Cleaning

  • Data Analysis

  • Data Visualization

  • DAX

The comparison analysis revealed that: 

  • Total revenue declined by 0.5% after the 5G launch.

  • Average monthly revenue also dropped by 0.5% post-launch.

    • 9 out of 15 cities followed this declining trend in both total and average monthly revenue.

    • However, 6 cities — Delhi, Kolkata, Chennai, Hyderabad, Ahmedabad, and Chandigarh — recorded slightly higher revenues after the 5G launch.

  • ARPU (Average Revenue Per User) saw a notable increase of 11% post-5G.

    • Chennai and Pune were the only cities where ARPU decreased after the 5G rollout.

    • On a month-by-month basis, ARPU values post-5G are generally higher compared to the pre-launch period.

Explore the Dashboard

Interact and explore the dashboard here

bottom of page