Power BI project using the Adventure Works 2022 dataset

Project Highlights:

• Connected to SQL data in DirectQuery mode

• Modeled key tables: Products, SalesPersons, Territories, Orders, etc.

• Built a custom Dates table using DAX

• Created key measures:

- No. of Orders

- Subtotal, Tax, Freight, Due

- Quantity & Sales Growth %

• Designed a 3-page interactive dashboard featuring:

- Sales KPIs

- Sales vs. Tax Correlation

- Drillthrough for Salesperson Details

- Decomposition Tree

- Q&A Visual