Analyse Growth and Present Insights to the Telangana Government

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