
Zalando and Exasol
The key to optimizing the availability of stock
The online retailer, offers customers the chance to purchase more than 150.000 products from about 1.500 brands in 15 European countries with ease – whether on a PC, tablet or smartphone – anywhere and at any time. But an increase in orders and in the various fashion lines available means more and more data being generated more quickly.

Challenges
Zalando needed to cope with rapid data growth effectively

Solutions
Exasol’s analytics database integrated into data warehouse as an analytic layer

Benefits
Real-time info on product availability
![]()
By implementing the Loading...Loading...in-memory database, Zalando can now benefit from a higher degree of flexibility. Exasol offers a clear performance advantage, too.
![]()
Customers in Europe
products available
of memory in several clusters
people visiting webshops in one quarter
Background
Zalando is the rising star in the world of e-commerce. Back in 2008, the sale of footwear and clothing across the web was hard to imagine. Yet, since then Zalando has managed to provide online access to fashionwear for more than 14 million customers across Europe.
In order to streamline transactions with customers, merchants and logistic companies, Zalando needs standardized processes and consistent data on products, inventories, orders, customers and deliveries. Therefore, the analytic Loading...Loading...in-memory database from Exasol has been implemented as a fundamental part of the company’s data warehouse system in order to support the order process and to ensure that Zalando’s customers benefit from an optimal availability of products and apparel.
- Industry Retail and e-commerce
- Application BI acceleration

The journey
You can use our analytics database with our private cloud, any public cloud, on premises – or as part of a hybrid deployment.

The challenge
Managing and utilizing data reliably
With roughly 322 million people visiting its webshops in the third quarter of 2014 alone, and with a range of more than 150,000 products available, the German shoe and fashion retailer Zalando perhaps has more experience than any other online mail-order company when it comes to managing and working with large data volumes.
“As a fast-growing business, it has been quite a challenge to manage the increase in data volumes in an effective way,“ explains Eric von Czapiewski, head of business intelligence at Zalando. Back in 2010, he was already looking for a scalable Loading...analytic database that was able to cope with the expected growth of data fast and reliably. Von Czapiewski remembers exactly the problems that arose when running analytics projects in different parts of the business.

The solution
Exasol as an accelerator to enable comprehensive reporting and analytics
“We looked for a database that could be integrated into our data warehouse as an analytic layer that could sit on top. It was important that the solution offered a good price/performance ratio and did not have a lot of administration overhead. With Exasol, we found a solution that met those needs.”
The new system consists of several clusters with 7TBs of memory. Not only did Zalando look at the solution’s scalability features when deciding to implement the Loading...Loading...in-memory database, but it also has to fit in to their architecture and connect effortlessly to existing front-end BI tools they were using. “By implementing the Loading...Loading...in-memory database, Zalando can now benefit from a higher degree of flexibility. Exasol offers a clear performance advantage, too,” says Czapiewski. However, the company not only benefits from short analysis run-times, but also from the freeing-up of resources in various departments such as purchasing, auditing or logistics.

The benefits for zalando
Designing effective repeat order processes
Unlike bricks and mortar shops, e-commerce stores do not have any open and close times. Therefore, sales and stock availability is analyzed while the business is running. Information on product availability has to be retrievable in real-time, so that items that are running low can be reordered at any time. It is here where Exasol helps the online retailer as well in order to make the repeat order process as efficient as possible. Furthermore, the solution supports the company’s CRM. “By using Exasol, our customers now receive exclusive and personalized emails that include specific offers on articles that they are really interested in,” says von Czapiewski.

The future
Designing effective repeat order processes
Zalando is now well equipped for the future of online shopping. Continuous process flows streamline all transactions and render them efficient, and by running online analytics, Zalando can react faster to customer behaviour and adapt the range of products as well as marketing activities accordingly. The online retailer can control revenue flows better and unearth new sources of revenue quickly. In short, Zalando can now look to further growth in data volumes with great confidence.
Get in touch today
We’d love to hear from you if you’ve got a burning question for one of our experts – or if you simply want to talk through how to take your project forward with us, or one of our partners.
More success stories
Find out how Exasol helped other companies take their data analytics to the next level.


OTTO
How German e-commerce giant, OTTO, cut costs and improved its data analytics performance with Exasol.


Flaconi
Exasol’s analytics database powers flaconi to manage and gain value from rapidly growing volume of data.


Piedmont Healthcare
Non-profit healthcare provider Piedmont uses data analytics to control infection rates.