Key points from the dashboard
- The dashboard covers 29,575 women’s fashion products across seven categories, with an average MRP (list price) of 2,817, an average selling price of 1,924 and an average discount of 34.23%.
- Indianwear and Westernwear dominate, with 9,975 products each, 33.73% of the catalogue apiece. Fragrance is smallest at 475 products (1.61%).
- Watches have by far the highest average price, 8,657, against 918 for Lingerie&Nightwear, the cheapest category.
- The most common discount band is 45%, with 9,717 products, followed by no discount (7,791). Only 292 products are in the 75% band.
- In six of the seven categories most products are priced below the category average. Fragrance is the exception, with 240 of 475 above it.
Fashion ecommerce analytics dashboard in text
Title: E-Commerce in Women Fashion Analytics Dashboard. KPI cards: Total Product Count 29,575; Category Rate 100.00%; Avg. MRP 2,817; AVG([Discount])*0.01 34.23%; Avg. Sell Price 1,924. A Category filter lists Footwear, Fragrance, Indianwear, Jewellery, Lingerie&Nightwear, Watches and Westernwear, all ticked.
The dashboard has five panels: Avg Price by Category (bars, 0K to 8K), No. Products by Discount Group (histogram, bin size 15, coloured from 292 to 9,717 products), Discount Group by Category (heat map table), Category Size (pie chart) and Price Distribution by Category (one donut per category, orange for above average price and blue for below). The first table combines the size, price and price distribution panels; the second is the discount table as shown.
| Category | Products | Share of products | Average price | Above category average | Below category average |
|---|---|---|---|---|---|
| Footwear | 2,475 | 8.37% | 2,194 | 981 (39.64%) | 1,494 (60.36%) |
| Fragrance | 475 | 1.61% | 3,972 | 240 (50.53%) | 235 (49.47%) |
| Indianwear | 9,975 | 33.73% | 1,484 | 4,157 (41.67%) | 5,818 (58.33%) |
| Jewellery | 1,725 | 5.83% | 2,164 | 487 (28.23%) | 1,238 (71.77%) |
| Lingerie&Nightwear | 3,225 | 10.90% | 918 | 1,150 (35.66%) | 2,075 (64.34%) |
| Watches | 1,725 | 5.83% | 8,657 | 590 (34.20%) | 1,135 (65.80%) |
| Westernwear | 9,975 | 33.73% | 1,318 | 3,871 (38.81%) | 6,104 (61.19%) |
Products by discount group (bins of 15 percentage points; a blank cell means no products):
| Category | 0 | 15 | 30 | 45 | 60 | 75 | Grand total |
|---|---|---|---|---|---|---|---|
| Footwear | 860 | 289 | 542 | 755 | 27 | 2 | 2,475 |
| Fragrance | 322 | 117 | 28 | 8 | 475 | ||
| Indianwear | 1,703 | 438 | 1,178 | 4,150 | 2,257 | 249 | 9,975 |
| Jewellery | 915 | 96 | 81 | 228 | 405 | 1,725 | |
| Lingerie&Nightwear | 1,271 | 146 | 645 | 1,006 | 150 | 7 | 3,225 |
| Watches | 845 | 227 | 384 | 143 | 126 | 1,725 | |
| Westernwear | 1,875 | 925 | 2,508 | 3,427 | 1,206 | 34 | 9,975 |
| Grand total | 7,791 | 2,238 | 5,366 | 9,717 | 4,171 | 292 | 29,575 |
What the numbers show
Discounting is heaviest in the two largest categories. Two thirds of Indianwear products (6,656 of 9,975) are in the 45% band or higher, and so are 4,667 Westernwear products, 46.8% of that category (our arithmetic from the table). Across the whole catalogue, 47.9% of products are discounted by 45% or more.
Fragrance is the least discounted: 322 of its 475 products (67.8%) are in the zero band and only 8 are in the 45% band. Jewellery (53.0%) and Watches (49.0%) also have about half their products undiscounted.
Prices are skewed. In most categories more than 60% of products sit below the category average, which suggests a smaller number of expensive items lifts the average. Jewellery is the most skewed, with 71.77% below average.
The average selling price of 1,924 is 31.7% below the average MRP of 2,817 (our arithmetic), a little less than the 34.23% average discount. The two measures differ because one averages the discount on each product while the other compares average prices, which fits with pricier categories being discounted less often; 49.0% of watches carry no discount.
Who made it
The dashboard was published on Tableau Public by Irene Shi as “Women Fashion Ecommerce”, first published on 12 August 2024 and last updated on 19 August 2024 [1]. Its description reads: “I made the dashboard with the initiative of developing an e-commerce small business and wanting to better understand the women fashion market so that I would be able to select a specific category of products” [1]. The current version labels the fourth KPI “Avg. Percentage Discount”; the graphic here shows the earlier label “AVG([Discount])*0.01”, a raw Tableau calculation name.
Notes on this infographic
- The dashboard does not name its data source, the shop or platform the products were listed on, the date the data was collected, or the currency. MRP (maximum retail price) and the Indianwear category suggest an Indian retailer priced in rupees, but this is not stated, so we leave prices without a currency.
- The data counts product listings, not sales. “Sales analytics” figures such as revenue or units sold are not shown.
- Category Rate shows 100.00% because every category is ticked in the filter.
- Footwear (8.37%) and Watches (5.83%) have no labels on the pie chart; their shares in the table are calculated from the product counts.
Questions about women's fashion ecommerce
What is the average discount on women's fashion products?
Across 29,575 women's fashion products on the dashboard, the average discount is 34.23%, with an average MRP (list price) of 2,817 and an average selling price of 1,924. The most common discount band is 45%, with 9,717 products, followed by no discount at 7,791 products. Only 292 products are in the 75% band.
Which women's fashion category is the most expensive?
Watches have by far the highest average price, at 8,657, against 918 for Lingerie&Nightwear, the cheapest category. Fragrance is second at 3,972, followed by Footwear at 2,194 and Jewellery at 2,164, while Indianwear averages 1,484 and Westernwear 1,318. The dashboard does not state the currency, so prices are shown without one.
Which fashion products are discounted the least?
Fragrance is the least discounted category, with 322 of its 475 products (67.8%) in the zero discount band and only 8 in the 45% band. Jewellery (53.0%) and Watches (49.0%) also have about half their products undiscounted. Discounting is heaviest in Indianwear, where two thirds of products (6,656 of 9,975) are in the 45% band or higher.
Who made the women's fashion ecommerce dashboard?
Irene Shi published it on Tableau Public as "Women Fashion Ecommerce", first on 12 August 2024, with a last update on 19 August 2024 [1]. The creator made it while planning an e-commerce small business, to better understand the women fashion market and select a specific category of products [1]. The dashboard does not name its data source, the shop or platform, the date the data was collected or the currency.
Sources
- Irene Shi, Women Fashion Ecommerce, Tableau Public, first published 12 August 2024. The creator’s page for this dashboard.
Last reviewed 30 October 2026
