800+ critical BI reports, rebuilt in one year.

A metropolitan transit authority’s fragmented reporting stack — spread across three legacy BI platforms — consolidated into Power BI on a new Azure cloud data warehouse.

Challenges

Migrate from an Oracle on-premise database to a cloud data warehouse in Azure
Consolidate a fragmented reporting environment spread across SAP Crystal Reports, IBM Cognos, and Hexagon
Keep 800+ critical reports powering daily transit operations — with zero interruption during migration

Results

800+ reports created in just one year, migrated to Power BI without interrupting daily operations.
A modern Azure cloud data warehouse replacing the legacy Oracle on-premise database.
Self-service BI: staff create, modify, and distribute reports themselves — faster decisions across buses, ferries, railways, and subways.

Apoddo’s collaboration with us was a resounding success, marked by the creation of over 800 reports in just one year. We look forward to continuing our work with Apoddo for many years to come.

Paul Thiara

Project Manager, TransLink