Interview • 05.06.2018

Business Intelligence: The single source of truth

How retailer use data analytics and BI to optimize the value chain

Hardly any business process is managed without the help of IT. That’s why the main task for retailers is not to gather data about business processes but to make the most of this data instead.

Business Intelligence (BI) is the “secret weapon” that helps retailers with this endeavor. Professor Dr. Olaf Jacob, a business analytics and business intelligence expert at the University of Applied Sciences Neu-Ulm in Germany, explains how retailers use BI in their businesses and describes the benefits they can reap.

Prof. Olaf Jacob; copyright: Olaf Jacob, HS Neu-Ulm...
Professor Dr. Olaf Jacob is Vice President for Research and Digitalisation at the University of Applied Sciences Neu-Ulm in Germany, also head of the degree programme Master of Business Intelligence and Business Analytics as well as head of the Centre for Data Science & Business Analytics.
Source: Olaf Jacob, HS Neu-Ulm

How does Business Intelligence benefit business owners?

Business intelligence enables businesspersons to gather and compress data from their day-to-day business and obtain information relevant to management: about the business in general and its processes, customers, and suppliers. With these resources, entrepreneurs can improve business decisions.

How does this work?

From a technical perspective, BI systems try to create an integrated and consolidated data pool. It contains all company data that’s relevant to management and that can be used for a variety of analysis processes. This is also called the "single source of truth". It ensures that all decision-makers in the company have the "same and accurate" data.

The data analysis pursues two goals: on the one hand, past events and data are analyzed. A retailer might be interested to know what his/her top ten products were in the previous week for example. On the other hand, the analysis can be used for forecasting and to answer questions such as: Based on sales volume, what will be the top five products in the coming week? These "predictive analytics" go along with high expectations.

What opportunities does the proper implementation of BI afford retailers?

First and foremost, BI delivers transparency and data compression. Transparency in business operations allows comparability. For example, this lets users determine the contribution margins of different product groups and compare them with one another. Compressed data permits ongoing reporting of key performance indicators that are relevant to the organization. These include factors such as inventory turnover rates or the payment history of customers.

Virtual numbers and diagrams; copyright: panthermedia.net / peshkova...
Source: panthermedia.net / peshkova

Which business areas and processes of a retail company can especially benefit from this?

In essence, the entire retail value chain - ranging from purchasing to warehousing all the way to sales and after-sales - offers a broad spectrum of applications of BI. There are two dominating segments: product and customer analytics, as well as branch network management.

In addition to typical sales statistics, another example of the first category is the ABC analysis. This lets retailers group customers and products in order of importance and contribution to sales or analyze the productivity of distribution channels.

An analysis and comparison of sales and inventory levels of several branches simplifies the targeted management of the branch network.

Can you identify trends in the field of BI that will determine its future application?

The trend is clear: data analytics and big data. Data fuels the information society and is expected to accumulate and grow extensively in the future. Data must be considered a raw material that needs to be systematically mined, maintained and managed.

Due to the advancing digitization and online retailing, it is crucial to analyze data in real-time and utilize it for a targeted customer approach. Amazon is a pioneer in this area by adding the note “customers who bought this item also bought these products".

The trend will move towards omnichannel marketing. This means retailers will collect and integrate data across all touchpoints – including online shop, call center or physical store – to glean a 360-degree view of their customers.

Should even small and medium-sized retailers look into BI?

BI is beneficial, even for small retailers. An application should always be considered, if the options of BI provide a benefit that is manually unobtainable or only attainable by exerting a lot of effort. Needless to say, this implies that a crucial amount of customer and product data can no longer be managed in a manual fashion. The market offers cost-efficient BI tools that deliver simple analytics within a few short days.

Having said that, it is important to note that this data must be collected from a functional place, meaning you mustn’t put the cart before the horse. BI depends on data from the value chain, which is ideally not provided via manual settings but rather through various data pre-processing systems such as cash registers with scanners, online stores or payment systems.

Is there a difference between the application of BI in brick-and-mortar versus online retail settings?

The principle of analysis and compression of data essentially remains the same. One example of this is market basket analysis ("Which combinations of items were purchased together"?) retailers can conduct for both offline and online business.

Quite often, it’s much easier to apply BI to online retail settings due to the already existing data. This data provides special analysis options for consumer behavior and answers questions as to why customers placed items into their electronic shopping cart but did not complete the purchase.

Do you have tips for the practical implementation in a company?

Provided that the corresponding data pre-processing systems are in place that provide the data for BI applications, you have to initially ask questions about the business and not the technologies. Examples of this are: What types of analysis do I need? How do these analyses help to boost the value chain productivity or help me to truly understand my customers?

The actual technical implementation starts once the business goals have been clarified. Here, data management is the top priority at the outset: retailers must determine where data is being generated in the company and how they can ensure that this data is accurate and updated.

Interview: Julia Pott, iXtenso - Magazine for Retailers

related articles:

popular articles:

Thumbnail-Photo: How do technologies find their way into retail?...
17.03.2021   #brick and mortar retail #self-checkout systems

How do technologies find their way into retail?

Rolf Schumann, CDO of the Schwarz Group, provides answers at the "Retail Innovation Days"

