Infrastructure Company
Data warehouse & Reporting
Use Case
- Data from 11 toll plazas are consolidated manually and being reported
- These toll plazas have different systems developed by 3 vendors
- FASTag being implemented during the development of analytical solutions
- Complex dataset with multiple interfaces and reconciliation
- Interface with NPCI
Benefits
- Revenue leakage at various levels was addressed
- The huge volumes of data can be drilled down to the level of individual vehicle passing through the toll
- The reports address various fronts like Revenue, FASTag usage and reconciliation through NCPI, Exemption, violation, end of shift, Cash at vault
Users
- Enterprise level
Dashboard
- Revenue leakage
- Toll wise collections
- FasTag reconciliation
- Cash vault dashboards
- Revenue analysis
- Vehicle category, Toll, distance, Cash/FasTag