This repository contains my analysis of a survey conducted by CodeX, a German beverage company, as part of their marketing strategy for entering the Indian energy drink market. The survey aimed to gather insights from 10,000 respondents across 10 cities in India.
The goal of this project is to transform the survey data into actionable insights that can guide CodeX's marketing team in increasing brand awareness, market share, and product development.
The dataset includes responses from a survey distributed in 10 different cities, capturing consumer behavior and preferences regarding energy drinks. The data is divided into three CSV files:
- dim_respondents: Contains demographic information of the respondents.
- dim_cities: Details the cities where the survey was conducted.
- fact_survey_responses: Records the survey responses.
- Data Validation: Checked for inconsistencies or anomalies in the responses.
- Handling Missing Data: Identified and addressed missing values.
- Filtering: Excluded responses that seemed insincere or contradictory.
- Descriptive Statistics: Summarized the data to understand the distribution of responses.
- Segmentation: Analyzed the data based on demographics, consumption patterns, and city tiers.
- Trend Analysis: Identified patterns and trends in consumer behavior.
- Consumer Preferences: Determined the most common reasons for consuming energy drinks.
- Consumption Patterns: Analyzed how often and when people consume energy drinks.
- Market Segmentation: Identified key demographic segments and their preferences.
- Brand Awarness and Perception: Reflects respondents opinions, general attitudes towards Codex's energy drink.
- Product Experience and Preferences: Determines if respondents have tried, taste and explores barriers preventing from trying the drink.
- Market Insights and Consumer Expectations: Gather suggestion for improvement, assesses concerns about the health impacts, nd measures interest in organic energy drinks.
- Marketing and Packaging Preferences: Identifies advertisements, determines packaging designs, explores the appeal of limited edition and establishes the price range for energy drinks.
- Consumption Behavior: Reveals where respondents typically buy and describes situations in which respondents consume energy drinks.
Based on the analysis, provided strategic recommendations for CodeX to target specific consumer segments and tailor marketing campaigns accordingly.
Included various charts and graphs created using Excel and Power BI to illustrate the findings and support the analysis.
Summarized the overall insights and highlighted the potential opportunities for CodeX in the Indian market.
For further discussion on the analysis or collaboration on similar projects, feel free to reach out.