Customer Story
Monsoon
Discover how UK fashion retailer Monsoon replaced Oracle with Exasol, reducing report times from 18 hours to minutes while enabling real-time inventory tracking and personalized customer experiences.
Flaconi is one of Germany‘s leading online beauty retailers, offering more than 720 brands and 45,000 fragrance, skin, hair, and natural cosmetics products. Flaconi’s goal is “unconditional customer service” and to be the most innovative online beauty store in Europe.
Germany
250+
Retail & E-Commerce
Exasol Espresso
Flaconi’s legacy system had reached its limit — they needed a scalable analytics database to deliver reports in the right format at the right time, and simulation models to track performance indicators. They also wanted to enable employees to use self-service BI, accessing existing data easily for daily, better-informed decision-making.
After a short test phase, Flaconi opted to run Exasol’s full database application on the cloud and AWS, based on speed, the product roadmap, UDFs (User Defined Functions), and “the human factor,” something Martin Nguyen, Director of Strategy, Data, and Analytics said was key. Flaconi uses Python, Pentaho Data Integration, and AWS services for data integration. The company migrated from Power BI to Tableau, and the Exasol database currently hosts around three terabytes of data. Migration took six months from setting up the server to going live.
With faster ETL processes and early morning reporting, 120 users benefit from real-time insights through direct access and dashboards.
Flaconi optimizes product promotions and Google ads based on detailed customer behavior analysis and channel-specific data.
Automated forecasting ensures products are available in the warehouse when customers click on items, improving stock availability and customer satisfaction.