Hello everyone! 🌟 It brings me immense joy to unveil my submission for the dynamic “Data Analysis Resume Project Challenge 6” hosted by codebasics. 🚀 This journey has been a true testament to the power of learning, growth, and the excitement of unraveling insights from data.
Domain: F & B Function: Marketing
CodeX is a German beverage company 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 that the team can use to drive actions
Task Completed
- Demographic Insights
Key Insights:
1.1 Among 10 thousand respondents, 6038 are male, indicating a 60% preference for energy drinks.
1.2 Survey results reveal energy drinks’ popularity among youngsters, with over 50% aged 19–30; considering ages 15–30 raises the percentage to 70%
- Consumer Preferences:
Key Insights:
2.1 Caffeine, known for enhancing attention and alertness, is the primary anticipated ingredient in energy drinks, closely followed by vitamins
2.2 Compact & Portable Cans are in high demand, trailed by Innovative Bottle Designs.
- Competition Analysis:
Key Insights:
3.1 The top reason for choosing the brands by consumers is brand reputation.
3.2 “Sky9” is notably effective, “Gangster” is remarkably healthy, while “Bepsi” raises concerns for being more dangerous
- Marketing Channels and Brand Awareness:
Key Insights:
4.1 Online ads prove highly effective for reaching a wide audience swiftly and economically, as observed earlier
Key Insights
5.1 Among 980 individuals, 455 are familiar with our brand, aligning their average taste rating of 3.3 with the industry average
- Purchase Behavior:
Key Insights
6.1 Supermarkets are the predominant choice for consumers purchasing energy drinks.
6.2 Sports, exercise, and studying/working late; this data underscores greater youth consumption.
6.3 40% of consumers anticipate no packaging change, while 39% are receptive to experimenting with Limited Edition Packaging.
- Product Development
Key Insights
7.1 We should increase Effectiveness
7.2 We should improve and Reduce Sugar Content
Thank you for taking the time to read the PROJECT. I appreciate your attention and feedback.”