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: Light up the future with Posiflex at EuroShop 2020...
11.02.2020   #kiosk terminals #Trade fair special EuroShop 2020

Light up the future with Posiflex at EuroShop 2020

Serviced IoT solutions: personalized, flexible and connected

The Posiflex Group, a synergy of world-leading POS, kiosk, and industrial computing technologies — will bring its Serviced IoT solutions to EuroShop 2020, the leading Europe trade fair for the retail industry, from February 16th – 20th ...

Thumbnail-Photo: Poindus VariPOS TSE Solution
11.02.2020   #security #pos systems

Poindus VariPOS TSE Solution

TSE for German fiscal regulations

Kassensicherungsverordnung (KassenSichV) regulates the technical requirements for electronic recording and security systems, such as Point-of-Sale (POS) systems & electronic cash registers in order to end the manipulation and potential tax ...

Thumbnail-Photo: Toshiba demonstrates the future of shopping at EuroShop 2020...
13.02.2020   #self-checkout systems #Trade fair special EuroShop 2020

Toshiba demonstrates the future of shopping at EuroShop 2020

Toshiba spotlights innovations enabling retailers to create “moments that inspire”

Toshiba Global Commerce Solutions offers EuroShop 2020 attendees a look into the future via its ‘Frictionless Store’, Feb. 16-20, hall 6 booth C41 in Düsseldorf, Germany. Toshiba’s innovative solutions enable retailers to ...

Thumbnail-Photo: Tired of paperwork? It’s time for AI!
26.03.2020   #consulting #brick and mortar retail

Tired of paperwork? It’s time for AI!

Artificial intelligence helps small and medium-sized retailers to tackle accounting

Accounting - A term that is synonymous with stress for many businesses. The minds behind sevDesk felt the same way, which prompted them to develop accounting software that tackles the annoying paperwork. In this interview, CEO Fabian Silberer talks ...

Thumbnail-Photo: WirvonHier – Virtual strolling through retailers from the neighborhood...
02.04.2020   #brick and mortar retail #mobile shopping

WirvonHier – Virtual strolling through retailers from the neighborhood

How an app brings local retailers and customers together contactless

Many retailers have had to close their shops due to the Corona crisis. But this does not mean that as a result the connection to the customer has to suffer. The WirVonHier project shows how to reach customers and moreover connect with their needs ...

Thumbnail-Photo: Toshiba bolsters point-of-sale performance with latest Intel technology...
21.01.2020   #pos marketing #self-checkout systems

Toshiba bolsters point-of-sale performance with latest Intel technology

9th generation Intel® Core™ processor enhances retailer operations and customer experience

Toshiba Global Commerce Solutions continues to empower retailers and enhance the customer experience by integrating Intel’s latest processor technology within its global point-of-sale (POS) systems. The 9th Generation Intel® Core™ ...

Thumbnail-Photo: Self-service for faster checkout
01.01.2020   #epos systems #brick and mortar retail

Self-service for faster checkout

“Moments that Inspire”: Toshiba shows at EuroShop stationary as well as mobile solutions

In the future, there will be the Frictionless Store – no scanning, no hassle for the consumers. But consumers do not want to wait until this can become reality everywhere. The payment process should already be fast and convenient today.At ...

Thumbnail-Photo: Think Different! Thought leadership at ISE 2020...
13.12.2019   #security #digital marketing

Think Different! Thought leadership at ISE 2020

Over 200 specialists to offer expert opinion and insight

Integrated Systems Europe 2020’s professional development programme will feature over 200 leading experts from a wide variety of disciplines and subject areas across five days of keynotes, conferences, masterclasses, workshops and ...

Thumbnail-Photo: Compact for security
17.01.2020   #security #shopfitting

Compact for security

A new security antenna system specifically designed for convenience stores

Retail security systems to prevent theft are a big concern for retailers. Large supermarkets and clothing stores install EAS antennas at the entrance and/or exit areas. Installing this type of feature proves more challenging for stores with a ...

Thumbnail-Photo: Solid Lines 2020, a product range …
01.02.2020   #refrigeration cabinets #Trade fair special EuroShop 2020

Solid Lines 2020, a product range …

… designed with the idea of generating unforgettable shopping experiences

New architectural and design concepts are appearing in the conceptualization of current supermarkets, especially aimed at improving the customers' shopping experience by incorporating solutions that generate value, allowing to optimize energy ...

Supplier

ROQQIO Commerce Solutions GmbH
ROQQIO Commerce Solutions GmbH
Harburger Schloßstraße 28
21079 Hamburg
Frost-Trol s.a.
Frost-Trol s.a.
Ctra. Valencia-Barcelona, km. 68,9
12080 Castellon
SALTO Systems GmbH
SALTO Systems GmbH
Schwelmer Str. 245
42389 Wuppertal
Delfi Technologies GmbH
Delfi Technologies GmbH
Landgraben 75
24232 Schönkirchen
Adasys GmbH – a Poindus Company
Adasys GmbH – a Poindus Company
Max-Planck-Straße 10
70806 Kornwestheim
Saint Gobain Sovis
Avenue de la Republique
2407 Chateau Thierry Cedex
Checkpoint Systems GmbH
Checkpoint Systems GmbH
Ersheimer Str. 69
69434 Hirschhorn a. Neckar
Axis Communications GmbH
Axis Communications GmbH
Adalperostraße 86
85737 Ismaning
APG Cash Drawer (Germany)
APG Cash Drawer (Germany)
Leichtmetallstr. 22a
42781 Haan-Gruiten
ARNEG S.p.A.
ARNEG S.p.A.
Via Venezia, 58
35010 Marsango di Campo San Martino/PD