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

in 3 Central European countries are covered by the new data warehouse

lasted the realization of the full solution

Why don’t IKEA FAMILY members need to keep their receipts? The answer is easy: they are always available online. IKEA has a new Data Warehouse (DWH) that saves all purchase transactions.

You can check yours via the IKEA FAMILY web site so you don’t need to worry about losing the original paper receipts from the cash desk.

The new DWH solution implemented by Adastra for IKEA enables much more. The solution operates in a cloud environment accessible via VPN, i. e., secured, and we provide it to IKEA as a service.

A problem we had to face

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.”
Iveta Kutišová, Country Ikea Family manager, Ikea CZ/HU/SK

Our suggested solution

“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.”

Scheme: Design of IKEA DWH solution

Solution benefits and uses

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.)

What was the outcome of the project

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.

Are you interested in a similar solution? Contact us.

Jiří Balcárek
Ředitel divize Telco & Retail

Get inspired on our blog

Adastra Group’s Revenue Exceeds 5 Billion CZK for the First Time

In 2022, Adastra Group's revenue reached 5.6 billion CZK, marking the first time in the company's history that it surpassed the 5 billion CZK...

Read more

Unraveling the Future: Top 8 Data Management Trends for 2023 and Beyond 

The digital landscape is evolving at an unprecedented pace, and with it comes a new set of challenges and opportunities for IT professionals, data...

Read more

František Jungr (Visa): We are about to expand the Click to Pay service. Rewriting the card number when paying online is unsustainable in the long term

"XP payments, especially through Apple Pay and Google Pay, will become increasingly available at more merchants. At the same time, alternative payment options will...

Read more