An interactive business intelligence dashboard built in Power BI to analyze supermarket sales performance, product distribution, and customer purchasing behavior.
The objective of this project was to:
- Analyze monthly revenue trends
- Evaluate product category performance
- Visualize sales distribution across branches and cities
- Examine customer and payment behavior
- Build a fully interactive, single-page BI dashboard
- Power BI Desktop
- DAX Measures
- Data Modeling
- Interactive Slicers
- Time-Series Visualization
The dashboard includes 6 core visual components:
-
Monthly Revenue Line Chart
- Total revenue aggregated by month
- Time-series trend analysis
-
Average Cost by Product Category
- Column chart showing average unit price per category
-
Sales Time Series
- Sales volume plotted against transaction date
- Year & month filters for drill-down analysis
-
Product Category Distribution
- Units sold per product line
- Stacked visualization by branch or city
-
Payment Method Breakdown
- Sales distribution by payment type (Cash, Credit Card, etc.)
- Percentage labels enabled
- Clear seasonal revenue patterns observed in monthly sales
- Certain product categories demonstrated stronger sales volume
- Payment method distribution revealed customer purchasing behavior
- Branch-level comparison allowed operational performance evaluation
This dashboard demonstrates:
- KPI computation and visualization
- Time-series sales analysis
- Category-level performance evaluation
- Interactive BI dashboard design
- DAX-based aggregation and measure creation
Supermarket_Sales_Dashboard.pbixMonthly Revenue Line Chart.pngAverage Cost by Product Category.pngSales Time Series.pngProduct Category Distribution.pngPayment Method Breakdown.png
This project showcases the ability to transform transactional retail data into structured business insights using Power BI. It integrates data modeling, DAX logic, and interactive visualization into a clear and interpretable analytics dashboard.