AC Transit Enterprise Database and Applications C TA 5 0 T H A N N - PowerPoint PPT Presentation

AC Transit Enterprise Database and Applications C TA 5 0 T H A N N U A L FA L L C O N F E R E N C E , PA S A D E N A , 11 / 1 8 / 2 0 1 5 P I U S H D A H A L , S O F T WA R E E N G I N E E R , A L A M E D A - C O N T R A C O S TA T R A N S I T D I S T R I C T actransit.org

Overview  Enterprise Database initiative  Started 5 years ago with Key Performance Indicators (KPIs) project actransit.org

Key Performance Indicators (KPIs)  Decision Makers are …  Managing with KPIs  Frequencies: Daily, Monthly, Quarterly, Yearly actransit.org

Performance Dashboard # KPIs Data Source 1 On-Time CADAVL (Arrivals) Performance 2 Operator Log-On OTS (Bus Pull Outs, Operator Rate Logons) 3 Maintenance Road Ellipse (Vehicle Miles) Calls Road Calls Application 4 Service Operated CADAVL (# Incidents, # Trips Percentage Scheduled) 5 Accident Rates Ellipse (Vehicle Miles) PeopleSoft (# Accidents) 6 Maintenance PeopleSoft (TRC, Manpower Department, Attendance) Unavailability 7 Operator PeopleSoft (TRC, Operator Unavailability Attendance) 8 Ridership APC (Average Passengers) 9 Service Efficiency PeopleSoft (Passenger Fare Standards Revenues) 10 Customer CusRel (# Complaints), APC Complaints (Ridership Boarding's) 11 Fare Revenue PeopleSoft FIN(Accounts) actransit.org

On Time Performance KPI  Closer look – Daily, System Wide actransit.org

On Time Performance KPI (cont.)  Closer look – Daily, All actransit.org

AC Transit API  Leverage Enterprise Database to publish API actransit.org

Making Difference Public Facing KPI SSRS Reports Training and Education Bus Stop Work Orders Mobile Site Vehicle Locator Customer Relations Bus Pull Out actransit.org

Questions… actransit.org