Tools Utilized: Excel, R
Project Background
Did you know? The U.S. leads the world in annual coffee consumption, with a staggering 1.6 billion pounds consumed. Brazil is a close second, consuming 1.3 billion pounds, while Japan ranks third with 443 million pounds.
Given the competitive landscape of the coffee industry, understanding customer preferences and sales dynamics is crucial for driving growth and maintaining market share.
This project focuses on analyzing a comprehensive dataset of coffee bean sales to uncover insights that can inform strategic decision-making.
Project Scope
Problem Statement
How can the sales performance of coffee beans be optimized by analyzing order trends, roast preferences, customer loyalty, and geographical distribution?
Method
Data Cleaning & Preparation
Data Visualization
Hypothesis Testing & Analyses
Key Research Insights
Quarters 1 and 4 appear to be peak times for ordering coffee beans throughout the year, averaging 24.58 and 24.89 orders per month respectively.
In this dataset, purchases were evenly distributed across roast types. However, Arabica stood out as the most popular coffee type, totaling 264 orders.
Loyalty card holders do not have a significant impact on sales. Surprisingly, non-card holders accounted for $24,216.42 of total sales, whereas card holders accounted for $20,917.85 of total sales.
The United States leads with total sales of $35,638.89, followed by Ireland with $6,696.87 and the United Kingdom with $2,798.51.
The top 5 customers based on sales are Allis Wilmore ($317.07), Brenn Dundredge ($307.05), Terri Farra ($289.11), Nealson Cuttler ($281.68), and Don Flintiff ($278.01).
There is no statistically significant difference in roasts among the different seasons.
Next Steps
Target Marketing Efforts: Given that Quarters 1 and 4 are peak times for ordering coffee beans, consider increasing marketing efforts and promotions during these periods to capitalize on higher demand.
Optimize Loyalty Program: Despite non-card holders contributing more to total sales, evaluate the loyalty program's effectiveness. Consider enhancing benefits for card holders or implementing targeted campaigns to increase their engagement and sales contribution.
Market Expansion Strategy: With the United States leading in total sales, explore opportunities to expand operations or marketing strategies in other high-performing regions such as Ireland and the United Kingdom.
Customer Relationship Management: Focus on nurturing relationships with top customers identified by sales. Consider personalized communication, loyalty rewards, or exclusive offers to maintain and potentially increase their patronage.
Collect Feedback: Gather feedback from customers regarding their preferences, satisfaction with products and services, and suggestions for improvements. Use this information to refine strategies and offerings accordingly.
Taking these proactive steps will optimize operations, enhance customer satisfaction, and drive growth in the coffee bean sales business.