title
Business Intelligence and Data Management Reporting System
end
DESCRIPTION: Reporting system that aggregates data from different sources within the organizations to produce meaningful reports to assist staff in making business decisions and reporting information to external stakeholders such as NTD
AGENDA NO: 21-133
ACTION REQUEST:
? Approval ? Review Comment ? Information Only ? Other
RECOMMENDATION:
recommendation
To authorize the CEO to award a contract to TranSight for scope of work outlined in RFP 2021-05. The installation cost will be $99,680.00, there will be an annual maintenance service fee, for three years at a cost of $ 231,817.00 for a total cost of $331,497 for four years. There is an option for two additional years of maintenance service for $169,697.00. If the additional two years of maintenance service is utilized the total contract amount will be $501,094 and a duration of six years, one year installation and five years of maintenance service.
end
ISSUE/BACKGROUND:
body
The RTA needs a Business Intelligence and Data Management Reporting system that aggregates data from different sources within the organization to produce meaningful reports for staff to assist in making business decisions and reporting to external stakeholders like NTD and FTA.
end
DISCUSSION:
The goal is to define and consistently implement best practices for financial and operational reporting. This will allow the utilization of data to improve service quality, while building an efficient and effective operation. The agency utilizes several data sources that will need to be integrated.
JD Edwards
Enterprise Resource Planning Solution
Trapeze
Operator Scheduling, Dispatching, Work Management, Planning
Clever Devices/Ridecheck Plus
Operator/Fleet Performance, Automatic Passenger Count
ADP
Human Resource Data
GenFare
Fare System Data
Ron Turley
Maintenance Management System
RouteMatch
On-Demand and Para Transit
Excel
Various Data Points
FINANCIAL I...
Click here for full text