Better Data, Better Decisions June 11, 2012 Webinar CTA CONFERENCE - - PowerPoint PPT Presentation

▶
better data better decisions
SMART_READER_LITE
LIVE PREVIEW

Better Data, Better Decisions June 11, 2012 Webinar CTA CONFERENCE - - PowerPoint PPT Presentation

Dec 24, 2023 150 likes •342 views

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

slide-1
SLIDE 1

Better Data, Better Decisions

June 11, 2012 Webinar

HOW TO MANAGE & LEVERAGE THE DATA WE HAVE

CTA CONFERENCE 2015

slide-2
SLIDE 2

1

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

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

How to Manage & Leverage the Data We Have

slide-3
SLIDE 3

2

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

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

How to Manage & Leverage the Data We Have

slide-4
SLIDE 4

3

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

PAST SOLUTION – EXCEL

How to Manage & Leverage the Data We Have

Page 3

MAN – MACHINE INTERFACE EXCEL – MART

slide-5
SLIDE 5

4

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

PAST – STATIC REPORTS

Page 4

How to Manage & Leverage the Data We Have

slide-6
SLIDE 6

5

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

PAST – SIMPLE DASHBOARDS

Page 5

How to Manage & Leverage the Data We Have

slide-7
SLIDE 7

6

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

…AND TREND LINE DRILLDOWNS

Page 6

How to Manage & Leverage the Data We Have

slide-8
SLIDE 8

7

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

PERFORMANCE I NDI CATORS

 Cost Efficiency & Effectiveness

 Cost Per Revenue Hour  Cost Per Passenger  Cost Per Passenger Mile  Farebox Recovery Ratio  Average Fare Per Passenger

 Service Effectiveness

 Passengers Per Revenue Hour  Average Trip Length  Operating Speed

 Service Quality

 Roadcalls Per 100,000 Service Miles  Customer Complaints Per 100,000 Passengers*  Schedule Adherence*

 Safety & Security

 Accidents Per 100,000 Service Miles  Passenger Injuries Per 100,000 Passengers

* Not Required for NTD Reporting

Page 7

How to Manage & Leverage the Data We Have

TODAY – KPIs WITH NTD DATASTEM

slide-9
SLIDE 9

8

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

TODAY – NTD DATA DASHBOARDS

Page 8

How to Manage & Leverage the Data We Have

slide-10
SLIDE 10

9

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

…AND DRILLDOWNS

Page 9

How to Manage & Leverage the Data We Have

BRT Metro MidCity Suburban Commuter Community Rural Paratransit

slide-11
SLIDE 11

10

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

RIGHT NOW – BIG DATA ANALYTICS

How to Manage & Leverage the Data We Have

Page 10

slide-12
SLIDE 12

11

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

RIGHT NOW – BOARD REPORTS

How to Manage & Leverage the Data We Have

Page 11

slide-13
SLIDE 13

12

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

…AND DRILLDOWNS

Page 12

How to Manage & Leverage the Data We Have

Paratransit Rural MidCity Metro Commuter BRT Community Flex Route

slide-14
SLIDE 14

13

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

…AND SUBTYPE DRILLDOWNS

Page 13

How to Manage & Leverage the Data We Have

Rur al Paratransit Rural MidCity Metro Commuter BRT

slide-15
SLIDE 15

14

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

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

How to Manage & Leverage the Data We Have

Page 14

slide-16
SLIDE 16

15

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

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

  • verall 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? How to Manage & Leverage the Data We Have

Page 15

slide-17
SLIDE 17

16

California Transit Association Better Data, Better Decisions -- June 11, 2012 Webinar

BEST PRACTICES

How to Manage & Leverage the Data We Have

Page 16

 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