References

Projects for logistics and retail

A selection of our projects for listed logistics groups and major retailers – from a pricing engine for sea freight to a forecasting system for 2,000 stores.

Logistics

LogisticsListed global player

Price engine system (sea freight)

  • Data-driven business analysis
  • Development of the rate engine data model
  • Development of a margin model
  • Rate control based on historical data (predictive analytics)
  • Web-based quotation tool for sales
  • Web-based price monitoring system
  • Integration into the central IT architecture
LogisticsListed global player

Prototype price engine system (air freight)

  • Data-driven business analysis
  • Development of the rate engine data model
  • Rate control based on historical data (predictive analytics)
  • Web-based quotation tool for sales
LogisticsListed global player

Data mart “daily profit & loss”

  • Forecast of revenue and costs to month-end (predictive analytics)
  • Seasonal and regional effects and historical data taken into account
  • Distinction between new and existing customers
  • Integration of direct and indirect costs
LogisticsListed global player

Data-based three-month forecast (overland)

  • Built on the new “daily profit & loss” data mart
  • Identification and analysis of the key influencing factors
  • Reference curve based on historical data
  • Self-learning model (predictive analytics)
  • Standardised cost allocation process
LogisticsListed global player

Sea freight rate forecasting (predictive analytics)

  • Prototype forecasting model for the SCFI index over 12 months
  • Identification and analysis of the key influencing factors
  • Integration of expert-level indicators
LogisticsTop 3 worldwide

Tracking & tracing

  • Central information system for customers, service providers and employees
  • Near real-time provision of shipment data
  • Tracking across multiple country and service provider systems
  • Integration of the quality and provisioning system
  • Integration of archiving
  • More than 10 scan events per shipment
  • Direct connection of business customers
LogisticsTop 3 worldwide

Quality management system

  • Definition of the term “shipment”
  • Consolidation of detailed shipment data across different dimension levels
  • Quality improvement in production (transit time and quality)
  • Commission ratios (E+1, E+2)
  • Measurement and control of capacity utilisation
LogisticsTop 3 worldwide

Operating concept DWH / ODS

  • Definition of service level agreements (SLAs)
  • Standardisation of processes
  • Documentation of data models and processes
  • Definition of escalation paths
  • Development of service measurement methods
Industry / LogisticsTop 3 luxury goods

Returns management system

  • Linking all organisations involved in a return
  • Real-time data provision
  • Credit note only after approval
  • Inspection of the returned goods
  • Status information
  • Standardised process
  • EDI and SAP connection

Retail and other industries

Textile discounterMore than 2,000 stores

Sales forecasting system

  • Daily forecast for advertised and promotional goods
  • Dynamic regression analysis model
  • Forecasts over any number of weeks on a sales-day basis
  • Forecast for advertised goods from day 1 (launch date)
  • Forecast for range goods from day 1 (first receipt in store)
  • Sales forecast as ratio of quantity sold to stock
  • Reference curves for range and advertised goods
  • Initial load
Textile discounter2,000 stores

Distribution logic for merchandise control

  • LOT distribution logic at item level
  • Fewer over- and under-deliveries to stores
  • Previous mis-deliveries taken into account
  • Control module for the business department
  • Balance between quality and performance
  • Partial deliveries taken into account
  • Functional test run
Electronics retail€20 billion revenue

Perpetual inventory

  • “Active” data warehouse for perpetual stock management
  • Ongoing valuation of purchase and sales prices
  • Based on daily detailed booking data
  • Support for the financial audit (stocktaking)
  • Reconciliation with the physical inventory (manual count)
Drugstore discounterMore than 5,000 stores

Enterprise active DWH

  • Out-of-stock prevention
  • Active DWH with continuous load cycles
  • Perpetual stock management
  • Supplier connection
  • Evaluation of buyers, articles and stores
  • Fraud detection
Consumer goods retailMore than €3.5 billion revenue

Customer analysis

  • Increased marketing efficiency
  • Customer segmentation with a purpose-built data mining system
  • Analysis of navigation and purchasing behaviour
  • Measuring the success of promotions
  • Flexible consolidation of customer data
Consumer goods retailTop 3 France

Measuring advertising efficiency

  • Multichannel analysis system
  • Catalogue performance measurement
  • Shopping basket analysis
  • Web-based
Mail order retailTop 3 e-commerce worldwide

Group-wide statistics module

  • E-commerce management information system (MIS)
  • Multi-client capable
  • Consolidation of customer and production data (click & mortar)
  • Consolidation of session data across time and websites
  • Merchandise analysis
  • Customer segmentation
TelecommunicationsTop 3 worldwide

Enterprise data warehouse

  • Consolidation of customer and production data
  • Forecasting module
  • Contract review
  • Network planning
  • Billing support
  • Product planning (discount campaigns)
  • Integration of online data

Planning a similar project?

Tell us about your task. We will tell you openly what we bring from comparable projects and what a first step could look like.