About the client
One of the world’s leading manufacturers of trucks, buses, construction equipment and marine and industrial engines. The Group also provides complete solutions for financing and service. Employ about 100,000 people, has production facilities in 18 countries and sells its products in more than 190 markets.
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
