Analyzed the World Roaster Review dataset to uncover key insights and trends in the global coffee market. Utilized SQL to identify the most expensive coffee brands, top-rated roasters, and regional quality differences. Derived actionable recommendations for enhancing product offerings, marketing strategies, and pricing models. This project demonstrates strong analytical skills and ability to provide strategic business decisions.
-
Objective: Our goal is to analyze the World Roaster Review dataset through detailed exploration and advanced analytics, to answer important questions about the coffee market. We'll focus on understanding trends in roaster popularity, consumer preferences for roast types, evaluating roaster performance based on customer feedback and pricing, and predicting future market trends. By using this data effectively, we aim to provide actionable insights that can help stakeholders make informed decisions and improve their strategies.
-
Questions to Explore:
- What is the most expensive coffee per 100g, and what features distinguish it?
- What are the top 5 coffee brands in terms of avg rating?
- Which roaster has received the best reviews in terms of average rating?
- Which country of origin has the highest average rating for coffee?
- Which coffee brand has the best/worst average rating every year?
- How many coffees have a rating above 90?
- Find the average rating for coffee in each selling location.