📊 Sales Insights Dashboard

This is a real-world, end-to-end Data Analysis & BI Dashboard project built by Banothu Prashanth to analyze sales performance, discover patterns, and generate business insights using Python, Pandas, Seaborn, and Streamlit.

---

🚀 Project Highlights

✅ Advanced Data Cleaning (real-world messy CSV)
✅ 6+ Business-Focused Visuals
✅ Segment-wise & Region-wise Filtering
✅ Interactive Streamlit Dashboard
✅ Folder structure & Git-ready
✅ Deployable for real-time demo (Streamlit Cloud)

---

🧠 Business Questions Solved

• Which categories drive the most revenue?
• Where is the business most profitable (by region/state)?
• How does sales trend over time?
• Who are the top customers?
• How do segments and discounts impact profit?

---

🗂️ Folder Structure

sales_insights_dashboard/ │ ├── data/ │ ├── Superstore_Sales.csv # Original raw dataset │ ├── cleaned_sales_data.csv # Cleaned CSV │ └── plots/ # Visuals from EDA │ ├── category_sales.png │ ├── profit_by_state.png │ └── ... │ ├── scripts/ │ ├── data_cleaning.py # Cleaning script │ └── eda_visuals.py # EDA + plot saving │ ├── streamlit_app/ │ └── app.py # Dashboard UI code │ ├── requirements.txt # Dependencies ├── .gitignore ├── README.md ✅ This file

⚙️ Tech Stack

• Language: Python 3
• Data Analysis: Pandas, NumPy
• Visualization: Matplotlib, Seaborn
• App Interface: Streamlit
• Version Control: Git + GitHub

---

📈 Dashboard Features

• 📊 KPI Cards (Total Sales, Profit, Orders)
• 🎯 Region, Segment, Category Filters
• 📉 Line & Bar Charts (Yearly Trends)
• 🗺️ Profit by State (Geo view)
• 🧠 Clean UI built with Streamlit

---

🔗 Live Demo

Coming Soon on Streamlit Cloud 🌐
(Once deployed, paste the link here)

---

📎 How to Run Locally

1. Clone the repo
2. Create virtual environment
3. Install requirements:

pip install -r requirements.txt
---

4. Launch the app:

```bash
streamlit run streamlit_app/app.py


## 👤 Author

**Banothu Prashanth**  
📧 banothuprashanth121@gmail.com  
🌐 [GitHub](https://github.com/prashanthsword)  
🔗 LinkedIn: https://www.linkedin.com/in/banothu-prashanth-4406b3233