Exasol helps Dreams boost data analytics performance

Dreams is using Exasol’s analytics database to centralise data, improve customer experience and support data driven decision making.

The bed retailer says that it is now able to run concurrent queries up to 8x faster than before, reducing query result times from minutes to tens of seconds. 

Petra Kasperova, Insights and Analytics Director at Dreams, says: “We chose the Exasol analytics database because its functionality, versatility and scalability allow us to do much more with our data, integrating multiple sources and running more complex queries much faster.”

“This will help us make more timely data driven decisions across the business.”

Dreams’ business intelligence layer includes the Alteryx and Tableau tools, but it needed a secure, low maintenance and scalable database that could integrate easily with its ERP system.

Utilising Exasol’s Virtual Schema technology has enabled ERP data to be made available to Exasol via SQL without the need to create complex ETL/ELT programs, enabling Dreams’ IT team to spend their time more productively. 

Mathias Golombek, CTO, Exasol, comments: “The dramatic shift towards online shopping means it’s vital for every business to be able to analyse the large amounts of data that are collected through its website in order to optimise the e-commerce experience.”

“Dreams also manufactures over 460,000 units of specialised products a year across 100 different models, and data will ensure every item is the best it can be for customers.”

“With a centralised, integrated view, they will now be able to solve complex challenges faster, accelerate time to value and accelerate decision making.”

Potential applications include Sleepmatch, Dreams’ proprietary mattress fit technology, which carries out thousands of live calculations to recommend the ideal mattress for each customer.

Analysis of the large volumes of data collected from Sleepmatch would help to further optimise future mattress recommendations.

Sign up for our free retail technology newsletter here