Data Warehouse as a service for IKEA CZ, HU and SK

Customer requested to deliver a DWH as a service

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.

“The key to implementing this project quickly and successfully was our partner Adastra. Adastra prides itself on the same values as our specialist teams at IKEA. Cooperating with them was absolutely great. We carried out the full solution from data warehouse design to the customer web portal in only seven months. The customer portal with purchase history is highly visited and IKEA employees can handle customer requests faster if they are IKEA FAMILY members. If there were more companies like Adastra, there wouldn’t be any failed projects.”

The final cloud solution supports the client in the following ways:

• Predefined reports in MS Reporting Services accessible in a web browser or distributed by email (e.g., KPI reports, sales reports for selected products and product groups, campaign and event evaluations, sales geography, visitation, customer base analyses and others)
• A data cube for ad-hoc analysis accessible via Excel (analysis of sales, receipts, customers etc.)
• Electronic receipt (transaction history of IKEA customers was a requirement of the client) – for IKEA employees via a web application and for IKEA customers (IKEA FAMILY members) as a part of a newly implemented IKEA FAMILY web site
• Targeting customers in campaigns via Adastra Campaign Management (another part of the final solution)
• SQL querying via the SQL Server Management Studio via a remote desktop (ad-hoc reporting etc.)
• Regular and ad-hoc analyses of customer purchase behavior at IKEA (frequency of purchases, average receipt, customer life-cycle etc.)

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.