Better Data, Better Decisions June 11, 2012 Webinar CTA CONFERENCE 2015 HOW TO MANAGE & LEVERAGE THE DATA WE HAVE
How to Manage & Leverage the Data We Have DATA OVERLOAD TO INFORMATION PAST – How We Reported TODAY – What Is Possible With NTD Data RIGHT NOW – What is Possible With Big Data Page 1 California Transit Association 1 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have PROBLEM – DATA OVERLOAD Overwhelmed with data from multiple sources Credibility and reliability impacted by data inconsistencies Collecting and maintaining data is expensive and time-consuming Significant investment in ITS to get detailed data; timely management information is missing Page 2 California Transit Association 2 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have PAST SOLUTION – EXCEL MAN – MACHINE INTERFACE EXCEL – MART Page 3 California Transit Association 3 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have PAST – STATIC REPORTS Page 4 California Transit Association 4 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have PAST – SIMPLE DASHBOARDS Page 5 California Transit Association 5 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have …AND TREND LINE DRILLDOWNS Page 6 California Transit Association 6 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have TODAY – KPIs WITH NTD DATASTEM PERFORMANCE I NDI CATORS Cost Efficiency & Service Quality Effectiveness Roadcalls Per 100,000 Service Cost Per Revenue Hour Miles Cost Per Passenger Customer Complaints Per 100,000 Passengers* Cost Per Passenger Mile Schedule Adherence* Farebox Recovery Ratio Safety & Security Average Fare Per Passenger Service Effectiveness Accidents Per 100,000 Service Miles Passengers Per Revenue Hour Passenger Injuries Per Average Trip Length 100,000 Passengers Operating Speed * Not Required for NTD Reporting Page 7 California Transit Association 7 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have TODAY – NTD DATA DASHBOARDS Page 8 California Transit Association 8 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have …AND DRILLDOWNS BRT Metro MidCity Suburban Commuter Community Rural Paratransit Page 9 California Transit Association 9 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have RIGHT NOW – BIG DATA ANALYTICS Page 10 California Transit Association 10 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have RIGHT NOW – BOARD REPORTS Page 11 California Transit Association 11 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have …AND DRILLDOWNS Paratransit Rural MidCity Metro Commuter BRT Community Flex Route Page 12 California Transit Association 12 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have …AND SUBTYPE DRILLDOWNS Paratransit Rural Rur MidCity al Metro Commuter BRT Page 13 California Transit Association 13 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have MANAGE & LEVERAGE Key Indicators & Data – Decide on what to collect and how often to report; keep it simple Best Practices – Document sources and on-going processes; provide data definitions; assign Data Managers Business Intelligence Implementation – Get data at the source; eliminate time-consuming data reconciliations Management Commitment – Involve team in regular data reviews and analyses On-Going Training – Expect turnover & new systems Page 14 California Transit Association 14 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have KEY INDICATORS & DATA Decide on what to collect and how often to report Who will be using data and for what purpose? How important is data to overall agency performance? What performance results do you want to achieve? Keep it simple Can you explain it in an elevator ride? Can you explain it at a public meeting? Page 15 California Transit Association 15 Better Data, Better Decisions -- June 11, 2012 Webinar
How to Manage & Leverage the Data We Have BEST PRACTICES Provide data definitions Make use of definitions for NTD and other compliance reporting Set performance targets for key indicators Past performance Current year budget & service plan Best in class – peer data Communicate Can’t win the game if you don’t know the score Data Managers Page 16 California Transit Association 16 Better Data, Better Decisions -- June 11, 2012 Webinar
Recommend
More recommend
