This project is part of the series of transition from MS Excel to R's Tidyverse package for a better pivoting and Data Mining for further analysis. End users can pull the data into Excel and further to the dashboards using PowerBI.

E-Commerce Data Analysis: Performed advanced SQL operations like joins, grouping, ranking, and subqueries to analyze customer behavior, product sales, and revenue trends. Database Management & Constraints: Applied DDL and DML commands to modify tables, enforce data integrity using constraints, and create views for category-wise product insights.

This project analyzes retail sales data using SQL to uncover insights into sales trends, customer behavior, category performance, and operational patterns. It covers key SQL concepts such as filtering, grouping, aggregation, ranking, and window functions, making it a practical hands-on project for data analysis and business insights.