This project focuses on analyzing the Central Superstore dataset to extract meaningful business insights using Python and SQL Server.
The project includes:
Data cleaning and validation using Python, Pandas, and NumPy.
Exploratory Data Analysis (EDA) using Matplotlib and Seaborn.
Designing a relational database with a Star Schema structure.
Writing advanced SQL queries using joins, CTEs, subqueries, and aggregations.
Analyzing sales, profit, customer behavior, product performance, and regional trends.
Presenting findings and actionable business recommendations.
The goal was to transform raw data into structured information that supports better business understanding and data-driven decision-making.