Chocolate Sales Analysis

Key Processes:

- Shipping Indicators Over Time

I analyzed the number of shipments across different months for the years 2023 and 2024, comparing shipping performance between countries such as the UK, USA, New Zealand, India, and Australia.

- Product Distribution by Geo

Identified the regions with the highest demand for chocolate products and analyzed the status of orders (delivered, shipped, canceled, placed) for each region.

- Most Requested and Best-Selling Products*: Identified the most requested products like 50% and 70% dark chocolate bars and analyzed the best-selling products in terms of total value.

-Supplier Performance Evaluation Evaluated supplier performance based on order status and analyzed shipment density for active suppliers.

Tools Used:

- Excel: For data analysis and creating charts.

- Power Query: For data cleaning and preparation.

- Power Pivot: For data analysis and creating data models.