INTRODUCTION The client is a leading technology and manufacturing company. This company creates smart solutions for the industry, pushing the digitalization and therefore supporting the departments by delivering a digital knowledge base. CASE DESCRIPTION The company sought to obtain a comprehensive overview of its products and systems across all departments and end customers. The goal is to monitor the quality of supplied products and systems and ensure ongoing maintenance and quality. Further the client wants to improve service provision and provide custom offers to the corresponding department or customer, which potentially leads to cost reduction as well as revenue growth.
To achieve the goal and solve the problem, some challenges regarding the existing solution need to be addressed. This includes notably poor data quality, as well as systemic deficiencies in ensuring data reliability and integrity. These subjects originate from missing processes to ensure quality of data, as well as complex and semi-structured data. Additionally the current solution faces some difficulties integrating data from various sources, followed by scalability issues as well as a slow performance due to loading dependencies. These challenges take on a special dimension, as they involve a wide range of heterogeneous source systems. That’s why they were looking for a consulting partner, which provides knowledge regarding these problems and is also capable of promoting a suitable solution. The client selected Scalefree to collaborate with the internal team in designing the data model and solution architecture. Scalefree initiated the process by integrating various data sources and streaming incoming data through Kafka, preparing for a near-real-time solution. Introducing dbt cloud with Scalefree’s Data Vault 2.0 package, datavault4dbt, enabled standardized development processes. This was extended by individualized dbt Macros and Models to relocate business logics, ensuring data reliability and quality within the new solution. Finally, Scalefree developed an ETL strategy to meet specified loading times and targets.
Utilizing the solution as a comprehensive approach to enhance customer experiences, the client anticipates identifying the relationship between their products and systems across departments and customers for quality assurance and service provision. This is expected to enable tailored offerings, data-driven insights, and automated processes to improve customer service and experience. The emphasis lies on potential benefits such as streamlined production, projected cost reduction, revenue growth, compliance, and efficient decision-making through centralized data management.
INTEGRATED PRODUCT MONITORING FOR QUALITY ASSURANCE AND CUSTOMER SERVICE OPTIMIZATION © SCALEFREE INTERNATIONAL GMBH 2024
2/3
Powered by FlippingBook