Marketing Insights Analysis

I created a Power BI report that involved the implementation of DAX measures. Additionally, I utilized Power Query to prepare the clean data for Power BI, which streamlined the entire process.

Overall, this project showcases my proficiency in using Excel, Power Query, and DAX to create comprehensive and dynamic Power BI reports that provide valuable insights for marketing analysis.

✅ Skills used in the project include:

• Data Cleaning
• DAX & Calculated Columns
• Creation of Different Charts such as Heat maps, Funnel Charts, Area charts, Tree maps, etc.
• Creation of Slicers
• Creation of Measures
• Design and Development of Dashboard

📌 Key Insights:

1. Working on product availability is important, as the availability rate is only 20%. Out of the people who have heard about the product (46.43%), only 21.84% have tried it before.

2. The second main focus should be on health. Out of the 9.79% of customers, 5.91% have health concerns, with many desiring reduced sugar and more natural ingredients. Additionally, 32.65% want the product while studying and working late, and 45.92% want it for sports/exercise to increase focus, and energy, and combat fatigue.

3. The target audience should be college and school-goers aged between 15-30.

4. Customer satisfaction rate is 3.27, which is lower than most of the competitors.

5. 60% of the consumers are male, and they prefer energy drinks more.

6. The major focus should be on tier 2 cities.

7. The most expected ingredient is caffeine.

8. The preferred price range is between 50-99.

9. The most wanted marketing channel is online ads, followed by TV commercials.

10. The most desired purchase location is a supermarket, followed by online retailers.

11. The preferred packaging is compact and portable cans, followed by innovative bottle designs.