🧠 Business Problem
The company is experiencing inconsistent sales performance across regions.
The goal is to identify trends, top-performing products, and underperforming regions
to improve revenue.
📂 Dataset
Sales data containing order date, region, product category,
quantity sold, revenue, and profit.
🛠 Tools Used
- Python (Pandas, NumPy)
- SQL
- Power BI
🔍 Analysis Steps
- Data cleaning and handling missing values
- Revenue and profit trend analysis
- Region-wise and product-wise performance
- Identification of low-performing regions
📊 Key Insights
- West region generates highest revenue but lowest profit margin
- Technology category contributes 45% of total sales
- Q3 shows consistent sales decline across regions
📈 Business Recommendations
- Optimize pricing strategy in West region
- Increase marketing spend for high-margin products
- Investigate operational issues during Q3
🔗 Project Links
GitHub Repository
Dashboard