Business Intelligence Solutions for a Construction Equipment Company by JCommerce

Some details

Design of a model and implementation of thematic data warehouses (Data Marts), which were optimized in respect of particular operation areas.

Scope of work:

Creation of model and implementation of thematic Data Marts, which were optimized for individual business activities
Improvement of reporting system by IBM Cognos implementation
Improvement of ETL processes, which are responsible

… for loading Data Marts from corporate data warehouse
Creation of interfaces (Oracle)
Programming of Data Marts on Data Warehouse second level
Provision of ETL processes (DataStage), Framework and reports (Cognos)

See case study