Adventure Works Sales Analysis

AdventureWorks Sales Analysis

Project Overview

Performed sales data analysis using SQL Server and the AdventureWorks database to explore customer purchasing behavior, product performance, sales trends, sales territories, and salesperson performance.

The project involved querying and analyzing relational data using SQL techniques such as JOINs, aggregate functions, GROUP BY, HAVING, CASE statements, sorting, and subqueries to generate meaningful business insights.

The analysis focused on identifying high-value customers, top-performing products, sales performance across territories and salespeople, yearly sales trends, customer order behavior, and products generating above-average sales.

Tools & Technologies

SQL Server | T-SQL | AdventureWorks Database

Key Analysis Areas

Identified customers generating more than $10,000 in total sales.

Analyzed product sales and quantities to identify top-performing products.

Evaluated sales performance across different product categories.

Compared sales across different territories.

Analyzed salesperson performance based on total sales.

Examined yearly sales, order volume, and average order value.

Identified customers with multiple orders and high average order values.

Compared individual product sales against the average product sales using a subquery.

SQL Skills

JOINs | GROUP BY | HAVING | Aggregate Functions | CASE Statements | Subqueries | Data Analysis