This project presents an interactive coffee sales dashboard built using Microsoft Excel. The dashboard provides insights into sales performance, customer behaviour, and product trends over time.
The goal of this project is to analyse coffee sales data to identify trends, top 5 customers, and key business drivers. The dashboard enables users to explore data interactively and support data-driven decision making.
Microsoft Excel Power Query Pivot Tables Pivot Charts Slicers & Timeline Data Cleaning & Transformation XLOOKUP
Sales show strong fluctuations over time with peak value of $843 in Jan 2022 for Liberica. Allis Wilmore is the top customer in term of sales. Arabica and Robusta are the most dominant coffee types. The United States generates the highest sales among all countries. Customer segmentation (loyal vs non-loyal) impacts purchasing behaviour.
