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

This is stars and forks stats for /AhmadSabbirChowdhury/Microsoft-AdventureWorks-Database-Analysis-Visualization-with-PowerBI repository. As of 02 May, 2024 this repository has 61 stars and 19 forks.

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. 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 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.