AdventureWorks Sales Analysis (Power BI)

Designed a complete Power BI dashboard using the AdventureWorks dataset.

> Data Modeling:

- Star Schema with fact and dimension tables

- Created product & date hierarchies

- Created a custom Date table using DAX (Year, Month, Day, etc.)

Measures & Calculations:

- Orders, Subtotal, Tax, Freight, Due

- Used `USERELATIONSHIP` to compare Order Date, Ship Date, and Due Date

- Created DAX table for storing and organizing measures

> Visualizations:

- Line charts, Matrix (Territories × Years)

- Drill Down & Drill Through

- Bookmarks to toggle between charts

- Max Quantity per Product