Walmart Sales Analysis.Pt2 (SQL)

This project seeks to analyze Walmart Sales data, aiming to unveil diverse customer segments, assess the profitability of each segment, identify purchase trends, and understand the top-performing branches along with the factors influencing their sales.

Notably, food and beverages, fashion accessories exhibit the highest average ratings compared to other product lines.

The customer base is evenly split between normal and member customers, although members contribute more to revenue.

Gender distribution varies among branches, with male customers dominating in branches A and B, and females prevailing in branch C.

Evening hours consistently yield the highest revenue across all branches. Branch C emerges as the top-performing store, suggesting a potential focus on evening promotions to boost revenue company-wide.

Additionally, revenue spikes on Saturdays and Tuesdays, emphasizing the strategic opportunity for promotions during these days, especially in the evenings.