Objective: Analyze 6 months of sales data (May-Oct 2025) for an Indian electronics company to identify trends, top products, and regional performance.
Files included:
Data/sales_raw_data.xlsx- Raw transactional sales data (OrderID, OrderDate, Region, City, SalesPerson, Product, UnitsSold, UnitPrice, TotalSales, Profit)Reports/sales_cleaned_report.xlsx- Cleaned data and summary sheets (Monthly_Summary, Region_Summary, Product_Summary, Insights)Visuals/sales_dashboard.png- Dashboard image (sales by month, region distribution, top products)
Techniques & Functions used:
- Data cleaning and aggregation with Excel/Pandas
- Formulas: SUM, SUMIFS, AVERAGE, IFERROR (demonstrated in report)
- Pivot-like summaries: monthly totals, region totals, product totals
- Charts: bar charts, pie chart for region distribution
- Insights: top region, top product, transaction counts
Author: Kuldeep Shar