tomisincodes / adventureworks-database-analysis-and-visualization-with-microsoft-powerbi-and-excel-and-sql Goto Github PK

View Code? Open in Web Editor NEW

I chose 'AdventureWorksLT2019.bak' and 'AdventureWorksLT2017.bak' data for analysis & visualization. The query editing was done in 'Microsoft SQL Server Management Studio' and the visualization part was using 'Microsoft Power BI'. Also for analysis, I used MS Excel and PowerBI's query tool.

adventureworks-database-analysis-and-visualization-with-microsoft-powerbi-and-excel-and-sql's Introduction

AdventureWorks-Database-Analysis-and-Visualization-with-Microsoft-PowerBI-and-Excel-and-SQL

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

Recommend Projects

tomisincodes / adventureworks-database-analysis-and-visualization-with-microsoft-powerbi-and-excel-and-sql Goto Github PK