
🏬 Store Performance Dashboard
Type: SQL + Power BI Project | Focus: Sales, Category & Inventory Insights
Link: View Live Dashboard
SQL Analysis Source: View GitHub Project
🧩 Project Overview
This interactive store performance dashboard combines SQL-driven data preparation with advanced Power BI visuals to deliver actionable insights for store managers. It tracks key sales and customer metrics, highlights revenue breakdowns, and integrates product-level inventory alerts to help mitigate revenue risks.
📌 Key KPIs & Visuals
- Total Sales with MoM % Change Indicator
- New Customers Added %
- Revenue Trend by Month
- Customer Added Trend by Month
- Category-wise Revenue Split for Selected Month & Store
- Product Performance Table featuring:
- Current Stock Level
- SVG-Based Product Status Alerts (Out of Stock, Low Stock, Healthy Stock, Potential Loss)
📈 Insights Highlight
- MoM % Sales Change: Tracks revenue growth or decline with visual SVG indicators
- New Customer Trends: Monitors customer acquisition over time