Reports that used to be ready at midday are now available by 5:30 a.m.

20 users have direct access to Exasol, with 100 more using dashboards, cubes, and reports 

ETL processes that used to take 45 minutes now take no more than 15 


All data can be broken down to individual marketing channels by margin and product 


Products are forecasted and automatically delivered to the warehouse — when a customer clicks on an item, it’s going to be available 


Flaconi decides which products to promote to which customers on its site or in Google ads based on data and customer behavior

Benefits for Flaconi

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 challenge

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. Nguyen says: “Being able to genuinely transfer all the logics from the old database to the new one was important to us. We didn’t want to go live with less than what we had before.”

The solution

Faster reporting enabling 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.

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

Martin Nguyen

“Exasol has become our key tool. Everything we do is based on the database.”

Schnell wachsende Datenmenge problemlos verwalten und daraus Nutzen ziehen. Der führenden Onlineshops für Beauty-Produkte Flaconi zeigt wie es geht.

Flaconi

Flaconi | Exasol

https://www.exasol.com/app/uploads/2020/06/Flaconi-header-scaled.jpg

Home

Case Studies

Exasol

Fast, reliable data to 300 daily reports and >100 dashboards

Tableau integration and intuitive administration

Quick analysis of large data sets with in-memory technology

Stable online analytical processing (OLAP) data platform

Continuous data volume growth without sacrificing speed

Benefits for iyzico

companies

consumers

dashboards

to detect fraud

ms(<) queries

Iyzico’s technology includes hundreds of security filters, blacklists, and AI-powered fraud detection algorithms to identify suspicious transactions. But protecting customers without decreasing conversion rates requires predictions to return an answer in 50 ms — and a rise in customers and transactions was stretching the Community Edition.

Iyzico chose Exasol’s Enterprise Cluster Edition over Hadoop and Oracle due to fast query running times, easy installation, and Tableau integration. “Exasol’s performance and easy installation convinced us. Hadoop took considerably longer to deliver extensive analyses as their system is based on batch processing. Oracle offered great process integration but didn’t match our expected cost-performance ratio…. Our platform’s high performance relies on in-memory technology using the main storage as an amplifying cache.”

Secure digital payments in <50ms

Turkey’s fastest growing fintech company Iyzico is a secure payment system for more than 35,000 companies and 600,000 consumers. Founded in 2013 by Barbaros Özbugutu und Tahsin Isin, the Istanbul-based company started out to digitize SMEs in Turkey. Today, global players Amazon, Nike, H&#038;M, and Zara rely on its technology to accept payments in local currency and eliminate fraud.

İlkay Düzgün

“We had a fully functioning, future-proofed solution within a month.... Our data team is small and relies on the fast delivery of results.”

Eine performante Datenbank, die nahtlose Integration mit leistungsfähigen Analyse-Tools bietet – iyzico nutzt dafür Exasol. Lesen Sie die Success Story.

iyzico

iyzico | Exasol

https://www.exasol.com/app/uploads/2020/06/iyzico-header-scaled.jpg

Query workload wait times reduced from 10 minutes to a few seconds

Simplified set up

Faster, more reliable data layer enables testing more assumptions, automating more reports, delivering results to those that need them sooner.

Faster insights

Technology to build out ML, AI and data lakehouse for archival and accessibility

Powering innovation

With Exasol in place, Piedmont Healthcare has built a comprehensive metric framework with anomaly detection, full record level detail and logic transparency on top of Exasol at a pace of about 20 new metrics per month. That was not possible with previous technology.

Faster insights for better healthcare outcomes

over SQL server workloads

Performance improvement

drop in data mart refresh time for a single table

Faster

in processing time for clinical dashboard data marts

Saved per day

during business hours 

Queries run per hour

Piedmont Healthcare had only four hospitals when Mark Jackson joined the company. Siloed data practices were limiting its ability to expand care to more people. Each hospital had its own EHR system with data aggregated in a Microsoft SQL Server data warehouse. But the system was too slow for dashboarding. A workaround was to extract data to Tableau, but only if the analytics were basic. 
It became clear this strategy wouldn’t scale. Mark’s expertise in Tableau meant he could create complex and informative dashboards, but SQL Server was never going to provide the performance needed — it wouldn’t be fast enough unless the amount of data being made available was scaled back, but the complexity of the questions only increased.

