About Dataset

Dataset Source

Kaggle - Coffee Orders

View Dataset on Kaggle

Dataset Description

  • 1,000 customers' sales transactions
  • 14 columns including date, product, price, location
  • Time period: January 2019 - December 2022

Problem Statement

Analyze coffee sales data to identify seasonal trends, product performance, and regional market opportunities to optimize inventory management and marketing strategies.

Analytics Questions

What are the seasonal patterns in coffee sales?

Which coffee products generate the highest revenue?

How do sales vary across different regions?

Resources Used

Languages

  • Python
  • SQL

Libraries

  • Pandas
  • Matplotlib
  • Seaborn
  • Numpy

Tools

  • Excel
  • Tableau

Source Code

View Project on GitHub

Data Cleaning & Transformation

Missing Values

Identified and handled null values in price and quantity columns

Duplicates

Removed 52 duplicate transactions

Data Types

Converted date strings to datetime format

Data Visualizations

Coffee Type Sales Trends

Line graph showing sales trends for different coffee types over time from 2019 to 2022

Execlsa beans lead in total sales and have been consistently popular, though showing signs of declining interest. Meanwhile, Arabica and Liberica beans have gained traction, with Robusta maintaining steady performance.

Overall Monthly Sales Performance

Line graph displaying total monthly sales from 2019 to 2022

Sales peak during mid-January to March, likely driven by colder weather.  Conversely, sales drop significantly during the summer months.

Product Profitability Ranking

Bar chart showing profit rankings for different coffee products

Liberica beans (e.g., product codes L-L-2.5 and L-M-2.5) rank among the most profitable items. Certain Execlsa products also exhibit high profitability margins.

Geographic Sales Distribution

Bar chart showing sales distribution across different countries

The United States is the dominant market, accounting for the largest share of sales.

Recommendations

  • Winter Strategy: Introduce promotions like "Buy One, Get One Free" or launch seasonal latte menus to boost winter sales. Highlight comforting and warm beverages such as flavored lattes or hot mochas. Summer Strategy: Counter the seasonal dip by promoting refreshing options such as iced coffees, cold brews, and innovative offerings like coffee slushies.

  • Leverage the growing popularity of Arabica and Liberica by introducing new blends or signature drinks featuring these beans. Develop and market unique blends incorporating Robusta to revitalize interest in lesser-promoted varieties.

  • Capitalize on the U.S. market potential by implementing region-specific promotions and advertising campaigns. Explore opportunities for digital marketing and loyalty programs tailored to U.S. customers to further drive engagement and sales.