📊 Retail Sales Performance Analysis

🚀 Project Status

Version: 1.0

✅ Completed

• Data Cleaning
• Feature Engineering
• Exploratory Data Analysis (EDA)
• Data Visualization
• Business Insights
• Business Recommendations
• Interactive Dashboard (Google Looker Studio)

---

📖 Project Overview

This project presents an end-to-end Retail Sales Performance Analysis using Python and Google Looker Studio. The objective is to analyze retail sales data, identify profitability trends, understand customer purchasing behavior, and generate actionable business insights to support data-driven decision-making.

---

🎯 Project Objectives

• Analyze overall sales and profitability.
• Identify top-performing product categories.
• Evaluate customer purchasing behavior.
• Detect loss-making products.
• Analyze the impact of discounts on profit.
• Study regional and state-wise performance.
• Build an interactive business dashboard.
• Provide business recommendations based on the findings.

---

🛠 Technologies Used

• Python
• Pandas
• Matplotlib
• Seaborn
• Google Colab
• Google Looker Studio

---

📂 Dataset Information

Dataset: Sample Superstore Dataset

• Records: 9,994
• Features: 21

---

🔄 Project Workflow

1. Data Understanding
2. Data Cleaning
3. Feature Engineering
4. Exploratory Data Analysis (EDA)
5. Data Visualization
6. KPI Analysis
7. Business Insights
8. Business Recommendations
9. Interactive Dashboard (Google Looker Studio)

---

📊 Dashboard Preview

---

🔗 Interactive Dashboard

View the live Google Looker Studio Dashboard:

https://datastudio.google.com/s/lvaSLfD_kqM

---

📈 Key Business Insights

• Technology generated the highest overall sales and profit.
• Furniture achieved strong sales but comparatively lower profit margins.
• Copiers were the highest profit-generating products, while Printers generated the highest losses.
• California and New York contributed the highest profits.
• West and East regions outperformed South and Central.
• Higher discounts were associated with lower profitability.
• Sales peaked during August, September, and October.
• Repeat customers contributed significantly to overall revenue.

---

💡 Business Recommendations

• Review discount strategies for products generating consistent losses.
• Improve profitability of Furniture products through pricing optimization.
• Focus inventory and marketing investments on high-performing Technology products.
• Strengthen customer loyalty programs for repeat customers.
• Expand growth initiatives in lower-performing regions.
• Monitor loss-making products regularly and evaluate pricing decisions.

---

📚 Skills Demonstrated

• Python
• Pandas
• Data Cleaning
• Feature Engineering
• Exploratory Data Analysis (EDA)
• Data Visualization
• Business Intelligence
• Dashboard Development
• KPI Reporting
• Business Analysis
• Interactive Dashboard (Google Looker Studio)

---

🚀 Future Enhancements

• SQL database integration
• Automated API-based data refresh
• Sales forecasting using Machine Learning
• Customer Segmentation
• Streamlit Dashboard Deployment

---

📁 Repository Structure

Retail-Sales-Performance-Analysis/
│
├── README.md
├── requirements.txt
├── Retail_Sales_Performance_Analysis.ipynb
├── Sample - Superstore.csv
├── Retail_Sales_Cleaned.csv
└── images/
    └── dashboard.png

---

👨‍💻 Author

Arvind Anand Dyavanapelli

GitHub: https://github.com/arvindd333

LinkedIn: https://www.linkedin.com/in/arvind-dyavanapelli-8159b7194