The coffee bean sales data spanning four years provides a comprehensive insight into the coffee industry, encompassing sales figures, customer demographics, and product details. This dataset serves as a valuable resource for understanding consumer behavior, refining product offerings, and enhancing business strategies within the coffee market.
Orders Worksheet:
-Order ID: A unique identifier for each coffee order.
-Order Date: The date when the order was placed.
-Customer ID: An identifier linking the order to a specific customer.
-Product ID: A unique identifier for each coffee product.
-Quantity: The quantity of the coffee product ordered.
Customers Worksheet:
-Customer ID: A unique identifier for each customer.
-Customer Name: The name of the customer.
-Email Address: Contact information for customers.
-Phone Number: Another contact detail for customers.
-And more: Explore a wide range of customer attributes for segmentation and analysis.
Products Worksheet:
-Product ID: A unique identifier for each coffee product.
-Coffee Type: The type or blend of coffee, such as Arabica or Robusta.
-Roast Type: The roast level, including light, medium, or dark roast.
-Size: Information about the product size.
-Unit Price: The price of a single unit of the coffee product.
-Price Per 100g: The price per 100 grams for detailed price comparisons.
-Profit: Insights into the profitability of each coffee product.
-The United States consistently leads in total coffee sales, generating $35,639 in revenue, outpacing Ireland ($6,697) and the UK ($2,799).
-Among the top five transactions, ranging from $317 to $278, four were made by American buyers.
-Sales without loyalty cards amounted to $24,216, while purchases with loyalty cards totaled $20,918.
-Sales of Robusta coffee beans remained relatively low from 2019 to 2021.
-Excelsa coffee recorded the highest sales between 2019 and 2020.
-Irish customers with loyalty cards tended to purchase more coffee beans compared to those without.
These insights highlight the significance of targeting American consumers, who exhibit a strong propensity to purchase large quantities of coffee. Focusing sales efforts and promotional activities in the US can further solidify the company's customer base. Additionally, exploring opportunities in the UK and Ireland may unveil potential for growth in these markets. Despite variations in sales across different bean and roast types, there's no compelling evidence to discontinue any existing products.