Conduct Product Market Fit Research for Air Purifier Development Using AQI Analytics

"Business Basics" is a business blogging company that has established a strong following in the business content space. Considering the negative sentiment from viewers on the fact that more than 50% of the IPL advertisements are occupied by fantasy apps and pan masala ads, they want to release an edition focusing on the dual impact of IPL 2025: its massive economic footprint and its potential social/health implications. This magazine aims to provide a balanced analysis of how IPL drives economic growth while also examining the potential consequences of certain advertising practices during the tournament.

The chief editor Tony Sharma oversees this publication and believes that a comprehensive understanding of IPL's impact requires looking beyond just cricket statistics to the business ecosystem and social responsibility aspects. He has reached out to Peter Pandey, a journalist in his team who specializes in business analytics. Peter has received preliminary unstructured data scraped by using tools like perplexity.

Download Problem Files

Lio, a leading telecommunications provider in India, is planning a strategic merger with Jotstar, one of the country’s most prominent streaming platforms. This potential partnership aims to combine LioCinema’s expansive subscriber base and Jotstar’s diverse content library to revolutionize digital streaming in India.  

As part of the merger preparation, the management team at Lio wants to analyse the performance and user behavior of both platforms— LioCinema and Jotstar—over the past one year (January to November 2024). The goal is to gain insights into individual platform performance, content consumption patterns, subscriber growth, Inactivity behavior, upgrade and downgrade trends. The insights derived from this study will help the management make informed decisions and optimize content strategies post-merger, with the ultimate goal of establishing Lio-Jotstar as the leading OTT platform in India.  Peter Pandey is the data analyst at Lio, and he is tasked to analyse the data and provide insights.  

The management expects detailed insights into the following:  

1. Content Library Analysis: A detailed comparison of content types across both platforms.  
2. Subscriber Insights: Analyse trends in subscriber acquisition and demographic variations.   
3. Inactivity Analysis: Patterns of inactivity across age groups, city tiers, and subscription plans.    
4. Upgrade Patterns: Insights into subscription upgrades and their influencing factors.   
5. Downgrade Patterns: Analysis of subscription downgrades and associated trends.   
6. Content Consumption Behavior: Patterns in total watch time, device preferences, and variations by user demographics.   

Download Problem Files

Goodcabs, a cab service company established two years ago, has gained a strong foothold in the Indian market by focusing on tier-2 cities. Unlike other cab service providers, Goodcabs is committed to supporting local drivers, helping them make a sustainable living in their hometowns while ensuring excellent service to passengers. With operations in ten tier-2 cities across India, Goodcabs has set ambitious performance targets for 2024 to drive growth and improve passenger satisfaction. 

As part of this initiative, the Goodcabs management team aims to assess the company’s performance across key metrics, including trip volume, passenger satisfaction, repeat passenger rate, trip distribution, and the balance between new and repeat passengers. 

However, the Chief of Operations, Bruce Haryali, wanted this immediately, but the analytics manager, Tony, is engaged in another critical project. Tony decided to give this work to Peter Pandey who is the curious data analyst of Goodcabs. Since these insights will be directly reported to the Chief of Operations, Tony also provided some notes to Peter to support his work. 

Download Problem Files

AtliQ Motors is an automotive giant from the USA specializing in electric vehicles (EVs). In the last 5 years, their market share rose to 25% in the electric and hybrid vehicles segment in North America. As a part of their expansion plans, they wanted to launch their bestselling models in India, where their market share is less than 2%. Bruce Haryali, the chief of AtliQ Motors India, wanted to do a detailed market study of the existing EV/Hybrid market in India before proceeding further. Bruce gave this task to the data analytics team of AtliQ Motors, and Peter Pandey is the data analyst working in this team. 

Download Problem Files

AtliQ Media is a private media company and they wanted to telecast a show on Lok Sabha elections 2024 in India. Unlike other channels they do not want to have a debate on who is going to win this election, they rather wanted to present insights from 2014 and 2019 elections without any bias and discuss less explored themes like voter turnout percentage in India.  Peter is a data analyst in the company, and he is handed over this task of generating meaningful insights from data. Since this is a sensitive topic, he seeked help from his manager Tony Sharma who provided the list of primary and secondary questions.

Download Problem Files

"Sports Basics" is a sports blog company that entered space recently.  They wanted to get more traffic to their website by releasing a special edition magazine on IPL 2024.  This magazine aims to provide interesting insights and facts for fans, analysts and teams based on the last 3 years' data.

The chief editor Tony Sharma oversees this publication, and he believes in data analytics. He reached out to Peter Pandey, a journalist in his team who is a data-savvy cricket enthusiast. 

Download Problem Files

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.

Download Problem Files

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. 

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.

Download Problem Files

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.

Download Problem Files

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.

Download Problem Files

AtliQ Hardwares (imaginary company) is one of the leading computer hardware producers in India and has expanded well 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 good at both tech and soft skills. Hence, he decided to conduct a SQL challenge, which will help him understand both skills.

Download Problem Files

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.

Download Problem Files

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 have not extended 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. 

Download Problem Files

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.

Download Problem Files