SQL Exploratory Data Analysis

This repository contains exploratory data analysis on a sales data warehouse using SQL Server to uncover customer, product, and sales insights.

Objectives

• Explore the database schema and dimensions.
• Perform data quality checks and profiling.
• Analyze customer, product, and sales data.
• Generate key business metrics and KPIs.
• Identify top and bottom performing products and customers.

Analysis Performed

Database Exploration

• Listed all tables in the data warehouse.
• Explored table schemas, columns, and data types.

Dimension Exploration

• Analyzed customer locations.
• Explored product categories and subcategories.
• Examined the product hierarchy.

Data Profiling

• Checked for missing values.
• Identified duplicate records.
• Validated important business fields.

Date Exploration

• Determined the sales period covered by the dataset.
• Calculated customer age information.

Measures Exploration

Generated important business KPIs including:

• Total Sales Revenue
• Total Items Sold
• Average Selling Price
• Total Orders
• Total Products Sold
• Total Customers
• Customers Who Placed Orders

Magnitude Analysis

• Revenue analysis by product category.
• Customer distribution by country and gender.
• Product distribution across categories.
• Sales distribution across countries.

Ranking Analysis

• Top revenue-generating products.
• Lowest-performing products.
• Highest-value customers.
• Customers with the fewest orders.

Skills Demonstrated

• SQL
• Joins
• Aggregations
• GROUP BY
• Common Table Expressions (CTEs)
• Data Profiling
• Business Analytics