Skip to content

Retail Sales Analysis Project This repository hosts a PostgreSQL project analyzing retail sales data with a retail_sales table. It features SQL queries for data cleaning, exploration, and insights like category performance and top-selling months. Includes shift-based order analysis (Morning, Afternoon, Evening) using pgAdmin.

Notifications You must be signed in to change notification settings

debashisdash1999/sql_retail_sale_project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 

Repository files navigation

#Retail Sales Analysis Project: This repository contains a PostgreSQL-based project for analyzing retail sales data. The project includes a retail_sales table with columns for transaction details (e.g., date, time, category, quantity, total sale) and a series of SQL queries for data cleaning, exploration, and business insights. Key features include:-

(i) Data cleaning to handle NULL values. (ii) Exploration of sales volume, unique customers, and categories. (iii) Business queries to find sales by date, category performance, customer demographics, and top-selling months. (iv) Shift-based order analysis (Morning, Afternoon, Evening).

About

Retail Sales Analysis Project This repository hosts a PostgreSQL project analyzing retail sales data with a retail_sales table. It features SQL queries for data cleaning, exploration, and insights like category performance and top-selling months. Includes shift-based order analysis (Morning, Afternoon, Evening) using pgAdmin.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published