🛍️ Retail Sales Performance Dashboard (Power BI)

This Power BI project analyzes retail sales performance across regions, states, cities, and stores. It showcases advanced data modeling, DAX calculations, dynamic visualizations, and a clean, executive-level dashboard design for performance monitoring and strategic insights.

📊 Project Overview

The dashboard provides a comprehensive view of sales and profitability across multiple store locations. Key performance indicators are analyzed by various dimensions to support data-driven decision-making.

🔍 Key Features

• KPI Summary Cards for Total Sales, Total Profit, Profit Margin %, and Total Quantity
• Hierarchical Drilldown from Region → State → City → Store
• Sales & Profit Visuals by geography, product, and time
• Scatter Plot Analysis to compare Profit Margin % vs Total Sales
• Dynamic filtering with slicers and bookmarks
• Clean UX Design with user-friendly layout and consistent formatting

📁 Report Pages

1. Executive Summary – High-level KPIs and performance overview
2. Store Performance – Drilldown and geographic analysis of sales and profit
3. Product Insights – Sales and profit by product categories and SKUs
4. Customer Insights – Buying behavior, top customers, and quantity trends

🧮 Data & Measures

• Measures Used:
  • Total Sales
  • Total Profit
  • Profit Margin %
  • Total Quantity
• Dimensions:
  • Region, State, City, Store
  • Product Category, Sub-Category
  • Customer
  • Date (with custom Date table for time intelligence)

🛠️ Tools & Techniques

• Power BI Desktop
• Data Modeling & Relationships
• DAX Measures & Calculation Groups
• Bookmarks and Drillthroughs
• Advanced Visualizations & Custom Tooltips

📦 File Structure

• **Retail_Sales_Dashboard.pbix
• **Retail_DataSet.xls

🚀 Getting Started

1. Clone the repository:
2. Open the .pbix file in Power BI Desktop.
3. Explore the dashboards and visuals using the slicers and filters.

🧠 Insights & Use Cases

• Identify top/bottom performing stores or regions
• Evaluate profit margins across locations and products
• Analyze customer purchase behavior and product performance
• Provide actionable insights for retail business strategies

📝 Author

Imran Raza
LinkedIn
📧 [email protected]

---

⚠️ This project uses dummy or anonymized data for demonstration purposes only.