Project Overview:

This project analyzes Coffee Sales Data, including Customer, Order, and Product data sheets. Using Excel VLookup and Index Match to combine data from different data sheets. Implement Data Cleaning and Formatting. Then, built a Dynamic Dashboard for Sales Trend, Sales by country, and by different category analysis.

Project Objective:

Identify the main data trends and insights to inform future business decisions using Excel.

Techniques & Metrics:

Pivot Table, VLookUp, Index Match, Dynamic Dashboard

Dynamic Excel Dashboard:

Screenshot:

File Download: