Supermarket Sales Performance Analysis Project Overview
This project presents an interactive Power BI dashboard to analyze supermarket sales performance. The goal is to identify key business insights related to sales trends, product performance, customer behavior, and regional performance.
This project is part of my Data Analyst Portfolio, demonstrating my skills in data cleaning, analysis, and visualization.
Dashboard Preview
Business Objectives
Analyze overall sales performance
Identify top-performing product categories
Understand city-wise sales distribution
Track sales trends over time
Compare performance across branches
Key Insights
Total Sales: 322.97K
Total Profit: 15.38K
Total Quantity Sold: 5,510
Average Rating: 6.97
Performance Highlights
Top Product Category: Food & Beverages
Highest Sales City: Naypyitaw
Sales show variation across branches
Consistent demand across major product lines
Tools & Technologies Used
Power BI – Data visualization & dashboard creation
Excel / CSV – Dataset handling
SQL – Data querying and analysis (project practice)
Python (Pandas) – Data exploration (learning phase)
Dashboard Features
KPI Cards (Sales, Profit, Quantity, Rating)
Sales by Product Line (Bar Chart)
Sales Distribution by City (Pie Chart)
Sales Trend Over Time (Line Chart)
Branch Filter (Interactive Slicer)
Clean and professional layout
Project Structure Sales-Performance-Analysis01 │ ├── data/ ├── dashboard/ │ └── Supermarket_Sales_Dashboard.pbix ├── Images/ │ └── dashboard_overview.png ├── README.md Dataset Information
The dataset contains supermarket transaction data including:
Branch
City
Product Line
Quantity
Total Sales
Customer Rating
Date & Time
Payment Method
How to Use This Project
Download the .pbix file from the dashboard folder
Open it using Power BI Desktop
Interact with filters and visuals to explore insights
About Me
Shawana Hakim Aspiring Data Analyst | Power BI | SQL | Python | Excel
I am currently building real-world projects to strengthen my data analytics skills and prepare for entry-level Data Analyst roles.
LinkedIn: www.linkedin.com/in/ shawanahakim GitHub: https://github.com/shawana009
Project Status
Completed – Day 7 of Data Analyst Portfolio Challenge