ETL & Reporting
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
- 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.