Executive Retail Analytics Dashboard | Power BI

Work type: Business Intelligence (BI) retail analytics dashboard covering sales, profit and shipping delays, built in Power BI with two pages.

Overview

An executive dashboard that helps management see sales and profit performance in seconds, which regions, products and customers drive the most revenue, and which product categories suffer the most shipping delays.

Page 1: Executive Analysis

- Key KPIs: Total Sales, Total Profit, Profit Margin % and Year-over-Year Sales Growth

- Interactive filters by region and year, updating every visual automatically

- Monthly sales with a running total

- Sales by category: Office Supplies, Technology and Furniture

Page 2: Product & Shipping Analysis

- Sales map by state showing the geographic spread

- Shipping delay by sub-category, with the most delayed clearly visible (Binders, then Paper, then Furnishings)

- Treemap of sales by customer and product to spot the biggest customers

- Detailed table of shipping delay and sales by sub-category, region, year, quarter and month

Key features

- Clean data model with a date table, Orders, Regional Sales and People tables, plus a dedicated measures table, so numbers are accurate and fast

- Fully interactive and easy to read for non-technical managers

- Consistent design with clear colors and titles

How I built it

1. Understood the data and defined the questions (how are sales and profit performing? which products are delayed the most?)

2. Cleaned and prepared the data with Power Query

3. Built the data model and connected the tables with relationships, including a dedicated date table

4. Created DAX measures (profit margin, YoY growth, running total and more)

5. Designed the visuals, linked them together and formatted colors and titles

6. Checked every number for accuracy before delivery

Tools: Power BI, DAX, Power Query, data modeling, dashboard design

I can build a similar dashboard for your company's data, delivered on the agreed date with every number checked before hand-off.