Electronics Retailer Dashboard - Big Picture

Retail leaders don’t want 20 tabs. They want one screen that answers:

Are we making money? What’s driving it? What needs fixing now?

So I built a Power BI dashboard for Big Picture (It's a small agency in the UK that crafts data solutions for giants like Amazon, Dell, Microsoft). The dataset is the classic Contoso global retail data, cleaned and upgraded to behave like a real business. (If you can't see the whole dashboard, just select the fit to page button near the zooming feature. Also feel free to play around by clicking the dark grey areas in the map, it's interactive!)

What’s in the data?

• Sales lines: quantity, net price, unit cost, exchange rate → USD revenue & USD cost

• Orders: order date, delivery date → delivery days

• Products: brand, category, product name

• Stores: store name, country, size (m²)

• Customers: basic demographics (for slicing)

• Date: year, quarter, month

Link to dataset

What’s on the dashboard?

It has two sections : 1) Summary (for execs)

The Summary page is the executive view: five KPIs up top-revenue, units, profit, COGS, and profit margin with last year and a YoY arrow that only shows when you pick a single year (so the math is honest).

Below that, you can see which stores are pulling the most weight, and which countries/continents are driving sales on a clean map and bar combo.

Green means the business is moving the right way (revenue/profit/margin up, or COGS/delivery down), and there’s a one-click reset to clear filters.

2) Sales (deep dive)

The Sales page is the deep dive. You can move from brand → category → product, and flip the view between revenue and quantity to spot premium items (high revenue, lower units) versus volume drivers (high units, thinner margins).

There’s a tidy product table with revenue, units, average price, and margin percent, and everything cross-filters, pick a country or store and the whole page snaps to it.

Insights

I’ll add a short explainer video and key insights here soon, stay tuned