Project: Supermarket Sales

Supermarket Sales Analysis
(Excel + Power BI)

Analyzed supermarket sales data to identify trends and performance indicators across product lines, customer types, and purchase times.

The images shown are the dashboard, messy data, and cleaned data, respectively.

View Excel Data on Google Drive

Objective:
  • What are the monthly sales and profit trends?
  • What categories and regions are most profitable?
  • What products are underperforming?
    		•
    Tools Used:
  • Excel: Data cleaning, formulas, pivot tables
  • Power BI: KPIs, charts, segmentation visuals
    		•
    Insights:
  • Most revenue comes from Female members buying Health & Beauty products.
  • Evening and weekend sales perform significantly better.
  • Customer ratings tend to align with payment method preferences.
    		•
    Outcome: Built a clear dashboard that helped simulate real-world analysis using pivot tables and Power BI dashboards. Great for sales trend reporting practice.