Walmart_Sales_Analysis_SQL

This is a sales analysis project carried out using MySQL:

Data Source: https://www.kaggle.com/c/walmart-recruiting-store-sales-forecasting

Sales Analysis Segments:

Product Analysis

1. Which cities are the branches located in?
2. What are the unique products sold?
3. What are the product sales?

Sales Analysis

This analysis aims to answer the question of the sales trends of products. The result of this can help use measure the effectiveness of each sales strategy the business applies and what modifications are needed to gain more sales.

1. What are the sales by city?
2. What are the sales by payment method?
3. What are the sales by branch?
4. When (day) are the sales at their pick, and at the lowest point?
5. What are the sales by time of day?
6. What are the sales by hour?

Customer Analysis

This analysis aims to uncover the different customer segments, purchase trends and the profitability of each customer segment.

1. What are the sales by gender?
2. What are the sales by customer type?
3. What are the customer ratings by city?
4. What are the customer ratings by payment method?
5. What are the customer ratings by product line?
6. What is the customer rating by gender?
7. What is the customer rating by branch?
8. What is the customer rating by customer type?