This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4842 IT projects that we have successfully completed with our customers.How can we support you?
Category management
Project duration: 1 year, 2 months
Brief description
Implementation of a data warehouse to analyze and optimize sales processes. The range of items is to be structured and planned accordingly using the new DWH based on the location-specific requirements. The category management will use a staging database that will adopt and format all the information from the various complex upstream systems.
Supplement
The customer is a successful specialist in retail and gastronomy concepts at significant locations in Germany such as airports and main train stations. The Category Management application is a BI solution for the analysis and optimization of the customer sales outlets based on the principle of merchandise categories and product line pyramids. The range of items is to be structured and planned accordingly using the application based on the location-specific requirements. One particular challenge during the design and implementation of the solution is the sheer range and depth of the product line, which includes many different brands including books and media, food services and travel accessories. This is reflected by the diversity and complexity of the ERP applications from which information must be copied and formatted for the Category Management Data Mart.
IT project data
- Industries trade
- Specialist tasks Category Management, optimization method, sales
- DP tasks Data Warehouse
- System environments Business Intelligence
- Procedure model Waterfall Model
- Databases MS Access, MS SQL Server
- Middleware and frameworks MS SQL Server Integration Services (SSIS)
Project period07.05.2014 - 30.06.2015
Customers who trust us
Have we sparked your interest ?
