This analysis presents a detailed overview of key metrics in the cafe business, including profitability, discount trends, delivery performance, and order behavior. It highlights top products, high-demand regions, and supports data-driven decisions to improve efficiency and profit.
This project presents a comprehensive dashboard that analyzes various aspects of a cafe business using transactional and shipment data. The dashboard focuses on key business indicators such as Profit, Discounts, Discontinued Products, Freight Costs, and Delivery Performance across multiple countries, product categories, and shipping companies.
-
Identify high- and low-performing product categories based on profit.
-
Understand the impact of discounts on overall revenue and margin.
-
Monitor delivery performance by shipper and optimize logistics.
-
Highlight discontinued products to improve product lifecycle decisions.
-
Track freight expenses and find opportunities for cost optimization.
-
Detect trends in frequent orders and region-wise customer demand.
Python (Pandas, Matplotlib, Seaborn) – Data preprocessing and initial visual analysis.
Power BI – Final dashboard creation with interactive visuals.
Jupyter Notebook – Data cleaning, transformation, and exploration.
Beverages, Meat & Poultry, and Grains are the most profitable categories.
Most countries apply a uniform 25% discount, with few applying 20% or 15%.
United Package consistently delivers early and performs best among shippers.
Freight expenses are equally distributed across all shippers, indicating a flat-rate model.
High-frequency products include Aniseed Syrup, Boston Crab Meat, and Camembert Pierrot.
Discontinued products are concentrated in Meat & Poultry, Condiments, and Grains.
Focus promotions on high-profit items and frequent-order regions (e.g., Germany, USA).
Re-evaluate and optimize discount rates to protect margins.
Strengthen relationships with high-performing shippers (especially United Package).
Replace or rethink stocking of low-performing or discontinued products.
Audit freight structure for potential savings or efficiency gains.