Data Analyst
WX Brands
09.2024 - 12.2024
- Conducted comprehensive data analysis for Bread and Butter, a wine brand entering the Canadian market, over a four-month period.
- Collaborated closely with the regional manager in weekly meetings to define project objectives, share progress, and refine strategies.
- Developed a deep understanding of the EzFocus cloud database, which housed data for various wine companies and brands, despite the absence of metadata.
- Spent weeks learning the structure and nuances of the database with guidance from the regional manager to ensure accurate analysis.
- Utilized Excel to perform initial exploratory data analysis, identifying Bread and Butter’s market position and comparing it against competitors across Ontario, Quebec, and British Columbia.
- Conducted a detailed analysis of promotional spending to determine its impact on sales performance, using Python for correlation analysis, and creating insightful visualizations.
- Calculated ROI for marketing campaigns, providing actionable insights that informed the brand’s pricing and promotional strategies.
- Delivered a final report and presentation to stakeholders, showcasing findings and recommendations to enhance Bread and Butter’s market entry and competitive positioning.
