/AdventureWorks-DB-EDA-with-SQL-and-PowerBI-

Microsoft AdventureWorks Database analysis using MS SQL Server and visualization with PowerBI.

Primary LanguageJupyter NotebookApache License 2.0Apache-2.0

AdventureWorks-DB-EDA-with-SQL-and-PowerBI-

Welcome to the AdventureWorks Database Analysis and Visualization project!

Project Overview

This project aims to provide insights and visualizations into the AdventureWorks database, which is a sample database provided by Microsoft for learning and testing purposes.

The AdventureWorks database contains data related to a fictitious bicycle manufacturer, including information on products, sales, customers, and employees. In this project, we will use Microsoft Power BI to analyze and visualize the data in order to gain a better understanding of the business operations of AdventureWorks.

To get started with this project, you will need to have access to the AdventureWorks database and have Microsoft Power BI installed on your computer. The analysis and visualization will be performed through Power BI, and the results will be presented in the form of interactive reports and dashboards.

Prequirement

Database - AdventureWorksDW2019.bak

Requirements

  • Query Editing Tool - Microsoft SQL Server Management Studio (SSMS)
  • Visualization Tool - Microsoft PowerBI

The following tables were chosen for analysis:

  • DimCustomer.sql
  • DimDate.sql
  • DimProducts.sql
  • FactInternetSales.sql
  • DimGeography.sql

Data Visualization

i. Entity Relationship Diagram Model

Image

ii. Sales Overview Dashboard

Image

iii. Product Details Dashboard

Image

iv. Customer Details Dashbaord

Image

I hope that this project will be a valuable resource for anyone looking to learn more about data analysis and visualization using Microsoft Power BI.