Data & analytics

Brightway Sales Performance Dashboard

An Excel dashboard tracking six months of retail sales across stores, product categories and online channels.

Status
Prototype Portfolio case study
Access
Demo currently unavailable
Type
Concept
Role
Dashboard design and analysis by Daramola Joseph Omoyele.
Built with
  • Microsoft Excel
Link checked
Portfolio case study (10 October 2026)
Brightway Excel dashboard with seven sales KPIs, four slicers and six charts.
April to September 2025 sales dashboard using fictional Brightway retail data.

The problem

Monthly sales files need consistent categories and revenue definitions before stores and channels can be compared.

Who it is for

Retail managers and analysts reviewing sales across channels.

What was built

Used Power Query to prepare monthly files and built a dashboard with connected slicers and pivot charts.

Key features

  • Month, store, sales channel and category slicers
  • Gross sales, net revenue, orders and average order value
  • Return and discount rates
  • Monthly trends and comparisons by product, store and channel

Results so far

The fictional dataset shows £1.62m in net revenue from April to September 2025, with website sales contributing just over half.

Limitations and context

  • The portfolio presents a dashboard screenshot.