Skip to content

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.

Notifications You must be signed in to change notification settings

AhmadSabbirChowdhury/Microsoft-AdventureWorks-Database-Analysis-Visualization-with-PowerBI

Repository files navigation

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

Microsoft AdventureWorks Database Analysis and Visualization with PowerBI. It's sample database, 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.

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

  1. Dim_Customer.sql
  2. Dim_Products.sql
  3. Dim_Date.sql
  4. FactInternetSales.sql

Query Editing Tool: "Microsoft SQL Server Management Studio"

Visualization Tool: "Microsoft Power BI"

DATA VISUALIZATION

i. Entity Relationship Diagram Model

1  Model Relations

ii. Sales Overview DASHBOARD

2  Sales Overview

iii. Customer Details DASHBOARD

3  Customer Details

iv. Product Details DASHBOARD

4  Product Details

Note: The PowerBI online publishing link isn't available right now because of subscription issues. I'll add that online link soon, so anyone can open it and interact with it as the whole thing is very dynamic.

About

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.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages