Graph database solution for real-time sales and chemical composition analytics at scale.
The client is a UK-based chemical manufacturer. The company was looking for a more efficient way to analyze the chemical composition of mixtures and products as well as their test results. The sales data of a particular chemical product also remained untapped requiring a robust analytical solution.
The client wanted to focus on a graph-based querying data solution that retrieves streaming data on sales and product chemical composition. The insights should then be visualized for recording and scoring information as well as becoming a reliable source of data-driven critical business decisions.
The main issue was that the client’s existing data storage approach revolved around unstructured production data that came in various stages and forms. Besides, the data had complex parent-child relations that required to be maintained for querying and follow up analysis.
A new compiling process was required that would include newly created metadata and database relations to request information using a graph database without utilizing much computing power as well within a time constraint of 5 seconds.
Our Big data engineering team performed a thorough analysis of the client’s requirements and bottlenecks. The following scope of work was performed to transform the data:
The whole transformation process was carried out by three Big data specialists, including a data architect, data engineer, and BI expert. The business intelligence project was completed in 6 months.
Here is the solution architecture that demonstrates this case study of the chemical industry and data lifecycle:
As a result of our collaboration, we have transformed the client’s data stack and delivered a tailored advanced data analytics solution that drastically improved decision-making, real-time analytics, and insight extraction. The company now has a comprehensive data-driven overview of chemical composition analysis as well as historical customer data that is visualized within a scalable platform for self-service and enterprise business intelligence.