Sprocket_Sales_Analysis

Table of contents

• Project overview
• Data Sources
• Analysis Tools
• Data Cleaning/Preparations
• Exploratory Data Analysis
• Data Analysis Codes_files/Charts
• Results/Findings
• Business Recommendations
• Limitations
• References

---

Project overview

This Sprocket_Pty_Ltd_Sales Analysis was to help this Brand

• Analyze sales trends, customer demographics, popular products, and sales channels
• Explore customer behavior such as purchase frequency, average order value, etc
• Create visualizations to highlight sales patterns and customer preferences
• Identify potential strategies to enhance sales, customer engagement, and retention in e- commerce

Data Sources

Analysis Tools

Data Cleaning/Preparations

Exploratory Data Analysis

Data Analysis Codes_files/Charts

Results/Findings

In the course of our analysis We observed the following

• The trends in this dataset lies in the popularity of the Product_line by Profit margin, List price by Product class, Customer by Wealth Segment, Profit by product line etc etc

• The Dataset shows that the Mass_Customer_Segment has the highest Value_Contribution to this Brand when compare to its counterparts with a total 384.07

• The Unknown gender has the highest Average Bike purchase rate of 52 for this Brand than its counterparts

• The Product line standard has the highest profit margin of $8M by far, greater than every other product line

• The Mass customers are the biggest treasure of this Brand when it comes to purchases made

Business Recommendations

Here are our recommendation for the Sprocket Pty ltd on how to tailor their Marketing and Growth strategy to improve their profitability

• More resources should be allocated to the "Mass_Customer Segment" which are their huge treasure to increase the number of purchases

• Standard which is the Product line with the highest Profit should always be available upon demand

• Most of this Business customers come from the New South Wales and this State should be top priority or target for the next campaign

• The additional external dataset that can be use to extract more insights for this analysis is "Sales Dataset"

• The People the Sprocket Pty Ltd should be targeting should be the "Masses" because that's where the highest purchases is coming from. They are advice to tailor their marketing campaign to suite the Masses to increase awareness

Limitations

*In the course of our anlysis we make sure that get rid of some

References