Skip to main content
CAP Metro
File #: AI-2021-150   
Type: Resolution Status: Passed
File created: 7/29/2021 In control: Board of Directors
On agenda: 12/17/2021 Final action: 12/17/2021
Title: Approval of a resolution authorizing the President & CEO, or his designee, to finalize and execute a contract with California Creative Solutions for a Data Warehouse and Business Intelligence (DWBI) system and implementation services for a base period of two (2) years with eight (8) one-year option periods and 20% contingency in an amount not to exceed $8,795,938.
Attachments: 1. BOD Presentation-AI-2021-150 Data warehouse and Business Intelligence.pdf

SUBJECT:
title
Approval of a resolution authorizing the President & CEO, or his designee, to finalize and execute a contract with California Creative Solutions for a Data Warehouse and Business Intelligence (DWBI) system and implementation services for a base period of two (2) years with eight (8) one-year option periods and 20% contingency in an amount not to exceed $8,795,938.
end

FISCAL IMPACT:
Funding for this action is available in the FY2022 Capital Budget

STRATEGIC PLAN:
Strategic Goal Alignment:
? 1. Internal/External Customer Service Excellence ? 2. Stakeholder Engagement
? 3. Financial and Environmental Sustainability ? 4. Staff Development ? 5. Agency Growth Management

Strategic Objectives:
? 1.1 Safety & Risk ?1.2 Continuous improvement ? 1.3 Dynamic Change
?1.4 Culture of Innovation ?2.1 Be an Employer of Choice ?2.2 Organization Development
?2.3 Organization Culture ?3.1 Resource optimization ?3.2 Safety Culture
?3.3 Environmental Leadership ?4.1 Educate & Call to Action ?4.2 Build Partnerships
?4.3 Value of Transit ?4.4 Project Connect

EXPLANATION OF STRATEGIC ALIGNMENT: The Data Warehouse and Business Intelligence (DWBI) system will transition our successful DWBI pilot to an enterprise wide DWBI capable of automating many of the manual process. The system will have the tools and ability to support all aspects of the strategic plan by giving the public and staff insight into operational and financial performance as well as security,?safety,?and risk management. The DWBI system aligns with the strategic priority of providing High Quality Customer Experience by?empowering CapMetro staff with greater insights into on-time performance, ridership, customer satisfaction,?Net Present Score (NPS), injury and accident rates. This insight will enable CapMetro to provide intu...

Click here for full text