I chose 'AdventureWorksLT2019.bak' and 'AdventureWorksLT2017.bak' data for analysis & visualization.

The query editing was done in 'Microsoft SQL Server Management Studio' and visualization part was using 'Microsoft Power BI'. Also for analysis I used MS Excel and PowerBI's query tool.

Database Link: https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

From the link above, "AdventureWorksLT2019.bak" and "AdventureWorksLT2017.bak" data were chosen for restoration. From "AdventureWorksDW2019" Database, the following tables were chosen for analysis:

Dim_Customer.sql

Dim_Products.sql

Dim_Date.sql

FactInternetSales.sql

Query Editing Tool: "Microsoft SQL Server Management Studio"

Visualization Tool: "Microsoft Power BI"

DATA VISUALIZATION i. Entity Relationship Diagram Model

ii. Sales Overview DASHBOARD

iii. Customer Details DASHBOARD

iv. Product Details DASHBOARD