Customer success

Bakery makes reliable forecasts with anonymous customer data

At a glance

  • AI-supported churn model based solely on anonymised data on purchasing behaviour
  • Controlling can reliably predict customer churn
  • Solution could be built quickly and economically with Azure Cloud services

The business situation of our client

In order to use Artificial Intelligence (AI) to make reliable predictions about the behaviour of your customers, you don’t necessarily need vast amounts of data. Even medium-sized companies with relatively manageable data sets can tap into these exciting possibilities of digitalisation. This is illustrated by our approach to a large German bakery: the company works with anonymous customer cards that primarily offer discount benefits. In fact, the 350,000 active cards are used for about 60 per cent of all purchases. Based on this data on purchasing behaviour alone, we have now trained a so-called churn model that recognises potential customer churn at an early stage makes reliable forecasts.

The solution for our client

To build our AI-supported forecasting model, we first defined the typical “churn”: Customers who have bought from the bakery chain for three months and then not for three months. The model was then trained with this specification and the purchase history from the customer cards.

Our procedure at a glance:

  • We train a model with the Advanced Analytics component of SQL Server in the Azure cloud.
  • Over a longer period of time, we compare the analyses of the model with the purchasing behaviour of the customers.
  • We transfer the analysis results into the existing Business Intelligence system.
  • We make the results available to the controlling department via a self-service application.
  • We continuously refine the classification by means of new data.

How data turns into new values

The solution structure described above makes reliable forecasts of customer behaviour possible in an economical way.

The advantages at a glance:

  • Controlling can reliably predict customer churn tendencies.
  • The analysis of individual customers enables individual marketing measures, e.g. special vouchers.
  • Even small changes in buying behaviour are recognised at an early stage so that quick countermeasures can be taken.
  • Expected sales losses due to cancellations can be analysed by region, branch and time period.
  • Higher-level developments can also be recognised, such as when competition increasingly penetrates a specific region.
  • By using cloud components, the solution can be set up and expanded quickly and cost-effectively.


turn your data into value.

At a glance

  • AI-supported churn model based solely on anonymised data on purchasing behaviour
  • Controlling can reliably predict customer churn
  • Solution could be built quickly and economically with Azure Cloud services
Jens Kröhnert
turn your data into value

Let’s get started!

Do you want to know today what your customers will want tomorrow?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Retail: How data can optimise business with perishable goods

At a glance

  • Web app for the ultra-fresh business enables precise planning of order and delivery quantities
  • Uniform planning and analysis interface accelerates processes
  • Sales potential is better utilised and write-off rates are reduced

The business situation of our client

The right use of data can improve processes at any point in your business and lead to significant savings in time and money. Example retail: For a European market leader, we created a solution that optimised the processes around the business with perishable goods – such as fruit, vegetables and cut flowers. Because: too large order and delivery quantities generate high losses, as the goods expire. If, on the other hand, the shelves in the shops are empty, customers migrate to the competition.

Originally, the company used various applications for its different planning and analysis activities. This not only hindered internal processes. Rather, the quality of the findings also suffered because the underlying data was neither complete nor consistent. We have now united all process steps under one user-friendly interface and at the same time ensured a reliable database.

The solution for our client

We developed our integrated planning and analysis interface with ASP.NET and made it available as a web application via the browser. The app uses reporting services to access a Data Warehouse that provides historical data on sales and promotions by region and time as well as in great detail. In addition, we provide continuously updated supplier evaluations, which are carried out throughout the group at warehouse receipt by means of coordinated KPIs.

The combination of Reporting Services and ASP.NET enables data-supported planning with a high degree of user-friendliness. In addition, export options are available in a wide variety of formats, through which analysis results can be seamlessly transferred to further systems such as SAP.

How data turns into new values

The retail group now uses its data effectively for the entire organisation of its ultra-fresh business. In the process, values are created at different levels:

Employees

  • All analyses from quantity to promotion to seasonal planning are covered
  • Fast and efficient work via a fully integrated web interface
  • Suggestions from the system provide well-founded decision support
  • Better supplier selection through quality analyses based on KPIs and thresholds
  • Completed planning can be aggregated and sent directly to downstream systems in report form

Company

  • Cost savings through accelerated processes and lower write-off rates
  • Improved customer satisfaction and loyalty due to better availability of goods
  • Increased turnover due to better use of sales opportunities

Consumers and society

  • Goods are available to consumers when they need them
  • Less food goes straight to waste


turn your data into value.

At a glance

  • Web app for the ultra-fresh business enables precise planning of order and delivery quantities
  • Uniform planning and analysis interface accelerates processes
  • Sales potential is better utilised and write-off rates are reduced
Jens Kröhnert
turn your data into value

Let’s get started!

Would you also like to use your data to optimise the processes around your business?

Join #teamoraylispeople

Shape the world
of data with us