Indian Telecom sector subscriber and revenue analysis
owerBI is the most useful Business Analytics tool for Visualization and modeling, so we have done advanced visualization in PowerBI. From the graphs below we can analyze circle-wise subscribers and Average revenue per month for a particular telecom company for each year.
The highlighted small slices represent Aircel Limited in the above graph, Also we have cross verified with one 2013 blog on the internet that says that Until October 31, 2012, Aircel had 7.70 lakh connections in the Gujarat circle. The number, however, came down drastically to 35,773 by the end of April 2013.