Interactive Sales Dashboard

A Power BI Sales Analysis Project analyzing transactional data from 1997 to 1998 to assess sales performance across store types and regions in North America.

Period: 1997–1998

Tools: Power BI Desktop, DAX, Data Modeling

Project Highlights

Performed comprehensive sales and returns analysis across USA, Canada, and Mexico.

Cleaned and transformed raw transactional data to build a star schema with:

1 Fact Table: Sales

4 Dimension Tables: Products, Customers, Regions, Store Types

Built a 3-page interactive Power BI dashboard including:

Slicers

Drill-through pages

Tooltips

Navigation buttons

Bookmarks

Used DAX for dynamic calculations:

Time intelligence: SAMEPERIODLASTYEAR, PREVIOUSMONTH, etc.

Custom KPIs for year-over-year trends and monthly comparisons

Identified:

Top-performing products, brands, and store types

Regional performance across countries and cities

Delivered insights into customer behavior:

New vs. returning customers

Return rates

Strategic recommendations based on trends