This repository contains project sales analysis, with data obtained from Kaggle.
Sales analytics is the practice of generating insights from sales data and trends. Sales analysis is mining your data to evaluate the performance of your sales team against its goals. It provides insights about the top performing and underperforming products/services, the problems in selling, and market opportunities.
Data Information:
-
Order ID - An Order ID is the number system that Amazon uses exclusively to keep track of orders. Each order receives its own Order ID that will not be duplicated. This number can be useful to the seller when attempting to find out certain details about an order such as shipment date or status.
-
Product - The product that have been sold.
-
Quantity Ordered - Ordered Quantity is the total item quantity ordered in the initial order (without any changes).
-
Price Each - The price of each products.
-
Order Date - This is the date the customer is requesting the order be shipped.
-
Purchase Address - The purchase order is prepared by the buyer, often through a purchasing department. The purchase order, or PO, usually includes a PO number, which is useful in matching shipments with purchases; a shipping date; billing address; shipping address; and the request items, quantities and price.
Target:
A target market analysis is an assessment of how your product or service fits into a specific market and where it will gain the most.
Task:
-
What was the best month for sales? How much was earned that month?
-
What City had the highest number of sales?
-
What time should we display adverstisement to maximize likelihood of customer's buying product?
-
What products are most often sold together?
-
What product sold the most? Why do you think it sold the most?