Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

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

Notifications You must be signed in to change notification settings

Pranay18062003/Walmart-Analytics-DB

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

No packages published

AltStyle によって変換されたページ (->オリジナル) /