Skip to content

Pranay18062003/Walmart-Analytics-DB

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Walmart Analytics DB

This project is focused on analyzing Walmart’s retail transaction data using SQL. The goal is to explore patterns, uncover insights, and understand business trends through structured queries and data analysis.

Key Features

Data Cleaning & Preparation: Organized raw transaction data for analysis

Advanced SQL Queries: Used GROUP BY, HAVING, subqueries, CTEs, and window functions to extract meaningful insights

Performance Insights: Identified top-performing branches, peak hours, popular products, and revenue trends

Actionable Business Insights: Helped simulate how real-world retail businesses can optimize strategies using data

Tech Stack

SQL (PostgreSQL / MySQL)

CSV/Excel Dataset

(Optional) Visualization tools like Tableau or Power BI for dashboards

Learning Outcome

This project strengthened my SQL skills and provided hands-on experience in retail analytics. It demonstrates how structured queries can be applied to answer real-world business questions and generate actionable insights.

About

Walmart Sales Database SQL project analyzing Walmart sales data to uncover business insights. Cleaned and structured sales dataset Wrote queries for revenue, customer ratings, and product performance Used GROUP BY, HAVING, subqueries, CTEs, window functions Identified top branches, peak hours, and sales trends

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors