Proact

JP Dynamics' flagship product, Proact, goes beyond traditional Business Intelligence (BI) tools by providing a complete BI platform which includes fine-grained security and administration for accessing diverse data sources.  This advanced BI platform utilizes SQL Server 2008 R2's Database Engine and Reporting Services to deliver powerful yet easy-to-use Web-based applications for interactive dashboard and reporting.

What differenciates Proact from other Paratransit Business Intelligence software is that Proact is based on SQL Server Reporting Services.  You can use existing talents to create additional reports* or you can choose to use JPD's services to create additional reports for you.

Flexible Installation Options

Proact can be installed on your existing SQL Server (2008 or 2008 R2).  If you don't already have a SQL Server, you can choose to install our "Lite" version which uses SQL Server Express with less features such as report subscriptions, mapping, and etc.

Sample Dashboards & Reports

Operations Dashboard

Displays hourly statistics of number of scheduled trips, late trips, On Time Performance (OTP), and 7 day outlook of bookings.  You can interact with the dashboard by clicking on "+" and "-" buttons to expand the areas of interest.

Operations Dashboard Operations Dashboard
Displays number of runs, late trips, performed trips, remaining trips, and On Time Performance. It also displays future bookings by date, booking type, subtype, and schedule statuses.
Operations Dashboard Operations Dashboard
You can interact with the dashboard by clicking on + and - buttons to view additional information.

Late Trips

Displays a list of late trips.  Background color gradually becomes a darker shade of Red as the current time gets closer to the schedule window.  You can click on "Run" number to view the trip in Run Itinerary report.

Late Trips Report Late Trips Report
Displays a list of late trips. Background color gets more red as the current time gets closer to the schedule window. You can click on Run numbers to view Run Itinerary report.

No-show Eligible Trips Dashboard

DIsplays a list of trips that are no-show eligible (arrived at a pickup location for more than X minutes).  Background color will become red red when the trip has been arrived manually.  Click on the "Validate" checkbox button to run No-show Validation report.

Noshow Eligible Trips Dashboard Noshow Eligible Trips Dashboard
Displays a list of trips that are noshow eligible (arrived at a pickup location for more than X minutes). Background color will turn red when the trip has been arrived manually. Click on the "Validate" checkbox button to run "Noshow Validation" report.

No-show Validation Report

Displays past 30 days of MDT performs by searching for trips with the same StreetNo, OnStreet, and City fields (excludes manual performed trips).

Noshow Validation Report Noshow Validation Report
Noshow Validation report retrieves past 30 days of MDT performs by searching for trips with the same StreetNo, OnStreet, and City (excluding manually performed trips).
Noshow Validation Report Noshow Validation Report
Displays the trip's scheduled pickup location, location of actual arrive, and locations of past performs. Blue Star: Scheduled pickup location Red Pushpin: Location of actual arrive Yellow Circle: MDT performs from different clients Green Circle: MDT performs from the same client
Noshow Validation Report Noshow Validation Report
Trip Details: Displays booking information from the selected trip. It also displays how many times this particular driver has been to the location in past 60 days. Client Trip Trend (Past 60 days): Displays a list of past trips.

AVL Report

Displays current locations of vehicles that are assigned to revenue runs.  Pushpins indicate vehicles with stale AVLs.  With internet connection, Bing satellite imagery can be overlaid on top of the map.

AVL Dashboard AVL Dashboard
Displays current locations of vehicles that are assigned to revenue runs. Pushpins indicate vehicles with stale AVLs. With internet connection, Bing satellite imagery can be overlaid on top of the map.
AVL Dashboard AVL Dashboard
AVL dashboard centers and zooms in automatically to fit displayed dataset.

Run Performance Dashboard

Run Performance report displays On Time Performance (OTP), MDC Performance rate (MDCP), and Last AVL received from Vehicle.  You can sort by OTP & MDCP to monitor runs with low performance ratings.

Run Performance Report Run Performance Report
Run Performance report displays OTP, MDC Performance Rate (MDCPR), Last reported AVL time. You can sort the report by OTP & MDCPR to monitor poorly performing runs.

Run Itinerary Report

Displays a list of run itinerary as you would see in Trapeze – Schedule Editor.  We can customize columns and color settings to mimic your Schedule Editor.

Run Itinerary Report Run Itinerary Report
Displays a list of run itinerary as you would see in Trapeze – Schedule Editor. This report can be accessed from various reports and dashboards.

Run History Report

Run History report displays past 30 days of KPIs for a selected run. You can view Run Itinerary report and Vehicle History report from this here.

  • Rev RH:  Revenue Run Hour (can be customized to individual site's definition)
  • RM:  Run Miles (PullOut to PullIn)
  • Rev RM:  Revenue Run Miles
Run History ReportRun History Report
Run History report displays past 30 days of KPIs for a selected run. You can view Run Itinerary report and Vehicle History report from this here. • Rev RH: Revenue Run Hour (can be customized to individual project’s definition) • RM: Run Miles (PullOut to PullIn) • Rev RM: Revenue Run Miles

Vehicle History Report

Vehicle History report displays past 30 days of KPIs for a selected vehicle.  You can view Run History report and Driver History report from this here.

Vehicle History Report Vehicle History Report
Vehicle History report displays past 30 days of KPIs for a selected vehicle. You can view Run History report and Driver History report from this here.

Driver History Report

Driver History report displays past 30 days of KPIs for a selected driver.  You can view Run History report and Vehicle History report from this here.

Driver History Driver History
Driver History report displays past 30 days of KPIs for a selected driver. You can view Run History report and Vehicle History report from this here.

Slack Time Report

Displays forecasted slack time.  You can click on Run numbers to view the Run Itinerary report.

Slack Time Report Slack Time Report
Displays forecasted slack time. You can click on Run numbers to view the Run Itinerary report.


* Requires premium support agreement