Reply Logo
Menu
  • TOPICS
    TOPICS
    • Architecture
    • Artificial Intelligence & Machine Learning
    • AUGMENTED & VIRTUAL REALITY
    • Big Data & Analytics
    • Blockchain
    • Cloud Computing
    • CRM
    • Digital Experience
    • Digital Workplace
    • eCommerce
    • Game & Gamification
    • Industrie 4.0
    • Internet of Things
    • Mobile
    • Quantum Computing
    • Risk, Regulation & Reporting
    • Security
    • Social Networking & Crowdsourcing
    • Supply Chain Management
    • Video
  • INDUSTRIES
    INDUSTRIES
    • Automotive
    • Energy & Utilities
    • Financial Services
    • Logistics & Manufacturing
    • Public Sector & Healthcare
    • Retail & Consumer Products
    • Telco & Media
  • JOIN
    JOIN

    join reply work with us

    Reply is the place to meet an incredible variety of enthusiastic, passionate, ideas-driven people, who want to make a difference and an i​mpact.
    ​Would you like to know more?

    Go to careers​​​​
  • ABOUT
    ABOUT
    • ABOUT
    • REPLY AT A GLANCE
    • SUSTAINABILITY
    • ALL REPLY WEBSITES
    • CAREERS
    • Reply Code For Kids
    • OFFICE LOCATIONS & CONTACTS
    • INVESTORS
    • FINANCIAL NEWS
    • REPLY SHARE INFORMATION
    • FINANCIAL HIGHLIGHTS
    • FINANCIAL CALENDAR AND EVENTS
    • FINANCIAL REPORTS
    • SHAREHOLDERS' MEETING
    • LOYALTY SHARES
    • CORPORATE GOVERNANCE
    • EXTRAORDINARY TRANSACTIONS
    • NEWSROOM
    • News
    • Events
    • Press
    • Webinars
Choose language:
Reply Logo

Search

Focus On

Case Study

Reply implements Web Analytics for Otto with Microsoft

OTTO is redefining the idea of web analytics with the introduction of a high-performance, Microsoft-based BI solution. Cluster Reply is supporting the project by the OTTO divisions in the form of Europe’s greatest cube for the analysis of online purchasing behaviour and the optimisation of the range and campaigns. For the very first time, up-to-the-minute information can react to the high-volume online business.

Customer:
OTTO
FOCUS ON: Big Data & Analytics, Microsoft, Multichannel, Retail & Consumer Products,

Cluster Reply

Cluster Reply is part of the Reply-Group and has specialized in Microsoft-Technologies and –applications. As “Microsoft Gold Certified Partner” Cluster Reply helps its customers since 1996, to take advantage of Microsoft’s cutting edge technology. Cluster Reply is leading on Microsoft Business Intelligence, CRM, Internet of Things (IoT), Collaboration and Mobility.

​​From Single Channel to Multi Channel

OTTO made its name as a classic mail-order catalogue. Since then, it has progressed to become the biggest German online retailer for fashion and lifestyle (B2C).​​​​​OTTO Press Image​ Transformation into an e-commerce driven company requires the information flows to be considerably speeded up. The high degree of flexibility and the options available for the overarching, general optimisation of the sales offer require detailed, fast knowledge of customers’ purchasing behaviour and of the success of marketing campaigns. The easy way in which information can be combined is becoming increasingly important in this field.

High-end Business needs High-end IT

The large number of customers, items and campaigns carried out at the same time generates a huge quantity of data. This presents an extremely valuable wealth of information for adapting the range of products to fit the requirements of customers. The IT systems used to date were no longer able to keep up. OTTO chose BI technology by Microsoft and, therefore, a high-performance, easily adaptable overall concept which is intuitive to operate.

Only standard components based on the SQL server were used: however, they were compiled in an impressive configuration with six integrated servers with a total main memory of 12 terabytes. The additive indices such as turnover are realised in a multi-dimensional approach which offers top performance for this type. In general, semi-additive indices, such as the number of individual customers in a certain period, prove extremely performance-critical. They have been realised in a ROLAP model with columnstore indices. In the analysis services, both models can be combined in a cube.

OTTO Press Image

Leaving old Paths

Thanks to this solution, the OTTO divisions are able to take new paths in the field of customer management and e-commerce analysis and, in category management, to analyse the existing information basis at any level of detail. They are no longer reliant on IT for the creation of analyses and newly combined indices: instead, they work independently with familiar front-end tools such as Excel with access to the cube data.

The resulting solution with considerably increased functionality is now not only significantly more stable and better performing than the old one but also noticeably more economical – both in its procurement and in its operation. In this manner, the Microsoft SQL Server is a permanent fixture in the BI platform strategy of OTTO.

Image Source: Otto Press Image https://www.otto.de/unternehmen/de/newsroom/materialien.php

RELATED CONTENTS

BI & ADVANCED ANALYTICS

Research

The state of Business Intelligence and Advanced Analytics

Companies float in a constantly growing ocean of internal and external data. This study provides an overview of the latest trends in Business Intelligence (BI) and Advanced Analytics that enable decision-makers to leverage this data for deeper insights, leading to better-informed decisions and ultimately increasing business profitability.

The state of Business Intelligence and Advanced Analytics 0

REPLY MARKET RESEARCH HUB

Research

(BEYOND) DIGITAL MARKETING

The goal of this research is to share some insights into how marketers are tackling the different challenges coming from Coronavirus and the strategies they are using to thrive.

An overview on the growing dominance of Big Tech, the market response to MarTech, the importance of Data and Ethics

(BEYOND) DIGITAL MARKETING 0

COVID-19

Research

How COVID-19 is changing the food and beverage industry

The pandemic has rearranged consumers’ needs in general. This report focuses on how COVID-19 impacts the 2021 Food & Beverage industry in Europe.

UPDATED AS AT 15 FEBRUARY 2021

How COVID-19 is changing the food and beverage industry 0
 
 
 
 
Reply ©​​ 2022​ - Company Information -
 Privacy (New!) Cookie Settings​
  • About Reply​
  • Inves​tors​​
  • Newsroom
  • Follow us on
  • ​
​
  • ​Privacy & Cookies Policy​​​
  • Privacy Notice (Client)
  • Privacy Notice (Supplier)
  • Privacy Notice (Candidate)
  • Privacy Notice (Marketing) New!
  • CCPA Privacy Notice
  • Modern Slavery Act Tran​sparency Statement (UK & IR)​
​​Reply Enterprise Social Network​