Beyond Dashboards

What else can we do ?

Fixed Route Operations

Paratransit Operations

Finance G/L

Maintenance

Farebox

Customer Service

Business Intelligence

So, now that we have all this data in one place, what else can

we do with it?

Simplify tasks

Automate processes

Calculating Liquidated Damages

Contracted Operations - Limited staff for contract compliance

Need a way to identify and track items

Collect responses from agency and contractor

Help facilitate meeting to negotiate

Fixed Route Operations

Paratransit Operations

Customer Service

Business Intelligence

Liquidated Damages System: Fixed Route Operations Dispatch Log (OPS)

Date: 9/27/2011 Vehicle: 320 Route: 5 Reason: 61. LATE. Other Source Comments: 5e running down 20 min due to driver error, sup 6

will take over unit and continue route , will send back up as soon as available tlc - 30ths t e ave L

Minutes Late: 20

Liquidated Damages System: Fixed Route Operations Dispatch Log (OPS)

Date: 9/27/2011 Vehicle: 320 Route: 5 Reason: 61. LATE. Other Source Comments: 5e running down 20 min due to driver error, sup 6

will take over unit and continue route , will send back up as soon as available tlc - 30ths t e ave L

Minutes Late: 20 Contract Category: A-2 Late Trips >10 Minutes (LT) Contract Amount: ($200.00) Contractor Response: no contest Agency Comments:

Program: Local Transit

Liquidated Damages System: Paratransit Operations Scheduling (PASS)

Date: 10/01/2011 Time: 13:37:00 Route: DAR Type: Late Trip Source Comments: Run #117

Schedule Departure: 12:46 Pickup Address: 1000 E Palmdale Blvd Palmdale CA

Minutes Late: 51

Liquidated Damages System: Paratransit Operations Scheduling (PASS)

Date: 10/01/2010 Time: 13:37:00 Route: DAR Type: Late Trip Source Comments: Run #117

Schedule Departure: 12:46 Pickup Address: 1000 E Palmdale Blvd Palmdale CA

Minutes Late: 51 Contract Category: A-5abiii Late Trips >50 Minutes (DAR) Contract Amount: ($0.00) Contractor Response: This was a typo error we have the manifest to show

you if you wish. We were not late. Agency Comments: 10/21 LD waived Program: Dial-A-Ride

Liquidated Damages System: Complaints and Commendations (COM)

Date: 12/1/2009 Route: 12 Reason: COMPLAINT - Passed by on Street Source Comments: Record #2433

Liquidated Damages System: Complaints and Commendations (COM)

Date: 12/1/2009 Route: 12 Reason: COMPLAINT - Passed by on Street Source Comments: Record #2433 Contract Category: A-2 Late Trips >10 Minutes (LT) Contract Amount: ($200.00) Contractor Response: No Contest Agency Comments:

Program: Local Transit

But wait, there’s more!

Creating Contractor Invoice

Based on actual revenue hours for Fixed Route and Paratransit

Use FR service definition already in BI for Dashboards & KPI’s

Capture exceptions as part of Daily Dispatch Log

Pull Paratransit revenue hours directly using performed trips

Mileage by Exception System: Fixed Route Operations Dispatch Log (OPS)

Date: 9/28/2011 Time: 16:27 Vehicle: 4340 Route: 1 Direction: East Incident Reason: 14. Miss Trip. Missed Trip

Mileage by Exception System: Fixed Route Operations Dispatch Log (OPS)

Date: 9/28/2011 Time: 16:27 Vehicle: 4340 Route: 1 Direction: East Incident Reason: 14. Miss Trip. Missed Trip # Missed Trips: 1 Change in Revenue Hours: -1.35 Program: Local Transit

Just one more thing…

Sending Email Notifications from BI data

We already have in import capability built-in to the system

Real-time events are recorded in the Daily Operations Log

So, why not use this to alert appropriate staff?

Late Bus Missed Trip

10-3 Call Police 10-31 Accident w/Injuries

10-29 Brakes Fail Unit Running Slow

Maintenance

Management

Customer Service

AVTA Incident Report

Incident Number #104297

Date 07/01/2011 Time 13:59

Incident Type 42. MAINT -- Unit Overheated

Incident Description UNIT OVER HEATING. CHECK ENGINE LIGHT AND BELLS GOING OFF WILL ADVISE BASE WHEN UNIT IS COOLED AND HE IS 10-8. TL

Dispatcher Barney Ruble

Vehicle Number 4340

Driver George Jetson Badge # 2720

Route 11 Block 1102 Time Loss (Min) 0

Location of the Incident I AND 15TH ST E

Direction & Passenger Count

Road Supervisor Wilma Flintstone Time Dispatched 13:59

10-8 Unit On-time 10-88 Passenger w/ weapon on board

Questions?