Analyse historical IPL data and provide insights on IPL 2024 for a sports magazine

Domain:  FMCG       Function: Sales / Promotions

AtliQ Mart is a retail giant with over 50 supermarkets in the southern region of India. All their 50 stores ran a massive promotion during the Diwali 2023 and Sankranti 2024 (festive time in India) on their AtliQ branded products. Now the sales director wants to understand which promotions did well and which did not so that they can make informed decisions for their next promotional period.  

Sales director Bruce Haryali wanted this immediately but the analytics manager Tony is engaged on another critical project. Tony decided to give this work to Peter Pandey who is the curious data analyst of AtliQ Mart. Since these insights will be directly reported to the sales director, Tony also provided some notes to Peter to support his work.

Task: 

Imagine yourself as Peter Pandey and perform the following task to keep up the trust with your manager Tony Sharma. 

1. Go through the metadata and analyze the datasets thoroughly. This is the most fundamental step. 
2. Check “Recommended Insights.pdf” – this document contains a few recommendations from your manager Tony.  
3. Design a dashboard with your metrics and analysis. The dashboard should be self-explanatory and easy to understand.
4. Check “ad-hoc-requests.pdf” - this document includes important business questions posed by senior executives, requiring SQL-based report generation.
5. You need to present this to the sales director - hence you need to create a convincing presentation with actionable insights.  
6. You can add more research questions and answer them in your presentation that suits your recommendations.  
7. Be creative with your presentation, audio/video presentation will have more weightage.   

Other resources Provided:

• Dataset required to answer preliminary research questions.
• Metadata
• Supporting documents

Note:

• We recommend you create a video presentation of ideally 15 minutes or less for the business stakeholders. Additionally, make a LinkedIn post that includes relevant links, your video presentation, and a reflection on your experience while working on this challenge.
• You can check out this example presentation to gain some inspiration: Sample Presentation Link
• After completing your linkedIn post, please submit the link in the input box provided below.

Download Problem Files

Domain:  Banking       Function: Strategy

Mitron Bank is a legacy financial institution headquartered in Hyderabad. They want to introduce a new line of credit cards, aiming to broaden its product offerings and reach in the financial market. 

AtliQ Data Services came to know about this through an internal link and approached Mitron Bank with a proposal to implement this project. However, the strategy director of Mitron Bank, Mr. Bashnir Rover is skeptical and asked them to do a pilot project with the sample data before handing over them the full project. They provided a sample dataset of 4000 customers across five cities on their online spending and other details. 

Peter Pandey is a data analyst at AtliQ Data Services and was asked by his manager to take over this project. His role is to analyse the provided sample data and report key findings to the strategy team of Mitron Bank. This analysis is expected to guide them in tailoring the credit cards to customer needs and market trends. 

The successful acquisition of this project depends on Peter's ability to provide actionable, data-driven recommendations and impress Mr. Bashnir Rover & his team. Peter requested support from his manager Tony Sharma, and he provided him with some ideas to generate insights based on the data provided. 

Task:

Imagine yourself as Peter Pandey and perform the following task.

1. Use “Insight Ideas from Tony.pdf”. Create metrics and visuals accordingly.
2. Design a dashboard with your metrics and analysis. The end users of this dashboard are top-level management and product strategy team - hence the dashboard should be self-explanatory and easy to understand.
3. Present your insights to Mr. Bashnir Rover & team. Be creative and concise with your presentation.
   Use your dashboard in the presentation along with the deck.
4. Use additional data based on your own research to support your recommendations. 

Other resources Provided:

• Dataset required to generate Insights
• Metadata
• Supporting documents

Note:

• We recommend you create a video presentation of ideally 15 minutes or less for the business stakeholders. Additionally, make a LinkedIn post that includes relevant links, your video presentation, and a reflection on your experience while working on this challenge.
• You can check out this example presentation to gain some inspiration: Sample Presentation Link
• After completing your linkedIn post, please submit the link in the input box provided below.

Download Problem Files

Telangana is one of the fastest-growing states in India and one of the states with an open data policy. (They have published all their data online)

Peter Pandey is an aspiring data analyst looking for a project with real-time data to add to his portfolio. He wanted to analyse Telangana’s growth among different sectors quantitatively and provide useful Insights to the Telangana government that would help them to make data-informed decisions that would further support the growth of the state.

Peter Pandey began this project by drafting some of the key objectives for this analysis.

Task:

Imagine yourself as Peter Pandey and perform the following task.

1. Check ‘research_questions_and_recommendations.pdf’. You can use any tool of your choice (Python, SQL, PowerBI, Tableau, Excel, PowerPoint) to analyze and answer these questions. More instructions are provided in this document.
2. Please ensure that all the insights are appropriately visualized and mapped on the Telangana district map, which will be provided as part of the input file -> ‘shape file_example.mp4’. 
3. The target audience is top-level management - hence you need to create a convincing presentation to provide insights/recommendations. Be creative with your presentation, audio/video presentation will have more weightage.
4. You can use additional data based on your own research to support your recommendations.
5. Example LinkedIn post
6. Present Insights to Stakeholders and notify them. Instructions are provided in the ‘How to Notify Stakeholders.pdf’. (Important!)

