About the client
A global leader in the railway industry offering a complete portfolio of products and services, from high-speed trains, metro, monorails, and trams, to infrastructure, traffic control systems, and digital mobility solutions. The company is headquartered in France and currently operates in 70 countries with more than 70 000 employees.
The challenge
Building a scalable BI solution for the Client’s diagnostics system deployed for one of customers.
What we did
- ETL – the whole process of data mart loading with data extracted from OLTP PostgreSQL and MSSQL servers.
- Data analysis tier built with Tabular Mode of SSAS.
- Advanced SSRS reporting scheduler.
- Flexible managers’ and analysts’ dashboards built with PowerView.
Effects
- Built custom reports conforming with the client’s templates.
- SSRS reporting processes configured.
- SSRS reporting user interface seamlessly integrated with the diagnostics system application.
- Client’s analysts’ team trained to build further reports.