This repository contains SQL queries for an Exploratory Data Analysis (EDA) on Walmart sales data. This analysis aims to uncover insights related to product performance, customer behaviour, and sales trends across different cities and product lines. The queries focus on identifying key metrics such as revenue, product preferences, and sales distribution.
The dataset was obtained from the Kaggle. This dataset contains sales transactions from three different branches of Walmart, respectively located in Mandalay, Yangon and Naypyitaw. The data includes 17 columns and 1000 rows.
-
Unique Cities and Branch Locations: Identifies the different cities and branches present in the dataset.
-
Product Line Overview: Analyzes the unique product lines and identifies the top-selling product lines.
-
Payment Method Distribution: Displays the most common payment methods used by customers.
-
Revenue Analysis:
Monthly revenue trends.
City-wise revenue distribution.
Top revenue-generating product lines.
-
Cost of Goods Sold (COGS): Shows which months had the highest COGS.
-
VAT and Tax Analysis: Calculates the average VAT per product line.
-
Sales by Gender and Time:
Popular product lines segmented by gender.
Sales trends across different times of the day and weekdays.
-
Customer Ratings: Displays the average customer rating for each product line.
-
Branch Performance: Identifies branches that sold more products than the average branch.