Skip to content

Flaconi & Exasol

Faster reporting enabling innovation

Case Study

More users and faster reporting help German beauty retailer prioritize customer UX and innovation

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.

Location

Germany

Employees

250+

Industry

Retail & E-Commerce

Product

Exasol Espresso

The Challenge

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.

The Solution

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.

Benefits

Benefits for Flaconi

Accelerated Data Processing and Access

With faster ETL processes and early morning reporting, 120 users benefit from real-time insights through direct access and dashboards.

Data-Driven Marketing and Personalization

Flaconi optimizes product promotions and Google ads based on detailed customer behavior analysis and channel-specific data.

Efficient Inventory Management

Automated forecasting ensures products are available in the warehouse when customers click on items, improving stock availability and customer satisfaction.

The number of users is rising steadily. With our ’Data University’ we are making sure that the employees keep improving the way they handle data. Exasol has become our key tool. Everything we do is based on the database.

Martin Nguyen, Director of Strategy, Data and Analytics, flaconi

Interested in Learning How Exasol Can Help You?