Tech is cool! Gimmicks, gadgets, gizmos – they impress and inspire quickly. However, it often takes much longer than technology experts and developers initially predict before the technologies actually arrive in everyday life and are used by ...

Thumbnail-Photo: FinTech IoT platform for self-service financial transactions...
25.02.2021   #cash management #cash handling systems

FinTech IoT platform for self-service financial transactions

PayComplete, the new cash handling brand from SUZOHAPP, announces global launch

PayComplete, the new brand and identity of the cash handling division of SUZOHAPP announced its launch today. This new brand will invest in what is an Internet of Things (IoT) platform for broader financial transactions, running both on ...

Thumbnail-Photo: Robotic canteen set to change the global food and hospitality industry...
10.12.2020   #food retail #food technology

Robotic canteen set to change the global food and hospitality industry

Karakuri showcasing its pre-production machine

Karakuri, a food robotics company, lifts the lid to unveil the world’s first automated canteen to make meals, the DK-One. Karakuri’s robotic system will revolutionise how and what we eat in restaurants, canteens, buffets, hotels and ...

Thumbnail-Photo: Southeast Asian online and offline health and beauty partnership...
06.02.2021   #online trading #e-commerce

Southeast Asian online and offline health and beauty partnership

Grab brings beauty products from over 2,200 Watsons stores to customers’ doorsteps

A.S. Watson Group, an international health and beauty retailer, and Grab, Southeast Asia’s super app, announced the largest O+O (online and offline) health and beauty partnership in Southeast Asia, spanning across six Southeast Asian markets ...

Thumbnail-Photo: BAUHAUS introduces new click and collect technology...
10.03.2021   #electronic shelf labels (ESL) #price labelling

BAUHAUS introduces new click and collect technology

New solution helps store associates pick items for Click & Collect orders

With help from electronic shelf labels and handheld terminals, it has become much faster and easier for BAUHAUS to navigate through the store to find the right items. A new solution that also saves a lot of time on replenishment.With a product range ...

Thumbnail-Photo: A completely new experience at ICA Kvantum with Breece...
15.12.2020   #electronic shelf labels (ESL) #price labelling

A completely new experience at ICA Kvantum with Breece

ICA Kvantum in Lerum has invested in new technology: A cloud-based electronic shelf label

ICA Kvantum Lerum has for a long time been looking for a supplier of electronic shelf labels (ESL), so the staff no longer have to spend time and resources on changing paper shelf labels. It was important that it should be a ...

Thumbnail-Photo: Klarna starts cooperation with Verifone
23.12.2020   #digitization #self-checkout systems

Klarna starts cooperation with Verifone

The idea: a shopping experience in stores that is unique worldwide

Klarna, the leading global payments and shopping service, announces a strategic partnership with Verifone, a global leader in payments and commerce solutions, that will make Klarna available as the first-ever buy now pay later solution to millions ...

Thumbnail-Photo: Successful co-op association has the largest profit in the country...
24.12.2020   #electronic shelf labels (ESL) #price labelling

Successful co-op association has the largest profit in the country

The local Kvickly store has found the recipe for making profit. In the future, even more energy will be spent on customers and staff members

Electronic shelf labels play a crucial role here.

Thumbnail-Photo: The rise of the virtual fitting room with the corona pandemic?...
30.11.2020   #fashion #virtual reality

The rise of the virtual fitting room with the corona pandemic?

Trying on clothes via AI, AR or VR

The rising usage of smartphones is expected to take the virtual fitting room market to $19,250.4 million by 2030, from $3,128.6 million in 2019, at an 18.5% CAGR between 2020 and 2030.A virtual fitting room is a digital representation of a fitting ...

Thumbnail-Photo: Vending machines: Customers alone in the store...
18.01.2021   #sales promotion #food retail

Vending machines: Customers alone in the store

Combi City-Markt makes round-the-clock shopping possible – without staff

Shopping after closing time? That’s possible at the Combi City store Bünting in Oldenburg. At the 24/7 vending machine, late at night shoppers have the opportunity to stock up on everything they need from the supermarket's ...

Supplier

SALTO Systems GmbH
SALTO Systems GmbH
Schwelmer Str. 245
42389 Wuppertal
Axis Communications GmbH
Axis Communications GmbH
Adalperostraße 86
85737 Ismaning
Reflexis Systems GmbH
Reflexis Systems GmbH
Kokkolastr. 5-7
40882 Ratingen
EuroShop
EuroShop
Stockumer Kirchstraße 61
40474 Düsseldorf
GMO Registry, Inc.
GMO Registry, Inc.
Cerulean Tower, 26-1 / Sakuragaoka-cho, Shibuya-ku,
150-8512 Tokyo
Citizen Systems Europe GmbH
Citizen Systems Europe GmbH
Otto-Hirsch-Brücken 17
70329 Stuttgart
CCV GmbH
CCV GmbH
Gewerbering 1
84072 Au i.d.Hallertau
APG Cash Drawer
APG Cash Drawer
4 The Drove
BN9 0LA Newhaven
iXtenso - Magazin für den Einzelhandel
iXtenso - Magazin für den Einzelhandel
Celsiusstraße 43
53125 Bonn
HappyOrNot
HappyOrNot
Innere Kanalstraße 15
40476 Düsseldorf