📊 Sri Lanka Retail Sales Dashboard – Power BI Project

This Power BI project presents a detailed visual analysis of a synthetic retail dataset simulating sales across multiple cities in Sri Lanka. The dashboard is designed for business users to gain key insights into store performance, customer preferences, and product trends.

---

📁 Dataset Overview

• Source: Kaggle - Supermarket Sales Dataset
• Context: Simulated data from a retail store operating in Colombo, Kandy, and Nugegoda.
• Size: ~1000 transaction records
• Fields: Invoice ID, Branch, City, Product Line, Unit Price, Quantity, Tax, Total, Date, Time, Payment, Customer Type, Gender, Rating

---

🎯 Objectives

• Present high-level business KPIs using dynamic visuals
• Help identify best-performing branches and product lines
• Understand consumer behavior through gender, payment type, and time analysis
• Demonstrate Power BI dashboarding skills for business analytics

---

🚀 Key Features

✅ Executive Summary Cards

• Total Sales
• Gross Income
• Transaction Count
• Average Customer Rating

📊 Visual Insights

• Sales by City (Bar Chart)
• Product Line vs Gross Income (Column Chart)
• Payment Methods Distribution (Pie Chart)
• Gender-wise Sales Comparison (Bar Chart)

⏱️ Time-based Analysis

• Hourly Sales Distribution (Area Chart)
• Slicers: Filter dashboard by City and Date

---

📂 Project Structure

📁 powerbi-retail-dashboard/
├── powerbi/
│   └── Sri_Lanka_Retail_Analysis.pbix     # Power BI dashboard file
├── visuals/
│   └── dashboard_overview.png             # Dashboard screenshot
└── README.md

🧠 Skills Demonstrated Power BI Dashboard Design

Data Modeling & Cleaning in Power Query

DAX Measures for KPIs

Storytelling with Visuals

Executive Report Presentation

🧩 Future Improvements Add drill-down capability by product line

Incorporate customer segmentation logic

Deploy dashboard to Power BI Service for web access

📬 Connect with Me If you found this project interesting or want to collaborate, feel free to connect!

📧 Email: saluvihare23@gmail.com

🌐 Portfolio: (https://github.com/SamAlu23)