Skip to content
VD
All projects

Data Analytics & BI, 2024

E-commerce Sales Dashboard

A Power BI dashboard tracking an Indian online store's sales performance with interactive drill-downs.

Sales amount by categoryOrders.csv + Details.csvElectronics166,267Clothing144,323Furniture127,181Payment mode shareCOD35%Credit card20%EMI18%UPI16%Debit card11%

The problem

A store owner needed one place to track sales across India and see which strategies, categories and regions were working.

What it does

  • KPIs for sales amount, profit and quantity, joined across orders and order-detail tables.
  • Time-series analysis of sales trends.
  • Breakdowns by state, category, sub-category and payment mode with interactive filters.

Built with

  • Power BI
  • DAX
  • Excel

From the repository

Screenshots and charts as they appear in the project's code and notebooks.

Power BI e-commerce sales dashboard
Power BI e-commerce sales dashboard