2023 Annual Sales Report for revenue growth in 2024
🔎Objective
The store owner wants an in-depth annual sales report for 2023 to facilitate customer understanding and drive data-driven sales strategies for increased revenue in 2024.
📌Questions
➡️Which month got the highest sales and orders?
➡️Who purchased more- men or women in 2023?
➡️What are the different order status in 2023?
➡️List top states contributing to the sales?
➡️Which channel is contributing to maximum sales?
Steps
🛠️Data Cleaning
-
Examining all data points to ensure they address our business problems.
-
Apply filters to each column to identify any incorrect, missing, or null values.
-
Convert 'M' and 'W' to 'Men' and 'Women' respectively to eliminate inconsistencies.
🧩Data Processing
-
Age Segmentation: Added 'Age Group' to classify customers as 'Teenager', 'Adult', or 'Senior'.
-
Monthly Analysis: Created a 'Month' column from dates for trend analysis.
-
Highlighting: Enhanced visibility for newly added columns.
📈Data Analysis
-
Monthly Sales Analysis: Develop a pivot table to analyze sales data by month, focusing on total expenditures and order counts.
-
Gender Sales Analysis: Utilize a pivot table to compare spending patterns across genders.
-
Order Status Review: Create a pivot table to categorize and quantify orders based on their current status.
-
Top States by Sales: Use a pivot table to pinpoint the top five states by sales volume to enhance regional marketing strategies.
-
Purchasing Patterns: Analyze purchasing frequency across age groups segmented by gender using a pivot table.
-
Website Performance: Assess which website platforms are most effective in generating sales with a pivot table linking websites to order volumes.
📊Data Visualization
-
Comprehensive Charting- Develop charts and graphs to visually summarize key sales data points, such as Order vs. Sales, Top 5 States by Sales, Sales by Gender, Age vs. Gender Distribution, Delivery Status, and Top Performing Websites.
-
Reporting- Compile the insights into a structured report, outline key findings, and recommend strategic actions to boost future sales.