beyond dashboards - transtrack systems€¦ · beyond dashboards cta conference 2011, san jose, ca...
TRANSCRIPT
![Page 1: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/1.jpg)
Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director
November 3, 2011
![Page 2: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/2.jpg)
The mission of Foothill Transit is to
be the premier public transit
provider committed to safety,
courtesy, quality, responsiveness,
efficiency, and innovation.
Foothill Transit Mission
![Page 3: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/3.jpg)
Unique Public/Private Partnership Public: Joint Powers Authority 22 member-cities
Los Angeles County
Representatives from each
Private: Contracted Administration
and Operations Administration – Veolia Transportation
Pomona Operation Facility – First Transit
Arcadia Operations Facility – MV Transportation
Executive Board President Carol Herrera
Vice President Patricia Wallach
Treasurer Paula Lantz
Member Roger Chandler
Member Doug Tessitor
Agency Structure
![Page 4: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/4.jpg)
Foothill Transit Region
327 Square Miles San Gabriel Valley
Pomona Valley
Downtown Los Angeles
33 fixed-route lines
![Page 5: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/5.jpg)
Agency Statistics
Fleet 300 Vehicles
Service Hours
690,000/year
Service Miles ~12M /year
Passenger Boardings
~14,000,000/year
FY 2012 Budget
Operations $68M
Capital $56M
Total $124M
![Page 6: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/6.jpg)
Where’s the data coming from?
![Page 7: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/7.jpg)
Taming the data
![Page 8: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/8.jpg)
What is BI?
• “BI” = Business Intelligence
– Business intelligence consists of the
processes, tools, and technologies required to
turn data into information and information into
knowledge and plans that drive effective
business activity.
(Wayne W. Eckerson, Performance Dashboards
Measuring, Monitoring, and Managing Your
Business)
![Page 9: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/9.jpg)
BI Layout
![Page 10: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/10.jpg)
• No in-house resources to custom make
the BI application
• Vendor who understood public transit
industry
Procurement Process
![Page 11: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/11.jpg)
• Connect the data sources
• Flip the switch
Implementation
![Page 12: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/12.jpg)
Dashboards, Scorecards, and Reports
![Page 13: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/13.jpg)
![Page 14: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/14.jpg)
![Page 15: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/15.jpg)
What happened to the numbers?
• Data was ugly!!!
![Page 16: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/16.jpg)
System Reality
• Manual data collection 2%
• System data collection 80%
• Never really looked at the AVL data
• Actual system On-Time was 52% vs.
89% manual
![Page 17: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/17.jpg)
System Vs. Manual
![Page 18: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/18.jpg)
Bridging the Gap
• Reports
• System adjustments
– Change late and early limits
– Data latency
• System Maintenance
• Managing Up and Down
• “We’ve always done it that way…”
![Page 19: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/19.jpg)
How close are we?
• On time performance improvement
– Initial 44% to as high as 74%
• Moving towards new way to monitor
service
• Starting to trust the data
• Close to reporting ALL electronic data
![Page 20: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/20.jpg)
Beyond Dashboards
• Clipboards to computers
• Better understanding of the AVL system
• More efficient monitoring of the transit
system
![Page 21: Beyond Dashboards - TransTrack Systems€¦ · Beyond Dashboards CTA Conference 2011, San Jose, CA Joseph Raquel, IT Director November 3, 2011 . The mission of Foothill Transit is](https://reader033.vdocuments.us/reader033/viewer/2022042417/5f32feaaf0010e68102231ea/html5/thumbnails/21.jpg)
Lessons Learned
• Communicate
• Stay vigilant
• Stay focused- Watch out for scope drift
• You can teach an old dog new tricks