
Contact Us
KVK Number: 87456346
Address: Amstelveen, Netherlands
Crux Digits collaborated with one of the largest aggregators of e-commerce in Europe to deliver a high-scalable business intelligence solution for it. The end client was working on multiple platforms, such as Amazon, Bol.com, Netsuite, etc. They required an integrated system that would aggregate diversified data sources for informed decision-making through real-time actionable insights on areas like sales performance and efficiency, advertisement effectiveness, and inventory management.
Data Silos: The client had information fragmentation across platforms like Amazon, Bol.com, and Netsuite that made it hard to come up with a holistic view of business performance.
Campaign Performance Tracking: There was no effective means to monitor or optimise advertising campaigns across different channels of e-commerce.
Manual Reporting: The reliance on outdated, manual reporting methods caused significant delays, especially in areas such as inventory management and campaign performance analysis, hindering the client's ability to respond swiftly and make informed business decisions.
Crux Digits developed a cloud-native BI solution built on top of Medallion Architecture framework with Azure services and Databricks. It helped in bringing together data from all sources and integrating the BOL Retailer and Advertising APIs to help optimise the client's advertising and SEO performance.
We adopted a three-tier Medallion Architecture (Bronze, Silver, Gold) so that we could easily manage data transformation and analysis.
The entire data pipeline, including the ETL process, was automated using Azure Functions. Manual intervention was removed, and data can flow gracefully through all layers: Bronze, Silver, and Gold, for stakeholders to gain up-to-date real-time insights to make decisions faster.
With the BOL Advertising API, the client could view the performance of advertising and keywords in real-time. This resulted in continuous optimization of their SEO strategies for better rankings of their products in search and also optimization of advertising spend for better ROI.
We built a dynamic Power BI dashboard to present these insights in an accessible format, displaying real-time sales, advertising, and inventory data in accessible, interactive visualisations that would empower stakeholders to drill down into any particular categories, campaigns, or marketplace metrics, providing them with necessary information to make quick decisions.
Through the integration of Azure services, Databricks, and the BOL Retailer and Advertising API, Crux Digits successfully delivered a scalable, cloud-based BI solution. This solution not only provided real-time, actionable insights into the client’s e-commerce operations but also enabled significant improvements in SEO and advertising strategy. By automating key business processes, the client gained a competitive advantage, leading to better product visibility, increased sales, and sustained business growth in an ever-evolving e-commerce landscape.