Walmart Sales Data Analysis

About

This analysis aims to provide insights into Walmart's sales data, evaluating product performance, sales trends, and customer segments. The process involves handling data, generating new features, and conducting exploratory data analysis to answer various business questions and assist in making informed decisions for improving sales strategies, product lines, and customer relationships.

Business Questions To Answer:

Generic Question How many unique cities does the data have? In which city is each branch?

Product

• How many unique product lines does the data have?
• What is the most common payment method?
• What is the most selling product line?
• What is the total revenue by month?
• What month had the largest COGS?
• What product line had the largest revenue?
• What is the city with the largest revenue?
• What product line had the largest VAT?
• Which branch sold more products than average product sold?
• What is the most common product line by gender?
• What is the average rating of each product line?

Sales

• Which of the customer types brings the most revenue?
• Which city has the largest tax percent/ VAT (Value Added Tax)?
• Which customer type pays the most in VAT?

Customer

• How many unique customer types does the data have?
• How many unique payment methods does the data have?
• What is the most common customer type?
• Which customer type buys the most?
• What is the gender of most of the customers?
• What is the gender distribution per branch?
• Which time of the day do customers give most ratings?
• Which time of the day do customers give most ratings per branch?
• Which day fo the week has the best avg ratings?
• Which day of the week has the best average ratings per branch?

View Project on GitHub