Welcome to the Coffee Market Orders Data Analytics repository. This project involves analyzing the orders data of a coffee market using Microsoft Excel. The dataset comprises three primary tables: orders, customers, and products. The main objective is to create an insightful dashboard that illuminates various aspects of the coffee market's performance.
- Order Date
- Customer ID
- Product ID
- Quantity
- Customer ID
- Customer Name
- Phone Number
- Address Line 1
- City
- Country
- Postcode
- Loyalty Card
- Product ID
- Coffee Type
- Roast Type
- Size
- Unit Price
- Price per 100g
- Profit
The Excel dashboard provides detailed insights into various aspects of the coffee market orders:
-
Sales Overview
- Tracks the Total Sales Over Time, breaking down by Months and Years.
-
Roast Types Analysis
- Presents a comprehensive Sales Breakdown categorized by Roast Type (Dark, Light, Medium).
-
Size Analysis
- Analyzes the Sales Breakdown based on Size (in kgs).
-
Loyalty Card Impact
- Compares Loyalty Card Sales with Non-Loyalty Card Sales to gauge the impact of loyalty programs.
-
Geographic Analysis
- Displays Sales by Country, providing a geographical perspective on market performance.
-
Top Customers
- Identifies the Top 5 Customers based on their Total Sales contribution.
 |
| Dashboard |
 |
| Dashboard |
- Download the Excel File: Obtain the Excel file
dashboard.xlsx. - Open in Microsoft Excel: Launch the file using Microsoft Excel.
- Navigate to Dashboard: Explore the comprehensive analytics on the "Dashboard" sheet.
For the live experience, visit https://shib1111111.github.io/Coffee-Market-Analytics/
We welcome contributions to enhance this project. Feel free to open issues or submit pull requests.
This project is licensed under the MIT License.
Thank you for your review! Feel free to reach out with any questions or feedback.
✨ --- Designed & made with Love by Shib Kumar Saraf ✨