📝🏷️ Customer Product Sales 🏷️📝

📊💻 SQL + POWER BI 💻📊

Description:

This analysis aimed to visualize the product and customer sales from the data. SQL was utilized to clean and filter data of interest. Four CSV files were exported from SQL, which was then used in Power BI for dashboard visualization.

The dataset used for this analysis was AdventureWorksDW2022 from Microsoft. This dataset was AdventureWorksDW2022.bak and AdventureWorksLT2022.bak file was used for restoration in SSMS.

Tools used for this analysis:

• Microsoft SSMS 19
• SQL Server 2019
• Power BI

What I've learned:

1. Power BI visualization and dashboard.
2. Creating new measures using DAX formulas.
3. Entity relationship diagram modeling.

CUSTOMER-PRODUCT-SALE VISUALIZATION (POWER BI)

You can access the dashboard here!

Entity relationship diagram

Sales dashboard

Customer dashboard

Product dashboard

Credits:

• Microsoft Adventure Works 2022 Dataset