Sales_Data-Analysis_with_SQL

Repository containing a T-SQL script file with a Sales data analysis from the AdventureWorks sample data. Microsoft offers the AdventureWorks data set to provide a sample database, data warehouse, and OLAP cube.

Project Objective

This Sales data analysis was completed for self-learning purpose and to practice my skills with T-SQL queries. I have also restored the AdventureWorks data warehouse into SQL server 2019 using the graphical interface (GUI) in SQL Server Management Studio.

In this project I was able to:

Retrieve data from the AdventureWork database;

Join data with other related tables;

Aggregate data; and

Perform complex analysis using CTE and Rank.

Conclusion:

I have always enjoyed working with SQL and I was impressed with its capability to perform queries in large datasets. Working with SSMS was easy and really helped to optimize my queries and speed data processing.