A comprehensive sales data analysis project for a coffee shop business aimed at evaluating revenue performance, identifying best-selling products, and analyzing customer purchasing patterns.
The project included data cleaning, preprocessing, and analysis using SQL and Python (Pandas). Key performance indicators (KPIs) such as Total Revenue, Sales by Product Category, Peak Sales Hours, and Store Performance were calculated and visualized using Matplotlib.
The final result was an interactive analytical dashboard that provides actionable insights to improve sales strategy and optimize product offerings.