Us Supestore Sales Dashboard
Completion Date:
Project Overview
The project presents the US superstore that is powered by the internet, where customers from all over the world can access an online store to browse through, and place orders for products via their own devices. There is no underestimating just how important data is to the sales department. Its essential for several reasons, including helping with decision making, improving future performance, Growth successful business and understanding customers better. In other words, a quality data set leads to accurate sales insights. The main purpose of this report is to identify the sales of each product at a particular state in the USA and understand the products which play a key role in increasing sales and gross product margin per month and per year. In addition, it identifies the gross profit margin of the product based on a specific month or year. The major objective of this project is to analyze and identify which month, year, state, and items categories are gate more sales and which one is less sales on this year.
Role:
Problem Statement
According to several sources most e-commerce start-ups are set to fail within their first 120 days of operation. In 2020, most retail spending has shifted online, but a new report from Colliers International predicts that online retail sales will decrease 8.5% in 2021.
The top main reasons are why e-commerce startups end failures are
1.Poor online marketing.
2.Lack customer service.
3.Product mismatching.
4.The main cause of this failure is due to limitation of data analysis
Executive Summary
The project presents the US superstore that is powered by the internet, where customers from all over the world can access an online store to browse through, and place orders for products via their own devices. There is no underestimating just how important data is to the sales department. It\'s essential for several reasons, including helping with decision making, improving future performance, Growth successful business and understanding customers better. In other words, a quality data set leads to accurate sales insights. The main purpose of this report is to identify the sales of each product at a particular state in the USA and understand the products which play a key role in increasing sales and gross product margin per month and per year. In addition, it identifies the gross profit margin of the product based on a specific month or year. The major objective of this project is to analyze and identify which month, year, state, and items categories are gate more sales and which one is less sales on this year. Then we identify the major cause of our sales increase and decrease.
Data Dictionary
Key Takeaways
Next Steps
The data shows that whenever the sales per month and sales YOY % increase the sales year over year growth become decrease, therefore I recommend the Superstore sales should try to lower the avg discount % and shipping cost % to increase the sales year over year growth. The data shows that some states have lower sales therefore I recommend investing in advertising or promotion to create product awareness to improve sales and attract new customers. In general, I recommend the Superstore sale to:
1.Showcase reviews: Consumers generally won’t accept the claims of a brand right off the bat. They need those claims to be backed up by someone they already trust, such as a peer. This is where reviews come in According to Business.com 87% of people consult online reviews before making a purchase. If you can provide those positive reviews directly on your website, you can bring customers closer to purchase. Reviews reaffirm the credibility of your business, boost your reputation, and help to build that trust that is essential to growing your customer base and increasing sales.
2.Offer a discount: Everyone likes to get a deal. That’s why it seems like stores are constantly running sales and promotions. They’re trying to get you in the door and to the checkout counter, and you can do the same with your e-commerce store. Especially when you’re first starting out and trying to develop a loyal customer base, being competitive on price is key to making sales. Consider offering a discount or running a promotion and displaying it clearly on your website. Even something as simple as 15% off could be the difference between someone deciding to buy or not.
3.Use email marketing: You need to promote your business, and one of the best ways to do that is through email marketing. When writing an email to send to your prospect list, make sure you stress urgency. For example, if you’re promoting a sale, push the fact that it’s only available for a limited time or that it’s ending soon. The more urgency you create, the more your audience will feel pressure to make a purchase. Keep in regular contact with your email list to stay top of mind. Statista finds that 86% of consumers would like to receive promotional emails from companies they do business with at least monthly.
