Power BI
🇮🇳 India RTO Vehicle Sales Report — 13 States | 432 RTOs
486K+ records • 2020–2026
📊 National
🏛 State RTO
🚗 Vehicle Class
🏭 Manufacturers
⚙️ Update Data
State-wise Registrations (2025 Summary)
13 States — RTO Data Year Trend
State-wise RTO Data — Year Breakdown
Monthly Trend — Top 5 States (2025 Summary)
National Summary Table (28 States)
👆 Click any RTO row for monthly drilldown
RTO-wise Registrations
Year-on-Year Trend
Fuel Type
New vs Resale
Vehicle Class
All RTOs — Year-wise — Click for Drilldown 🖱
Vehicle Class Distribution
Vehicle Class — Stacked by Year
Fuel Type
New vs Resale
RTO × Vehicle Class Table
Click row → Manufacturer drilldown
Top Manufacturers
Top 5 — Yearly Trend
Top 5 — State Presence
Top Manufacturer — RTO Split
Manufacturer Ranking

Manufacturer Report

Monthly Sales
Year-wise Growth
Top RTOs
State-wise Distribution
Month × Year Table

RTO Report

Monthly Sales
Year-wise Growth
Vehicle Class
Month × Year Table

⚙️ Data Manager — Upload & Update Monthly Data

Upload state .xlsx files monthly. Only the specific year+month in your file gets updated — all other data stays untouched.

📊 Currently Loaded Data

🔒 Authorized Access Required

Enter admin password to upload or modify data.

📋 File Format — Your Excel must have these columns

One sheet per year (sheet names: 2020, 2021, 2022, etc.) or single sheet with all years.

ColumnExampleNeed
registration_year2024✅
registration_monthJanuary✅
stateBihar✅
rto_codeBR01✅
rto_namePATNA✅
maker_nameSAERA ELECTRIC✅
vehicle_class_namee-Rickshaw(P)✅
vehicle_count15✅
fuel_nameElectric(BOV)Optional
sale_typeNewOptional
India RTO Vehicle Sales Dashboard • 13 States • 432 RTOs • 486K+ Records • Power BI Style