Providing Insights To the Marketing Team of CodeX- (Food And Beverage Industry)

 Project Details

CodeX is a German beverage company that is aiming to make its mark in the Indian market. A few months ago, they launched their energy drink in 10 cities in India. I, a marketing data analyst was tasked to convert these survey results into meaningful insights that the team could use to drive actions.




In my role as a Marketing Data Analyst, I worked on a survey with responses from 10,000 people across 10 cities. My task was to transform these survey results into valuable insights:

Excel: I explored the data using Excel.

Power BI: Another tool I used was Power BI to create clear and engaging charts and graphs. This aided the Marketing team in better understanding the data and making informed decisions.

These insights played a key role in guiding smart decisions for the Marketing team. This project not only contributed to our data skills but also showcased how data influences important choices in the marketing world.




Live Dashboard

LinkedIn Post

Comments

Post a Comment

Popular posts from this blog

Ad-hoc Insights (Consumer Goods Domain)

Projects Details   AtliQ Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they did not get enough insights to make quick and smart data-informed decisions. Hence, the company decided to conduct an SQL challenge. As part of the SQL Project Challenge, I successfully completed a project with the following key highlights: 1.SQL: Utilized advanced SQL concepts such as Subqueries, Multiple Joins, Common Table Expressions (CTE), and Window Functions to query the database effectively. 2. Power BI: Employed Power BI to visualize the extracted data, creating visuals like Bar Charts, Line Charts, and Donut Charts. These visuals were instrumental in clearly communicating insights derived from the data. Using my skills, I efficiently handled and analyzed database information. Applying these concepts, I turned raw data into useful insights, playing a key role in shaping the company's strategic de...
Read more

Generate Insights to Solve a Supply Chain Issue in the FMCG Domain

Project Details Tools Used: Data Visualization: Power BI Database: MS Excel Problem Statement: AtliQ Mart, a growing FMCG manufacturer in Gujarat, India, faces challenges in retaining key customers and aims to expand to other cities in the next two years. The company has identified service issues, leading to non-renewal of contracts by some key customers. To address this, the supply chain analytics team is tasked with tracking the 'On Time' and 'In Full' delivery service levels for all customers daily. The goal is to swiftly respond to issues and ensure customer satisfaction. Task: As the data analyst in the supply chain team, I was tasked to build a dashboard that measures 'On-Time Delivery (OT) %,' 'In-Full Delivery (IF) %,' and 'On-Time In Full (OTIF) %' against the target service levels for each customer. The objective is to provide insights and solutions to improve customer service. I have created relevant metrics, and a dashboard, and un...
Read more
Image
I am excited to share that I have successfully completed all three levels of SQL certification on HackerRank - Basic, Intermediate, and Advanced. Throughout this journey, I strengthened my understanding of: Basic SQL: SELECT statements, filtering, sorting, and aggregations Intermediate SQL: JOINs, subqueries, grouping, Advanced SQL: Window functions and complex query optimization These skills have helped me improve the way I analyze data, build logic, and solve real-world business problems. Looking forward to applying this knowledge in future data projects! hashtag # SQL hashtag # HackerRank hashtag # DataAnalyst Linkedin Post
Read more