The project focused on analyzing sales data from Adventure Works, with the objective of building a dynamic and interactive dashboard for executive-level insights.
Key highlights from the project:
Applied advanced Power Query techniques for data cleaning and preparation
Designed a star schema for optimized data modeling and performance
Developed custom DAX measures to calculate KPIs like Total Sales, Tax, Subtotal, and Orders by Date
Integrated features such as drill-through pages, bookmarks, and slicers to enhance user interaction
Built a responsive and visually clear dashboard tailored to business needs