/Atliqo_Telecom_Resume_Challenge

This project requires us to show a comparison report of KPIs between pre and post-periods of 5G launch. The report is to be shown to the executive team of AtliQo in the form of a PowerBI dashboard.

Atliqo Telecom Resume Project Challenge-3

Problem Statement :

AtliQo is one of the leading telecom providers in India and launched its 5G plans in May 2022 along with other telecom providers. However, the management noticed a decline in their active users and revenue growth post 5G launch in May 2022.

Approach to solve the problem :

AtliQo’s business director requested their analytics team to provide a comparison report of KPIs between pre and post-periods of the 5G launch. The management is keen to compare the performance between these periods and get insights that would enable them to make informed decisions to recover their active user rate and other key metrics. They also wonder if they can optimize their internet plans to get more active users.

Task :

  1. Create the comparison report based on the mock-up provided. Please note the mock-up is created by a business user who has minimal idea about dashboarding. Hence, you need to represent the insights in a much better way. The target audience of this dashboard is top-level management - hence the dashboard should be self-explanatory and easy to understand.

  2. Create relevant insights not provided in the metric list/mock-up dashboard to support the cause.

Dashboard

Screenshot 1 Screenshot 2023-03-18 140416 Screenshot 2023-03-18 141044

Dataset/Problem Files

Download here : Codebasics Resume Challenge 3

Linkedin Post

Post