Enterprise Analytics & BI PlatformPRODUCTION● LIVE

Business Intelligence Dashboard

ClickHouse · Kafka · Redis · Data Warehouse · 142M Events/Day · Sub-50ms Queries

💹↑ 22.4%
₹48.2Cr
GMV Today
💰↑ 18.7%
₹4.82Cr
Net Revenue
👥↑ 14.2%
2.84M
Active Users
📦↻ Real-time
48,291
Live Orders
🏦↑ 19.1%
₹1.44Cr
Platform Fee
📢↑ 31.2%
₹2.84Cr
Ads Revenue
⚡↑ 8.4%
142M
Events/Day
⏱️p99: 120ms
48ms
Query Latency
DATA PIPELINE:Event Capture→Kafka Stream→ClickHouse Ingest→Real-Time Aggregation→Data Warehouse→OLAP Queries→AI Processing→Cache Layer→API Gateway→BI Dashboard
DATA SOURCES:ClickHouse: 142M/dayKafka Topics: 84 topicsRedis Cache: Sub-msPostgreSQL: TransactionalOpenSearch: 100M productsData Warehouse: 3 years historyML Feature Store: AI modelsEvent Bus: 48 event types
💹+22.4%
₹482 Cr
Gross Merchandise Value
Monthly GMV
💰+18.7%
₹48.2 Cr
Net Revenue
Monthly Revenue
📈+21.3%
₹14.5 Cr
Gross Profit
After COGS
🏦+19.1%
₹1.44 Cr
Platform Fee
Commission Income
📢+31.2%
₹2.84 Cr
Ads Revenue
Advertising Income
🚀+24.8%
₹8.2 Cr
Net Profit
After All Expenses

GMV & Revenue Trend

Monthly performance — Feb to Aug 2025

₹284Cr
Feb
₹312Cr
Mar
₹298Cr
Apr
₹341Cr
May
₹387Cr
Jun
₹421Cr
Jul
₹482Cr
Aug

Revenue Breakdown

By source — August 2025

Platform Commission₹1.44Cr
29.9% of total
Advertising Revenue₹2.84Cr
58.9% of total
Shipping Revenue₹0.28Cr
5.8% of total
Payment Revenue₹0.14Cr
2.9% of total
Premium Seller Fees₹0.12Cr
2.5% of total

Growth Metrics

+2.4%
Daily Growth
vs Yesterday
+14.2%
Weekly Growth
vs Last Week
+22.4%
Monthly Growth
vs Last Month
+67.8%
Quarterly Growth
vs Last Quarter
+184.2%
Yearly Growth
vs Last Year
₹284 Cr
YTD Revenue
Jan–Aug 2025

Platform Metrics

4.82M
↑ 19.4%
Total Orders
₹1,248
↑ 4.2%
Avg Order Value
84,291
↑ 12.8%
Active Sellers
2.84M
↑ 22.1%
Active Buyers
4.82M
↑ 8.4%
Products Listed
12,847
↑ 2.1%
Categories
3.84%
↑ 0.42%
Conversion Rate
4.2%
↓ 0.8%
Return Rate

Data Architecture

⚡
ClickHouse OLAP
Sub-second analytical queries on 142M daily events. Columnar storage, distributed sharding, MergeTree engine.
🌊
Kafka Streaming
84 topics, 142M events/day. Real-time event ingestion from all platform microservices with exactly-once semantics.
🔴
Redis Cache Layer
Sub-millisecond dashboard cache. Pre-aggregated KPIs refreshed every 30s. Cluster mode with 6 nodes.
🏛️
Data Warehouse
Snowflake-compatible schema. 3 years of historical data. dbt transformations. Scheduled ETL pipelines.