Business Intelligence Overview

Use Avail’s Business Intelligence (BI) to review your agency data metrics in a collection of visualization dashboards, like bar graphs, and the underlying data in tabular form. These flexible visualizations display a range of information by different criteria to answer your business questions, such as: How is our on time performance over time? Are vehicle operators using the system correctly? Is the schedule reflective of people travel patterns? What is the condition of our vehicles? How many incidents have we documented for last quarter? What is our ridership for this quarter? How many detours did we create last year?

A dashboard can consist of a collection of panels (reports) or a series of tabbed pages, each with its own graphs that you can filter. These interactive dashboards allow you to vary the reporting criteria for them. Simply click on the visualizations to drill-down to the necessary details, or choose from a series of filters to apply.

In addition to the predefined reports, you can use the self-service tab to create your own custom analyses. The self-service section provides ways to interact with your data and personalize your own dashboards and reports. Simply select and analyze data from centrally managed and governed data sources, create and share visualizations, graphs and tables. Self-service allows you to do the following:

• Create custom charts, tables, and other visualizations of your data
• Perform a wide range of activities with your data, including sorting, grouping, and filtering
• Save these visuals in your own gallery
• Combine them into dashboards
• Place them in reports that can be shared with others
• Schedule reports for automatic generation and distribution and more

For the self-service features, refer to the Logi Analytics guide Data Analysis using the Self-Service Reporting Module.

How to Access Business Intelligence (BI)

If you have permissions to access Business Intelligence reporting, access this reporting tool in ETMS in the Operation product suite. After logging into ETMS, navigate to Operations and locate the Business Intelligence card, then open it. Business Intelligence will open in your default browser as a web-based tool. Avail recommends using either Google Chrome or Microsoft Edge. 

The Business Intelligence card:

The Home Page for BI is shown below:

Menu Bar

The menu bar is across the top of the home page and displays the different categories of reports and features you can access. 

These options include the following:

• Home: Default view when BI is opened
• myDash: View and manage your customized dashboard to review any reports you scheduled, and any bookmarked reports.
• Operations: Visualizations related to operations such as on-time status, number of vehicles that are late/early. These reports can assist in identifying any schedule data, vehicle or vehicle operator issues.
• Planning: Identify how the schedule is used on the road in real time. Identify the best and lowest performing routes, drive vs dwell times, identify any issues that require updates/ improvements, stops no longer servicing ridership needs ( Low Utilization report), and more. Review fare structures, APCs, APC vs fare collection, stop level boards and alights, and overall ridership metrics.
• Maintenance: The Live Maintenance Queue report displays real- time data for pre-trip inspection failures and reported issues. Additional maintenance reports provide long term trend analysis opportunities, reviewing VAMs, associated costs, inventory, asset work orders, PM cycles, and more.
• Statistics: Display scheduled and actual miles and hours, monthly route level statistics for ridership, and more.
• Admin: Manage your bookmarks and scheduled reports.

Bookmarking, Automatic Runs, and Exporting

In the upper-left corner of many visualizations, there are three additional functions to note.

• Click to bookmark the current The bookmark feature saves all your filter settings so you can run the same report without having to recreate it. Access and manage your bookmarks in Admin > Bookmark Admin.
• Click to have BI automatically run and distribute reports to specific users. View and manage the reports that are already scheduled in Admin > Scheduled Reports.
• Click to export the data to an Excel, CSV, or PDF