Coffee Sales Analysis

This project dives into the coffee sales data from different store locations, product categories, and time periods to uncover what’s really driving sales, what customers love most, and where I can improve operations. Using the dataset from cleaned_coffeesales.csv, I built dashboards, pivot tables, and visual charts to help make smarter, data-backed decisions.

What’s in the Data?
The dataset includes detailed transaction records—dates, times, store locations, product details, quantities sold, and revenue. My goal was to spot patterns like top-selling products, busy hours, how each store performs, and seasonal trends that influence sales.

Why It Matters:

• Spotting Sales Trends: I identify which products, categories, and locations are performing best.
• Understanding Customer Preferences: I see what types of coffee, teas, or baked goods are most popular across regions.
• Streamlining Operations: Recognizing peak hours and days helps optimize staffing and inventory.
• Finding Growth Opportunities: Underperforming segments can be targeted with marketing campaigns or new promotions.

Business Insights & Actionable Tips:

• Refine Your Product Mix: Focus on popular, high-margin items like gourmet brewed coffee and specialty teas.
• Staff Smarter During Peak Times: For example, mornings between 7 and 9 AM see the highest traffic—making sure I have enough staff then is key.
• Tailor Local Strategies: Customize marketing efforts for specific stores, such as Lower Manhattan and Hell’s Kitchen, based on their unique sales patterns.
• Plan Seasonal Promotions: Prepare for busy periods in January and February by highlighting trending products and running special deals.
• Boost Sales with Upselling: Encourage customers to add pastries or snacks to their coffee orders—pairing items can increase the total basket size.

Key Takeaways:

• The top-selling items include Ethiopian Rg, Jamaican Coffee River Rg, along with favorites like scones and croissants.
• Mornings, especially between 7 and 9 AM, are the busiest hours, notably in Lower Manhattan and Hell’s Kitchen.
• Regional tastes differ: Lower Manhattan favors tea and baked goods, while Hell’s Kitchen shows strong coffee and hot chocolate sales.
• Customers tend to prefer organic and sustainably sourced products, especially for coffee and hot chocolates.
• Coffee and hot chocolate dominate beverage sales, with a significant share coming from premium and organic options.

Tools I Used:

• Microsoft Excel for pivot tables and charts
• Data analysis techniques to extract meaningful insights and create reports

Looking Ahead:

• I plan to expand product offerings based on customer preferences.
• I will launch targeted marketing campaigns during peak hours to maximize sales.
• Using real-time dashboards will help me keep a close eye on store performance.
• I’ll also gather customer feedback regularly to refine my product offerings and keep customers coming back.