Download PDF
DOUGLAS' Transformation: Centralizing 200+ Data Sources with Fivetran
Technology Category
- Analytics & Modeling - Big Data Analytics
- Analytics & Modeling - Data-as-a-Service
Applicable Industries
- Buildings
- Cement
Applicable Functions
- Sales & Marketing
Use Cases
- Building Automation & Control
- Time Sensitive Networking
Services
- Data Science Services
- System Integration
The Challenge
DOUGLAS, a leading premium beauty platform in Europe, was facing a significant challenge in its journey to become a 'Digital First' business. The company's existing infrastructure and processes, particularly around Business Intelligence (BI) and data analytics, were not up to the mark. The systems for collecting data were scattered, and there was an overreliance on spreadsheets and manual input, which were not scalable. This lack of a centralized, automated data collection and analysis system was hindering the company's growth and its ability to gain valuable insights from its data.
About The Customer
DOUGLAS is Europe's leading premium beauty platform, inspiring customers to live their own kind of beauty. The company offers more than 130,000 beauty and lifestyle products through its online shops, beauty marketplace, and over 2,000 stores. In the fiscal year 2019-2020, DOUGLAS generated sales of 3.2 billion euros in areas such as perfumery, decorative cosmetics, skin and hair care, nutritional supplements, and accessories. The company is on a mission to become a 'Digital First' business, and to achieve this, it is investing in state-of-the-art technology and data modelling.
The Solution
To overcome these challenges, DOUGLAS decided to invest in a future-oriented, best-practice combination of Fivetran for automated data integration, Snowflake for the data warehouse, and Tableau for data analytics. This solution involved using around 200 active connectors to pull data from multiple sources with Fivetran, providing the business with market intelligence across a range of areas. The automated data integration by Fivetran allowed BI analysts, BI engineers, data scientists, and marketing and eCommerce experts to turn data into actionable insights more quickly. Additionally, the company now had a robust, resilient, and GDPR-compliant architecture that met all the necessary security requirements for a large, internationally operating online enterprise dealing with sensitive customer data.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
System 800xA at Indian Cement Plants
Chettinad Cement recognized that further efficiencies could be achieved in its cement manufacturing process. It looked to investing in comprehensive operational and control technologies to manage and derive productivity and energy efficiency gains from the assets on Line 2, their second plant in India.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
Case Study
Powering Smart Home Automation solutions with IoT for Energy conservation
Many industry leaders that offer Smart Energy Management products & solutions face challenges including:How to build a scalable platform that can automatically scale-up to on-board ‘n’ number of Smart home devicesData security, solution availability, and reliability are the other critical factors to deal withHow to create a robust common IoT platform that handles any kind of smart devicesHow to enable data management capabilities that would help in intelligent decision-making
Case Study
Commercial Building Automation Boosts Energy Efficiency
One of the challenges to building automation is the multitude of non-interoperable communications protocols that have evolved over the years. Buildings have several islands of automation. Bridging the islands of different automation without losing the considerable investment in each specialized control network is the main focus in this solution.