Codebasics Resume Project Challenge

Your search for resume data projects ends here!

Current Challenge :

Provide Insights to Executive team in Telecom Domain

Deadline :

Dec 17, 2022 6:29 PM

Location :

Online Event

Codebasics Resume Project Challenge #2

1st Prize

Ashish
Babaria

2nd Prize

Naveen S

3rd Prize

Satya Sravani Lakshmi Durga Pilli

3rd Prize

Singaram Harish Kumar
  1. You can use any tool(s) to create and show the output. (Power BI, Excel, Tableau, etc.)
  2. Feel free to search online or talk to subject matter experts to prepare this.
  3. Your submission will be evaluated based on the following criteria
    1. Relevance of the solution to the problem statement
    2. Dashboarding (Usage of these 15 design principles)
    3. Any other relevant Insights provided apart from whatโ€™s being provided in Mock Up
    4. Your summary of 3 things you have learned on domain/function and data analytics while working on this project.
  4. How to submit your final output?
    1. Post it on LinkedIn with a clear screen recording or a public web URL to your dashboard, along with the 3 things you have learned. ( Example Post )
      Don't forget to use the hashtag #codebasicsresumeprojectchallenge
    2. Please submit your solution on the website by simply adding the LinkedIn / GitHub or any other public URL of your final work.

Domain:  Telecom    Function: Executive Management

AtliQo is one of the leading telecom providers in India and launched it’s 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. 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 which 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.  Peter Pandey, a junior data analyst is assigned to this task.

Task:  

Imagine yourself as Peter Pandey and perform the following 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 a minimal idea about dashboarding. Hence you need to represent the insights in a much better way
  2. The target audience of this dashboard is top-level management - hence the dashboard should be self-explanatory and easy to understand
  3. Create relevant insights not provided in the metric list/mock-up dashboard to support the cause.

Other resources Provided:

  1. Metrics List (this contains most of the metrics you need for the dashboard and you might need to create more metrics based on the additional visuals you add in the dashboard)
  2. Metadata

Domain:  Hospitality       Function: Revenue

Atliq Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, Atliq Grands are losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of Atliq Grands wanted to incorporate “Business and Data Intelligence” in order to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights.

Their revenue management team had decided to hire a 3rd party service provider to provide them insights from their historical data.

Task:  

You are a data analyst who has been provided with sample data and a mock-up dashboard to work on the following task. You can download all relevant documents from the download section.

  1. Create the metrics according to the metric list.
  2. Create a dashboard according to the mock-up provided by stakeholders.
  3. Create relevant insights that are not provided in the metric list/mock-up dashboard.

Problem Statement
AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodra. They want to expand to other metro/tier1 cities in the next 2 years.

AtliQ Mart is currently facing a problem where a few key customers did not extend the annual contract due to service issues. It is speculated that some of the essential products were either not delivered on time or not delivered in full over a continued period, which could have resulted in bad customer service. Management wants to fix this issue before expanding to other cities and requested their supply chain analytics team to track the ’On time’ and ‘In Full’ delivery service level for all the customers on a daily basis so that they can respond swiftly to these issues.

The Supply Chain team decided to use a standard approach to measure the service level in which they will measure ‘on-time delivery (OT) %’, ‘In-full delivery (IF) %’ and OnTime in full (OTIF) % of the customer orders on a daily basis against the target service level set for each customer.

Task:  
Peter Pandey is the data analyst in the supply chain team who joined Atliq Mart recently. He has been briefed about the the task in the stakeholder business review meeting. Now Imagine yourself as Peter Pandey and play the role of the new data analyst who is excited to build this dashboard and perform the following task

  1. Create the metrics according to the metrics list.
  2. Create a dashboard according to the requirements provided by stakeholders in the business review meeting. You will be provided with the transcript of this business review meeting in the form of a comic.
  3. Create relevant insights that are not provided in the metric list/stakeholder meeting.

Other resources Provided:

  1. Relevant Business Knowledge & explanations
  2. Metadata
  3. Peter Pandey’s notes taken during the stakeholder meeting
     

A real-time data analytics project to add to your resume.

An opportunity to learn data analytics using business use cases and datasets.

The top 3 submissions will get an attractive prize.

Every qualified submission gets an appreciation certificate.

30% scholarship on our premium courses for all qualified submissions.

For General Queries

Reach out to the Codebasics team at the

Discord Channel