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: Make room for innovation: Cloud services for agile businesses...
05.10.2018   #data warehouse management #software as a service (SaaS)

Make room for innovation: Cloud services for agile businesses

Implement your retail pilot projects faster than ever. Interview with SAP retail experts.

Leaner, faster, more useful: Cloud solutions help analyze customer information and make meaningful use of it. Ralf Kern and Achim Schneider of the Industry Business Unit Retail at SAP reveal which retailers no longer want to do without the cloud and ...

Thumbnail-Photo: Real-time personalization: “A ten percent sales increase is possible“...
19.12.2018   #digital marketing #customer analysis

Real-time personalization: “A ten percent sales increase is possible“

Interview on individualized user experience with Gregor Wolf, Managing Director of Evergage GmbH

"Customers who bought this washing machine also bought these socks." Customers don’t want to see bad recommendations like this one when they shop online. But how can retailers suggest items that are more relevant to customers? We ...

Thumbnail-Photo: APG at the Paris Retail Week
07.09.2018   #cashpoints, cash register, cash desk #cash drawers

APG at the Paris Retail Week

APG cash drawer to showcase queue reducing solutions

APG Cash Drawer will be showcasing its mobile cash management solutions, NetPRO®, TabletPRO™ and USBPro™ at Paris Retail Week, which plays host to over 40,000 visitors looking for the latest retail technology. The highlight ...

Thumbnail-Photo: Mastercard moves beyond signatures worldwide...
05.11.2018   #POS Solutions

Mastercard moves beyond signatures worldwide

It is the first network to make signatures optional on the card and in the store

For cardholders, not needing to sign creates a faster and more streamlined point of sale experience. Today, consumers experience this when they tap to pay contactless card payments are quick, secure and don’t often require a signature. This ...

Thumbnail-Photo: Toshiba is the leader in EPOS technology
18.10.2018   #cashpoints, cash register, cash desk #self service terminals

Toshiba is the leader in EPOS technology

Nearly 50 percent growth in self checkout market share

Toshiba Global Commerce Solutions (TGCS), the global market share leader in installed retail point of sale (EPOS) technology, has rapidly-grown its worldwide self-checkout (SCO) market share by 46 percent, according to research and consulting ...

Thumbnail-Photo: 6 seal of approvals every online retailer needs to know...
08.11.2018   #online trading #security

6 seal of approvals every online retailer needs to know

Badges boost consumer confidence and increase product sales of online stores

Certificates for online stores are a dime a dozen. Many store owners find it difficult to keep track of all of them. Having said that, customers prefer to shop on websites that have been approved by experts. Yet how valuable are these certificates, ...

Thumbnail-Photo: Accurate and efficient: Artificial Intelligence for hiring and...
12.12.2018   #personnel management #artificial intelligence

Accurate and efficient: Artificial Intelligence for hiring and recruiting employees

"Other channels are no longer working": Interview with Melikshah Ünver from Taledo

Skilled labor shortage, high turnover rates and the challenges of digitization: recruiting and hiring top-quality employees is especially difficult in the retail sector, particularly when companies must shake off a dull and dusty image. This is when ...

Thumbnail-Photo: Cash as a driver of innovation
26.11.2018   #cash management #cash handling systeme

Cash as a driver of innovation

Interview with Frédéric Beuve, Director of Global SMARTtill Technology at APG Cash Drawer

During the Equipmag show in Paris in September, iXtenso had the opportunity to speak with Frédéric Beuve, Director of Global SMARTtill Technology at APG Cash Drawer, about his ongoing projects within Europe and his view into the ...

Thumbnail-Photo: ISE 2019 to showcase the finest in international AV...
29.11.2018   #event

ISE 2019 to showcase the finest in international AV

All the connections you need at the world’s largest systems integration exhibition

The 2019 edition of Integrated Systems Europe is set to be the largest in the show’s history, with more exhibitors, more floor space, more visitors and more events than ever before. ISE 2019 takes place at the RAI Amsterdam from Tuesday 5 ...

Thumbnail-Photo: Sharing is caring
08.11.2018   #customer satisfaction #sustainability

Sharing is caring

Renting versus buying: Outdoor specialty store VAUDE dares to venture out

Renting outdoor gear and equipment versus buying it? That's okay. VAUDE makes it possible since 2017. The company’s "iRentit" project is still in its infancy. A good time for us to sit down with Lisa Fiedler, who co-developed the ...

Supplier

Verifone (UK) Limited
7 Cowley Business Park, High Street
UB8 2AD Cowley, Uxbridge
AURES Technologies GmbH
AURES Technologies GmbH
Maisacherstr. 118
82256 Fürstenfeldbruck
Delfi Technologies GmbH
Delfi Technologies GmbH
Landgraben 75
24232 Schönkirchen
CCV Deutschland GmbH
CCV Deutschland GmbH
Gewerbering 1
84072 Au i.d.Hallertau
Permaplay Media Solutions GmbH
Permaplay Media Solutions GmbH
Aschmattstr. 8
76532 Baden-Baden
Superdata EDV-Vertrieb GmbH
Superdata EDV-Vertrieb GmbH
Ruhrstr. 90
22761 Hamburg
APG Cash Drawer
APG Cash Drawer
4 The Drove
BN9 0LA Newhaven