Project information

• Category: Coffee Sales Analysis Demo Project

• The project focused on developing a comprehensive analytics dashboard for a coffee sales company. The goal was to provide insightful visualizations and key performance indicators (KPIs) to help the company understand its sales performance, customer behavior, and product profitability. Dataset: The project involved working with three main tables: "Sales," "Customers," and "Products." Each table contained crucial information such as order details, customer demographics, and product specifications. Analysis: Through data analysis and visualization techniques, were identified key metrics such as total sales revenue, total profit, number of orders, etc. Additionally, was segmented the data to analyze sales performance by coffee type, roast type, country, and more.

• Technology used: Excel
• Project date: 2020
• Project URL: #