About the client
Bombardier - large manufacturer of regional airliners, business jets, mass transportation equipment, and recreational equipment, and a provider of financial services.
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.