About the client
Manufacturer of trucks, buses, engines and machines. The Polish branch of the Group supports all branches of the Group in Europe with IT solutions.
The challenge
Work in the ETL, reporting, data mining, servicing and defect reporting areas.
What we did
- ETL – the whole process of supplying the data warehouse, from source files to OLAP wholesale tables (cubes)
- Managing the business reports platform
- Wholesale and reporting platform maintenance
- Managing cubes and sizes (in most cases excluding the creation of cube projects, but creating database structures with fact and size tables)
- After sales truck service and the maintenance of existing solutions
Effects
- ASE – after-sales service, vehicle mileage analysis.
- Parcaref – analysis of trucks by parts.
- Hubble – defining parts wear, moment of change, resources of elements in the warehouses and at dealers’, based on probability schedule for particular parts and vehicle mileage.
Each of these projects is a continuation of a previous one. They are conducted in order to optimize car parts sales.
Learn more