Hello everyone , this is my submission for resume project challenge 6 conducted by codebasics. 🍽 DOMAIN: Food & Beverage 👨💼 FUNCTION: Marketing
CodeX, a renowned German beverage company, entered the Indian market, conducting a survey with 10k respondents They launched their energy drink in 10 cities in India..
CodeX aims to enhance brand awareness, capture market share, and drive product development. I, as Peter Pandey, utilized data analysis to deliver meaningful insights.
Tools Used :
- SQL
- Power Bi
- PowerPoint
Linkedin Post : https://www.linkedin.com/feed/update/urn:li:activity:7085516547019964416/
Live PowerBI dashboard : https://www.novypro.com/project/codebasics-resume-project-challenge-6--providing-insights-to-the-marketing-team-in-food-and-beverage-industry-for-codex-company
data quetions
Out of the 10k respondents, a significant 60% are male, showing a strong preference for energy drinks.
Over 50% of respondents fall in the age group 19-30, with a 70% representation when considering ages 15-30.
Online ads effectively reach 3373 respondents aged 15-30, making it a prime marketing channel.
Caffeine and vitamins are the most desired ingredients, reflecting consumers' focus on attention and health.
Compact & Portable Cans are in high demand, closely followed by Innovative Bottle Designs.
Cola Coka leads the market, with higher recognition compared to other brands.
Brand reputation stands as the top reason for consumer preference.
Online ads continue to dominate as the most effective channel, offering cost-effective reach.
An average rating of 3.3 reflects a need for improvement in brand perception.
We need to enhance positive brand perception in various cities, particularly by addressing neutral and negative responses.
Supermarkets are the preferred choice for purchasing energy drinks.
Sports/exercise and late-night studying/work are prime consumption situations, with youth as the main consumers.
Consumers tend to buy products priced between 50-99, while 40% are open to limited edition packaging.
Availability and brand perception require immediate attention, with 20% choosing products based on availability.
- Improve product availability.
- Consider health-related aspects in product offerings.
- Experiment with limited edition packaging.
Consumers are willing to pay between 50 to 150 for our product.
- Leverage Social Media and Influencer Marketing.
- Collaborate with local influencers for targeted reach.
- Run exclusive online retail campaigns.
- Explore creative Guerilla Marketing at events.
Choose a celebrity who aligns with our target audience, has influence, and is relevant to our product.
Focus on the age group of 15-30, as they constitute 70% of our consumer base.
Let's transform these insights into impactful actions and drive the success of CodeX in the Indian market!
