This project focuses on analyzing and visualizing e‑commerce sales data using Microsoft Excel. I ...This project focuses on analyzing and visualizing e‑commerce sales data using Microsoft Excel. I ...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Nityananda's avatar
Nityananda Khelo
• Aug 20
This project focuses on analyzing and visualizing e‑commerce sales data using Microsoft Excel. I designed a dynamic dashboard that consolidates key business metrics such as total revenue (₹5,022,392), total orders (1000), average sales value, and total quantity sold.
The dashboard integrates multiple interactive charts and filters:
Product by Discount – highlights discount distribution across items.
City by Amount – compares sales performance across major cities like Bengaluru, Chennai, Delhi, Kolkata, and Mumbai.
State by Quantity – shows product demand across states (WB, TN, MH, KA, DL).
Payment Method Analysis – pie chart breakdown of Card, Cash, NetBanking, and UPI transactions.
With timeline filters and customer/product selectors, the dashboard enables flexible exploration of sales trends.
Key Skills Demonstrated:
Data cleaning and preparation
Pivot tables and advanced Excel formulas
Dashboard design with interactive filters
Business insights through visualization
Impact: This dashboard provides a clear, data‑driven view of e‑commerce performance, helping identify top‑performing cities, customer preferences, and payment trends for better decision‑making.
Data AnalysisData VisualizationMicrosoft Excel
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started