Coffee Sales DashboardEXCEL

Timeline for easy navigation through sales for months, quarters, or years.

Slicers are used for easy filtering of data, as preferred.

Distinct colors for total sales over time.

Easy representation of top customers in any given month, quarter, or year.

Country sales are represented in ascending order.

 Formulas used include: INDEX, MATCH, VLOOKUP, XLOOKUP & IF.

The month with the highest sales was February 2020, with $1798 sales ($745 Arabica(A),  $429 Excelsia(E), $194 Liberica(L) & $430 Robusta (R).

The quarter with the highest sales was Q4 of 2021 ($4165) sales across all coffee types and sizes.

Roast Types:

1. Dark roasted coffees had its highest sales February 2020($718) and its lowest sales May 2019 ($63).

2. Medium roasted coffees had its highest sales November 2021($712) and its lowest sales August 2022 ($66).

3. Light roasted coffees had their highest sales in April 2019 ($1,048) and their lowest sales in April 2020 ($77).

 Size sales

1. 0.2kg coffees had its highest sales in February 2020 ($179).

2. 0.5kg coffees had its highest sales November 2021 ($693).

3. 1.0kg coffees had its highest sales January 2021 ($316).

4. 2.5kg coffees had its highest sales February 2020 ($1,352).

The highest paying customer leaderboard stayed constant after Q3, 2021 with Brenn Dundredge, Brice Romera, Ailey Brash, Lacee Tanti & Elysee Sktech taking the top 5 customer spots with order from $307 to $205.

The total sales for the period were $45,134 across all four coffee types.

The chunk of the company's sales was made in the United States.

Since the highest sales of the franchise was made in the United States, a market research could be done to understand the profitability.y of opening other stores in the country.

Given the fact that sales dropped after 2020, research should be done into how to retaining loyal customers and what was their reason for the reduced sales in 2021 & 2022.