CodeX: Data-Driven Beverage Insights

Project Overview

CodeX is a comprehensive market analysis project for a German beverage company that launched its energy drink in 10 Indian cities. Here the goal is to extract meaningful insights from survey responses of 10,000 respondents to develop actionable marketing strategies aimed at boosting brand awareness, market share, and product development.

Key Insights

• Demographic Analysis:
  • Gender preferences for energy drink consumption
  • Age group demographics showing highest product adoption
  • Most effective marketing channels for reaching youth (15-30)
• Consumer Preferences:
  • Preferred ingredients in energy drinks
  • Packaging preferences and impact on purchase decisions
  • Consumption situations and typical usage patterns
• Competition Analysis:
  • Current market leaders in the energy drink segment
  • Reasons behind consumer brand preferences
  • Competitive advantages and opportunities
• Marketing Effectiveness:
  • Best performing marketing channels
  • ROI analysis of different marketing strategies
  • Brand penetration across different cities

Live Dashboard

Technical Implementation

The project leverages Power BI for data visualization and analysis. Key technical aspects include:

• Advanced measures using calculate functions with specific filters
• Custom color palette selection from Color Hunt
• Strategic graph selection based on data types and demographic factors
• Interactive tooltips and column filters for enhanced data exploration
• Intuitive page navigation for seamless insights browsing

Results & Recommendations

The analysis provided actionable insights for CodeX, including:

• Immediate product improvement opportunities
• Optimal pricing strategy based on market analysis
• Effective marketing campaign recommendations
• Suitable brand ambassador proposals
• Target audience refinement strategies