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.
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.
Retrieve data from the AdventureWork database;
Join data with other related tables;
Aggregate data; and
Perform complex analysis using CTE and Rank.
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.