top of page
Search

E-Commerce Site Sales Dashboard

  • KB
  • Sep 20
  • 1 min read

Updated: Oct 4

Power BI

2025


Power BI dashboard made from an E-Commerce site's sales data.

ree


Development & Features


  • High Clarity, clearly showing top performing items, revenue over time and percentage metrics for sales.

  • Slicers to filter dashboard by country and date

  • Data Wrangling - Cleaned missing and incomplete values from data and added new measures where appropriate (i.e. combining item price and quantity to find revenue).


Summary and Thoughts


This project was a good learning experience in a range of ways.


Unlike other practice dashboards I had made, this dataset came with duplicate and incomplete values. Additionally, many entries weren't formatted properly or were internal notes between employees (e.g. "products were damaged, returned", "reversing accidental order"), and were challenging to clean.

I experimented with separating out data into different tables (data normalisation) to get a clean base to work with.


Having made a few dashboards before this one, I'm gradually figuring out good practice by continually asking myself "Can I make this more clear? Can I make this more usable?".


In hindsight, I think the range of colours I chose could be improved, as well as the spacing of charts. My use of pie charts could be improved by limiting the number of elements visible at one time, and the bar charts for the sales and revenue of items could be combined into a single chart.


bottom of page