There is no need to introduce IKEA. Nevertheless, you might be interested in knowing: As of August 31, 2015, the IKEA Group had 328 stores in 28 countries featuring a range of approx. 9,500 products amongst which around 2,500 of them are renewed and redesigned every year. In FY2015, 771 mil. people visited IKEA stores, an increase of 7.7% over FY2014. 155 thousand employees served IKEA customers worldwide. In FY2015, the IKEA Group had 978 home furnishing suppliers in 50 countries. Total sales reached €31.9 billion.
Building a data warehouse (DWH) for IKEA Czech Republic, Hungary and Slovakia continues the customer data quality project. The new DWH collects and centralizes data from 4 stores in the Czech Republic, 2 stores in Hungary and 1 in Slovakia. IKEA requested Adastra to deliver a DWH as a service to avoid maintaining of servers, licenses, solution operations and others.
Customer requested to deliver a DWH as a service
Scheme: Design of IKEA DWH solution
Solution benefits and uses:
The final cloud solution supports the client in the following ways:
MS SQL Server technology was chosen for the designed solution. The solution runs on hosted servers, i.e., from the customer point of view in the cloud. Selecting a hosting partner was also a unique challenge for Adastra as it was our first foray into such a partnership. Based on a short tender and many discussions we opted for Cloud4com. The hosting partner was rigorously tested and reviewed by both IKEA's IT department and Adastra and it successfully passed all security tests.
A Data Warehouse contains data from multiple areas: purchase transactions, returned goods, the product catalogue, customer data (incl. personal data, contact data, addresses and socio-demographic data), marketing campaigns plus responses and more. As you can imagine from the list above, the DWH is huge. It covers 3 Central-European countries and 7 stores. Source system data are loaded from IKEA network storages (purchase transactions for example) to the DWH as well as from external partners who upload data on the SFTP server in our cloud. All data are delivered to the DWH as text extracts on a daily basis.
Adastra successfully completed the project and it is working now. Go ahead, have a look. Those of you who are members of IKEA FAMILY (or their wives J) can now find their purchase history at the new IKEA FAMILY web site. The deployment of an Adastra's Campaign Management was another key feature of the project.