Case Study

Arriva

Arriva, a multinational public transport company headquartered in Sunderland, Tyne and Wear, United Kingdom, operates bus, coach, train, tram and waterbus services in 14 countries across Europe.

Implement Business Intelligence solution using BIRST, Redshift and SQL Server. Developed dashboards and reports for the for various business entities such as UK Bus, UK Rail and Mainland Europe which will be used by Management as Enterprise Information System

Solution

Datawarehouse Solution is developed which extracts data from SAP R/3 and pushes it to data warehouse residing in Amazon Redshift. ETL process developed using SSIS.

Reporting layer developed in BIRST which provides comprehensive analysis of Daily Sales , Inventory , GL information to different teams.

Data Level and User Level Security is implemented in the BIRST reports.

Impact

50+ reports are developed which are consumed by 500+ users through BIRST Mobile , BIRST Online

Automated PDF generated reports which are sent through email developed using BIRST Report Scheduler

End to End solution implemented from data extraction , data cleaning , data warehouse and report visualization which enables client better analysis of Sales , Finance & Marketing KPIs