The business management has requested insights into the sales performance across products and customers. This data analysis project centers on examining sales and customer data from Adventure Works stores. The objective is to discover insights, identify trends, and determine key performance indicators to address business inquiries. The data source is the company's SQL Database, which encompasses the following tables:;
- Sales Table
- Product Category Table
- Product Subcategory Table
- Products Table
- Territory Table
- Customer Table
- Returns Table
- Calender Table
- Cleaning and preprocessing the dataset to ensure data quality and consistency.
- Consolidating the sales table from different years into one Overall sales table
- Creating additional columns from exisitng data required for the analysis
- Segmenting the customers into different Age Groups and Income_segments
- Segmenting the customers based on Last purchase date
The analysis was done on SQL Server. Click Here to view the complete analysis query
Revenue grew by 45.58% in 2021 but dropped by -1.49% in 2022
Bikes generated the highest revenue ($23,642,495) while Clothing generated the least revenue ($365,419)
These are the top 10 customers.
Road Bikes generated the highest profit ($4,368,347) hence it is the most profitable subcategory.
Revenue manintained an upward trajectory from January and peaks in June, then starts decling from July to November before it starts growing again. June recorded the highest revenue ($3,030,801) making it the top performing month.
Bikes generated the highest revenue year on year for the 3 years.
North America generated the highest revenue making it the top performing Continent in terms of revenue generation.
Australia generated the highest revenue in 2020 and 2021, while United States generated the highest revenue in 2022
Bikes recorded the highest return rate, making it the category with the most returned products.
These are the top selling products in each subcategory
Top 10 frequently co-purchased products.
Top 5 slow-moving products
Quantity Sold manintained an upward trajectory from January and peaks in June, then starts decling from July to November before it starts growing again. June recorded the highest quantity sold (8,784) making it the top performing month in terms of quantity sold.
Middle income (40001 - 80000 per annum) earners generated the highest profit.
Customer age groups distribution.
Active segment recorded the highest number of customer segments while lost segment recorded the least number of customers.
Customers with Bachelors degree recorded the highest purchase units while customers under the partial high school level recorded the lowest.
Order distribution per customer occupation per weekday
I created 4 interactive dashboards to visualize various KPIs, gain more insights and compare relationships between different varibles.
