Client type: Public sector
Industry: Transportation
Solutions: Data management and business intelligence
For 50 years, Fredericton Transit has transported over one million passengers annually in New Brunswick’s capital city. To maximize the value of the data collected by its buses and improve its management practices, the City of Fredericton entrusted ITI with implementing an automated business intelligence solution.
Their Challenge: Better Plan Bus Routes and Assess Service Levels, Without Operational Burden
With its buses equipped with IoT (Internet of Things) sensors, Fredericton Transit collects a wealth of data every day regarding bus ridership, routes, and terrain.
The vast amount of data generated created a logistical challenge for its management team, which did not have an analytics platform to make this data usable.
Our Solution: A Seamless Integration of Microsoft Fabric with Power BI
The large volumes of IoT data collected by the buses were organized and transformed into data models designed for downstream consumption, making them business-ready.
Result: Analyses Based on Real-Time Data, for More Informed Decision-Making
Today, frontline staff can easily generate stop-by-stop reports, making data collection much simpler. The management team has access to comprehensive Power BI reports, built from real data reflecting their actual field conditions.
This new business intelligence solution enables Fredericton Transit to:
- access detailed ridership data within a single platform,
- evaluate the efficiency of their bus routes,
- identify successes and areas for improvement to inform decision-making.
Benefit: The City of Fredericton Received $2,000,000 to Improve the Efficiency of its Bus Network
With this new business intelligence solution built on their own data, the City of Fredericton has been able to generate strategic opportunities. The impact of this project goes far beyond management and operations—it will be felt all the way to the level of service provided to users.
Thanks to the solutions implemented by ITI, the City of Fredericton can allocate Fredericton Transit funds more efficiently to improve the quality of service and expand our bus routes, ultimately benefiting our entire community.
Fredericton Transit is a great example of operational gains that far and quickly outweigh the costs of implementing a business analytics solution.
