This project analyzes the AdventureWorks dataset to extract key business insights on sales performance, customer behavior, and product trends using Microsoft Excel. The data was initially dirty and inconsistent, requiring extensive cleaning before performing meaningful analysis.
Before starting the analysis, the raw dataset required extensive cleaning:
-
Handled Missing Values:
- Replaced missing sales amounts using average values where appropriate.
- Removed records with missing customer IDs to avoid incorrect mappings.
-
Removed Duplicates:
- Identified and deleted duplicate sales records.
-
Standardized Formatting:
- Corrected date formats for consistency.
- Fixed inconsistent text cases (e.g., region names, product categories).
-
Resolved Data Inconsistencies:
- Mapped incorrect region names to correct ones.
- Aligned currency formats across different transaction records.
✔ Sales trends over time (monthly, quarterly, yearly).
✔ Revenue breakdown by product category & region.
✔ Best-selling and least-selling products.
✔ High-value customers based on purchase frequency & total spend.
✔ Repeat customer trends vs. one-time buyers.
✔ Regional customer segmentation.
✔ Gross margin analysis per product category.
✔ Regional sales performance insights.
✔ Employee sales performance evaluation.
✔ PivotTables & PivotCharts – For interactive sales and customer analysis.
✔ Conditional Formatting – Highlighting key trends & anomalies.
✔ Slicers & Filters – For dynamic exploration of sales data.
- Cleaned & Processed Dataset – Error-free, structured data.
- Sales & Customer Reports – Data-driven insights in tabular & graphical form.
- Excel Dashboard – Interactive visuals summarizing key trends.
- Final Report – Business insights & recommendations based on findings.
- Open the Excel file and navigate through cleaned datasets.
- Use PivotTables & charts to explore different sales and customer trends.
- Adjust filters & slicers to get specific business insights.
- Refer to the final report for actionable recommendations.
By cleaning the raw data and analyzing key trends, this project provides valuable insights into AdventureWorks' sales performance, customer behavior, and business growth opportunities. The interactive dashboard helps business users make data-driven decisions with ease.