Skip to content

The Coffee Sales Analysis Excel Project is a practical exploration of sales data analysis using Microsoft Excel. This project showcases how Excel can be a powerful tool for data cleaning, preprocessing, visualization, and dashboard creation, all within a familiar spreadsheet environment.

Notifications You must be signed in to change notification settings

cliffordtutu/Excel-Project-Coffee-Sales-Analysis

Repository files navigation

Project Overview

The objective of the project was to develop a Coffee Sales Dashboard for McKeezy Coffee Shop, focusing on finding the following:

  1. Sales over time for each coffee type.
  2. Sales by country.
  3. Top customers.
  4. Loyalty Subscription.

Other Key Metrics like Total Sales, Total Profit, Total Orders, Top Selling Product, will be deduced. The dashboard will be interactive, so you will be able to filter by time period, type of coffee roast, coffee sizes, and whether or not the customers are loyalty members

A detailed explanation is made in the Project Overview file.

About

The Coffee Sales Analysis Excel Project is a practical exploration of sales data analysis using Microsoft Excel. This project showcases how Excel can be a powerful tool for data cleaning, preprocessing, visualization, and dashboard creation, all within a familiar spreadsheet environment.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published