September 16, 2022
Our customer is a British global cigarette and tobacco assembling organization active in over 100 countries.
In response to our customer’s request, we have formulated a modern data warehouse solution featuring a multi-platform architecture in a hybrid environment.
In order to grow the existing data warehouse and extend it into a modern variant, we worked with the customer to enable them to define and formulate new data modelling strategies for the customer, while creating a new partitioning. We also touched on items such as in-memory structures, MPP and clustered columnstore indexes.
Through this customer modern data warehouse solution, we extended the capabilities by adding complementary storage and analytics tools, on a hybrid infrastructure complete with data virtualization functionalities.
Data marts were put in place to fuel the in-memory model, while a master data capability communicated with the data warehouse.
Furthermore, the solution is set up as scalable with a view of adding data lakes as a history area for the data warehouse in a future development phase. The objective of the data lake architecture is to enable an archival process based on a predefined data retention policy as well as to allow for data retrieval based on federated query. The data lake store capability could further integrate several areas for raw data as a staging environment, as well as an active archive operating in parallel and fueling the near-to-real-time analytics and reporting tools.
In terms of technology, the solution was deployed using the Microsoft stack where our consultants and developers are certified. Other technologies such as Hadoop, NoSQL can also be accommodated and are recommended based on best practice and best fit for the customer need.
We’d love to hear about your plans for transformation.
Use the form below to send us a message, and we will get back to you within 24 hours.
New Broad Street House, 35 New Broad Street, London, EC2M 1NH
4D Gara Herastrau Street, 2nd Floor
Building C, 020334
+40 31 425 19 08
30 Stirbei Voda Blvd,
Malmo Business Center, 200423
+40 35 142 36 80