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

ac transit enterprise database and applications
SMART_READER_LITE
LIVE PREVIEW

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


slide-1
SLIDE 1

actransit.org

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

AC Transit Enterprise Database and Applications

slide-2
SLIDE 2

actransit.org

Overview

 Enterprise Database initiative

 Started 5 years ago with Key Performance Indicators (KPIs) project

slide-3
SLIDE 3

actransit.org

Key Performance Indicators (KPIs)

 Decision Makers are …

 Managing with KPIs  Frequencies: Daily, Monthly, Quarterly, Yearly

slide-4
SLIDE 4

actransit.org

Performance Dashboard

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

slide-5
SLIDE 5

actransit.org

On Time Performance KPI

 Closer look – Daily, System Wide

slide-6
SLIDE 6

actransit.org

On Time Performance KPI (cont.)

 Closer look – Daily, All

slide-7
SLIDE 7

actransit.org

AC Transit API

 Leverage Enterprise Database to publish API

slide-8
SLIDE 8

actransit.org

Making Difference

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

slide-9
SLIDE 9

actransit.org

Questions…