Objective The project aimed to create a comprehensive sales dashboard for a coffee shop using Excel, providing key insights into sales performance, customer behavior, and product trends.

Key Features Total Sales Analysis:

Aggregated total sales by year, month, and coffee type. Insights into the best-performing months and types of coffee, such as Arabica, Excelsa, Liberica, and Robusta. Country-wise Sales:

Sales data segmented by country. Identified top-performing countries, with notable sales in the United States, Ireland, and the United Kingdom. Top Customers:

Identified the top 5 customers contributing to the highest sales. Key customers include Don Flintiff, Nealson Cuttler, and Terri Farra, among others. Visual Representations:

Developed bar charts and other visual aids to easily interpret sales data. Presented the data in an easy-to-digest format for stakeholders. Tools and Techniques Used Excel: Utilized Excel for data aggregation, analysis, and visualization. Data Cleaning: Ensured data accuracy and consistency. Dashboard Creation: Integrated various data points into a cohesive and interactive dashboard. Outcome The dashboard provided actionable insights, helping the coffee shop make data-driven decisions to optimize inventory, target key markets, and enhance customer satisfaction.

STILL ONGOING.