BI Progam Management in Transportation Industry

The main/initial deliverables of the BI program at Alpega are Tableau dashboards (both internal and external customers/shippers;  eg. Performance reports, KPIs regarding Call-off, Trace, Slot bookings and Carrier scorecards) and a self-service reporting/analysis environment (mainly for internal/strategy).

Big data and Advanced Analytics are also on the radar to unveil hidden value within the data (going from data deduplication towards trade-lane analysis and support in lead generation programs).

The technical architecture consists of Google Bigquery and Tableau.  It currently co-exists with a legacy systems hosted on Oracle databases with Talend as ETL and OBIEE as reporting layer.

The BI team, consisting of local Alpega resources (project manager, functional/business analysts, technical lead and functional lead) supported by nearshore resources in Minsk (mainly technical).  The project is managed in an agile/scrum manner. The technical team is managing the implementation part of the project and delivering the various solutions.  Currently the “reporting/dashboarding” solutions are being created towards the different applications/application owners. (Transwide, SPOT bidding, TAS, Teleroute).  Integration with Salesforce data manages the company/customer hierarchy.