Piedmont began exploring whether an in-memory database specifically designed for analytics was the answer. 
Upon setting up a quick test on a low-powered laptop with no tuning, Exasol boosted performance. After a more thorough test, Piedmont adopted Exasol as the company&#8217;s high-performance data warehouse platform. 
Today, with 16 hospitals and hundreds of other sites, Piedmont Healthcare has around 1.8 trillion data points in Exasol production tables. Since the implementation, Mark has been able to improve the company’s SQL code structure for better performance to maximize Piedmont’s investment.

Analyzing 1.8 trillion data points 1,000 times faster to improve patient care

Every year, two million people are treated at Piedmont Healthcare’s 16 hospitals, 60 urgent and quick care locations, and 550 physician practices. Annually, the provider oversees 88,000 surgeries, delivers 16,000 babies, and completes nearly 400 organ transplants. 
All this generates a lot of data. Piedmont’s Electronic Healthcare Record (EHR) system has over 15TB of clinical, operational, and financial data. On top of this are ERP, CRM, patient surveys, and streams of information flowing in from its call centers. To reduce harm and improve patient satisfaction, delivering actionable insights to hospital leaders is key.

Piedmont Healthcare’s SQL Server-based analytics were not keeping up with growth. Leadership demanded faster access to accurate data. So they brought in Exasol.

Mark Jackson

“With Exasol, I don’t have to anticipate all the ways a user might want to query the database” 

Piedmont Healthcares SQL Server-basierte Analysen konnten mit dem Wachstum nicht mithalten. Erfahren Sie, wie Exasol die Analysegeschwindigkeit erhöhte.

Piedmont wendet sich von SQL Anlytics ab

Piedmont wendet sich von SQL Anlytics ab | Exasol

https://www.exasol.com/app/uploads/2020/06/piedmont_Low-scaled.jpg

Produkte

Deployment

Lern mehr

Kunden Support

TPC-H Benchmark

Alles was Sie über Exasol wissen sollten

Tableau, MicroStrategy, Looker, Yellowfin, PowerBI, Qlik Sense, und mehr

BI Tools

DataRobot, H2O, TensorFlow, SageMaker, SAS

Data-Science Plattform

Infrastruktur

Sicherheit

Informatica, Talend, Alteryx, Pentaho, Kafka, Amazon Kinesis, Keboola, und mehr

Datenintegration

Mehr erfahren

Alle Partner

Integration

AUSGEWÄHLTE KUNDEN

Industries

Bumble: 100M+ User A/B Tests in Sekunden

von internationalen Kunden aller Größen

Kundenbeispiele

On Premises Starten

Cloud Optionen

AUSGEWÄHLTE THEMEN

Lernen

Optimieren Sie Ihre BI Performance mit der Exasol Analytics Datenbank

Dokumentation

Über uns

Aktuelle Pressemeldungen und Veranstaltungen

Newsroom

Careers

Entdecken Sie Nachrichten, Ansichten, Ankündigungen und mehr

Blog

Investor relations

Kontaktieren Sie uns

Unternehmen

leistungsstarke Datenmanagement für komplexe Ad-hoc-Abfragen

geringer Administrationsaufwand hilft IT-Technikern von GfK Entertainment, die TCO zu senken

einzelne Abteilungen haben jetzt Zugang zu ihren eigenen Data Marts

200-mal leistungsstärker als das vorherige System

>1 Minute für die Bearbeitung komplexer Anfragen und Analysen

Die Vorteile

mehr Leistung

jedes Jahr

Vertriebsreports

pro Jahr

Datenwachstum

Im Rechenzentrum des Unternehmens in Baden-Baden werden die verschlüsselten Daten von 50.000 Händlern und mehr als 5.000.000 Produkten zusammengeführt und laufend aktualisiert. Monatlich erfolgen etwa eine Million Zugriffe auf die B2B-Marktforschungsanwendungen. Pro Jahr werden 500.000.000 Händler-Verkaufsmeldungen von GfK Entertainment verarbeitet, allein in der Sparte Musik sind es 500 GB Rohdaten. Jährlich verdoppeln sich die Daten und die Oracle-Datenbank ist an ihre Grenzen gestoßen.

Die Herausforderung

Die Oracle-Lösung soll weiterhin als Enterprise Data Warehouse eingesetzt werden. Exasol sollte genutzt werden, um den gesamten Datenbestand für bestimmte Fachbereiche wie Video oder Musik in einzelne Data Marts umzuwandeln. Nach einem kurzen Evaluierungsprozess wurde Exasol innerhalb von sechs Wochen installiert und in Betrieb genommen.

Die Lösung