Other resources Provided:

• Dataset required for analysis.
• Telangana district map (.json)
• Metadata
• Instructions for using dataset and district map.

Benefits of this challenge:

• Every successful submission to get a joint appreciation certificate from codebasics and Open Data Telangana
• Top 5 winners to get a letter of recognition from Open Data Telangana 
• Internship Possibilities with Open Data Telangana

Credits: The dataset is taken from Open Data Telangana. Thanks to the Telangana Government for providing real-time datasets for public access which is a great learning asset - feel free to explore them here. (https://data.telangana.gov.in/). 

Download Problem Files

Domain: F & B   Function: Marketing  

CodeX is a German beverage company that is aiming to make its mark in the Indian market. A few months ago, they launched their energy drink in 10 cities in India.

Their Marketing team is responsible for increasing brand awareness, market share, and product development. They conducted a survey in those 10 cities and received results from 10k respondents. Peter Pandey, a marketing data analyst is tasked to convert these survey results to meaningful insights which the team can use to drive actions.

Task:

Imagine yourself as Peter Pandey, and do the following tasks,

1. Check the “Primary_Secondary_Insights.pdf” and answer the questions by analyzing the data provided. You can use any tool of your choice (Python, SQL, PowerBI, Tableau, Excel, PowerPoint).
2. You can add more research questions and answer them in your presentation that suits your recommendations.
3. The target audience is the Chief Marketing Officer, you have 15 minutes to present insights to him. Make a concise presentation.
4. Be creative with your presentation, audio/video presentation will have more weightage.
5. You can use additional data based on your own research to support your recommendations
6. Please note that it is possible that some respondents might not have answered all the questions sincerely. For instance, a person is more likely to have not tasted the drink if they haven’t heard about it. Sense-check the data and use your judgment to clean it as required.
7. Example LinkedIn post

Other resources Provided:

• Dataset required to generate Insights
• Metadata
• Survey questions
   

Download Problem Files

Domain:  Tourism | Function: Revenue / Municipal Administration

Telangana is one of India’s leading states and has published its tourism data under its open data policy.

As a data analyst, Peter Pandey saw this as an opportunity to expand his skills and show his work on a bigger scale. Peter Pandey’s idea is to find the patterns in the given data, do additional research, and give data-informed recommendations to the Telangana government which can be used to increase their revenue by improving administrative operations.
 
Peter began his work by framing some primary, and secondary research questions and recommendation ideas.

Task:

Imagine yourself as Peter Pandey and perform the following task.

1.    Check ‘research_questions_and_recommendations.pdf’. You can use any tool of your choice (Python, SQL, PowerBI, Tableau, Excel, PowerPoint) to analyze and answer these questions. More relevant instructions are provided in this document.
2.    The target audience is top-level officials - hence you need to create a convincing presentation to provide insights/recommendations.
3.    You can add more research questions and answer them in your presentation that suits your recommendations.
4.    Be creative with your presentation, audio/video presentation will have more weightage.
5.    You can use additional data based on your own research to support your recommendations
6.    Example LinkedIn post 

Other resources Provided:

a.    Dataset required to answer preliminary research questions.
b.    Metadata
c.    Instructions for using dataset.
d.    Sample Presentation

Credits: The dataset is taken from Open Data Telangana. Thanks to Telangana Government for providing real-time datasets for public access which is a great learning asset - feel free to explore them here. (https://data.telangana.gov.in/). 

Download Problem Files

Domain:  Consumer Goods | Function: Executive Management

Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too.

However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. They want to expand their data analytics team by adding several junior data analysts. Tony Sharma, their data analytics director wanted to hire someone who is good at both tech and soft skills. Hence, he decided to conduct a SQL challenge which will help him understand both the skills.

Task:  

Imagine yourself as the applicant for this role and perform the following task

1.    Check ‘ad-hoc-requests.pdf’ - there are 10 ad hoc requests for which the business needs insights.
2.    You need to run a SQL query to answer these requests. 
3.    The target audience of this dashboard is top-level management - hence you need to create a presentation to show the insights.
4.    Be creative with your presentation, audio/video presentation will have more weightage.

Other resources Provided:

a.    Dataset required to provide 
b.    Metadata
c.    Hints (try not to use the hints to develop your skills quicker)
d.    Sample questions and Presentation
 

Download Problem Files

Domain:  Telecom    Function: Executive Management

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. 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.  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 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 to the dashboard)
2. Metadata

Download Problem Files

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

AtliQ Mart is currently facing a problem where a few key customers did not extend their annual contracts 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 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 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 comic form.
3. Create relevant insights 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
    

Download Problem Files

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” 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 with 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.

Download Problem Files