This project aims to analyze customer preferences for ice cream flavors using a structured data lifecycle approach. The goal is to help an ice cream company understand customer trends and improve decision-making. The dataset was provided by the manager, and the analysis is based on real customer data.
The company needs to understand its customers' ice cream preferences. To achieve this, we collect the following data:
- Date & Time – When the ice cream was purchased.
- Flavor – The type of ice cream bought.
- Price – The cost of the ice cream.
- Reason – If the customer provided a reason for their purchase.
- Customer Age – To analyze preferences by age group.
- Customer Location – Includes latitude and longitude.
- Rating – Customer rating (1-5) for the ice cream flavor.
Expected Insights:
✅ Popular flavors by season, age, and location.
✅ Price impact on sales.
✅ Customer satisfaction trends.
- Data is collected at the point of sale.
- Customers are asked if they are willing to provide details.
- The location data is retrieved based on the store's location.
- The data is stored in a MySQL relational database for structured querying.
- Secure access controls are implemented to protect sensitive information.
- Regular backups are maintained to prevent data loss.
- Tools Used: MySQL, Tableau.
- Analysis Performed:
- Popular flavors among different age groups.
- Trends in ice cream sales based on time, season, and location.
- Customer satisfaction ratings and feedback.
- Heatmap of ice cream purchases by region.
- Data older than 3 years is archived for historical reference.
- Summarized reports are generated for long-term insights.
- Older datasets are stored in seperate Hard Drives for cost-effective storage.
- Data is deleted if it is no longer needed for analysis.
- Personal customer details are anonymized before deletion.
- Secure deletion methods (e.g., data wiping) are used to ensure compliance with regulations.
We created a Customer Rating Analysis Dashboard in Tableau to visualize the findings.
🔗 View the Dashboard Here: Ice Cream Sales Dashboard
- The most popular ice cream flavors based on location.
- Which age groups eats most in which area.
- Heatmaps of sales locations to identify high-demand areas.
- Seasonal Trends for flavors in different locations.
This project provides valuable insights into customer ice cream preferences using a structured data analysis approach. The findings can help the company optimize flavors, pricing, and marketing strategies based on real customer behavior.
✅ If you found this project useful, star this repo ⭐ and contribute with suggestions!