Customer success

Digital platform gives mobile provider a competitive edge

At a glance

  • Central, digital platform brings together all data with maximum depth of detail
  • Those responsible receive a comprehensive view of all relevant business processes
  • Various departments use data to create new value for the company, customers and employees

The business situation of our client

Like all mobile phone providers, one of our clients was struggling with massive competition and cost pressure in the industry. At the same time, the company’s extensive data hid a wide range of potentials to differentiate itself from the competition and to complete the digital transformation. However, due to a proliferation of different analytical solutions and data silos in the individual departments, these remained largely unused:

  • Fragmented data – for example on purchase history, reaction to campaigns or behaviour on the web – made an overarching view of the customer impossible.
  • Due to a lack of data quality, depth of detail and possibilities for linking, it was not possible to carry out multi-value analyses on customers, products, branches, supply chains or financial flows.
  • Due to the lack of a single point of truth, no consistent business metrics were available as a basis for key decisions.
  • Issuing different front-ends drove up operating costs.

Therefore, it was necessary to consolidate all data with maximum detail on a central, digital platform and make it available for different use cases and analyses of the individual departments. A uniform self-service solution for all areas was to support this objective. Similarly, reporting for management and operational processes had to be standardised across departments. Last but not least, real-time data was to be made usable for the business.

The solution for our client

Our client’s integrated platform is to be understood as a Modern Data Warehouse. As usual, we exclusively used Microsoft technologies. The development included the following steps:

 

  1. Formation of a BI Competence Centre in Controlling
  2. Data modelling: We network all data on the platform in maximum detail. The flexible data model enables rapid adaptation to market changes.
  3. Data integration: All departments and their data are integrated step by step.
  4. Near-real-time: Based on a Lambda architecture, we enable the processing of real-time data in all required processes.
  5. Self-service: Business users receive easy-to-use self-service tools (Excel, Power BI). The self-explanatory data model also allows simple data management activities.
  6. Ad-hoc analysis: Business users have the option of carrying out free analyses in the data rooms provided.
  7. Data governance: The solution is legally approved by data protection officers.

 

How data turns into new values

Our client now has a comprehensive view of all relevant business processes. The different departments can use all data for their respective use cases to optimise the business and create new values that benefit the company, its customers as well as its own employees:

  • Need-based customer targeting: customers are addressed with the appropriate products at the right time on the preferred channel.
  • New products: Fine segmentation enables innovative offers and quick adaptation to market trends.
  • Reliable contribution margins: Sales of contracts can already be forecast when the contract is signed.
  • Mobile sales management: Reports and dashboards can be accessed on all conceivable devices.
  • Transparent dealer management: Advertising cost subsidies, sales promotions and commissions are clearly displayed.
  • Detailed advertising success control: The success of advertising measures on the web can be evaluated in detail, right down to the contribution margin achieved per customer.
  • Fraud detection: Within a few months, irregularities were uncovered that would have caused losses in the millions.
  • Churn management: Customers who are willing to switch are identified at an early stage and addressed with individual marketing measures.


turn your data into value.

At a glance

  • Central, digital platform brings together all data with maximum depth of detail
  • Those responsible receive a comprehensive view of all relevant business processes
  • Various departments use data to create new value for the company, customers and employees
Jens Kröhnert
turn your data into value

Let’s get started!

Do you want to modernise your data analytics and unlock new value for your business, your customers and your employees?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Digital services support car park owners and car park users

At a glance

  • Special BI module enables data-based car park management
  • Operators can define occupancy-based tariffs
  • Solution enables better utilisation and higher customer loyalty

The business situation of our client

Business Intelligence (BI) systems offer the opportunity in almost every industry to use data to unlock new value for their own business and their customers. A leading provider of car park infrastructure offers a good example. The company supplies car park owners with a wide range of components for their operations – from barrier systems and video surveillance to cash register systems and software controls.

Together with us, they wanted to expand their range of services with data-driven services that would benefit both car park operators and their customers. The focus was primarily on utilisation-dependent tariff models that were more strongly oriented towards the habits of the car park users.

The solution for our client

For this purpose, we extended the operative software that the company provides for each car park operator with a special business intelligence module. It is based on Microsoft’s SQL Server and offers a wide range of evaluation options. Here, the operator’s operational data is extracted, processed and finally collected in a Data Warehouse. The spectrum of data ranges from technical events such as barrier movements to cash flow. Corresponding reports are then provided via an OLAP cube with Analysis Services. Operators can also perform free ad-hoc-analyses on the data.

How data turns into new values

With the help of this solution, our client’s customers can now segment car park users into groups such as long-term parkers or one-time users for the first time. Based on this information, various pricing models can be calculated to improve both occupancy and turnover. For example, long-term parkers receive their own customer cards at special rates. If typical gaps in capacity utilisation are identified, the operator can offer particularly favourable prices at these times. In addition, there is the option of querying minute-by-minute stands across all locations and retrieving the total turnover. As a result, intelligent parking management ensures better utilisation, higher turnover and increased customer loyalty.


turn your data into value.

At a glance

  • Special BI module enables data-based car park management
  • Operators can define occupancy-based tariffs
  • Solution enables better utilisation and higher customer loyalty
Jens Kröhnert
turn your data into value

Let’s get started!

Would you like to use your data for digital services that give you an edge over your competitors?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Retail business: How to optimise your advertising expenses

At a glance

  • Advertising success monitoring model measures the results of marketing campaigns
  • Findings enable optimal item mix for campaigns
  • Success of planned campaigns can be predicted by means of key figures

The business situation of our client

“I know half my advertising is money thrown out. I just don’t know which half.” – The much-quoted wisdom of Henry Ford has lost none of its relevance for the retail industry. On the contrary: due to saturated markets, the industry is mainly occupied with competing with each other for customers by means of massive advertising campaigns. In the meantime, a large part of the marketing expenditures of retail companies is allotted to this item – and the trend is still rising.

Unlike Henry Ford, however, retailers today can use their data to determine the share of misinvested advertising money relatively precisely and reduce it in a targeted manner. For example, we have developed an advertising success control model for a large German retail company that makes exactly this possible.

The solution for our client

Technologically, the model is based on a very powerful Microsoft platform. With the help of the solution, our client can first store and calculate the baseline sales per day and shop for each of their items. These normal values are then compared to the sales in a promotional period. The difference results in the turnover achieved with the respective promotional measure – traceable down to the receipt level and for each individual article. It is also measured whether a promotional item promotes a deadweight loss.

How data turns into values

Our customer can now evaluate the success of his advertising in detail. For each promotion, the top sellers, slow sellers and slow sellers can be precisely identified and stored in the system. A combined view of the different advertising channels is also possible. In addition, external sources such as competitive, weather or demographic data are used.

All these findings are finally incorporated into an index that measures the expected success by means of defined key figures already during the planning of campaigns – such as an offer brochure. If the evaluation is negative, our client can readjust accordingly. In this way, the optimal article mix can be defined for each advertising medium and channel, while also preventing cannibalisation effects.


turn your data into value.

At a glance

  • Advertising success monitoring model measures the results of marketing campaigns
  • Findings enable optimal item mix for campaigns
  • Success of planned campaigns can be predicted by means of key figures
Jens Kröhnert
turn your data into value

Let’s get started!

Would you also like to use your data to invest your advertising money optimally?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Analysis of receipts down to item level: Retailer gains maximum benefit for business

At a glance

  • Central, digital platform brings together three years of historical POS data
  • For the first time, receipt data can be analysed down to item level
  • Various departments from controlling and marketing to purchasing and auditing benefit from the findings.

The business situation of our client

In retail, the analysis of receipts can be a source for a variety of business improvements. However, not all receipt data analysis is the same, as the example of one of our clients shows. The large retail group was already using cash register data as a decision support tool. But only historical evaluations could be made on aggregated data. Ad-hoc analyses were also hardly possible. Accordingly, the potential of the extensive available data was at best only rudimentarily unlocked.

This situation was mainly due to the fact that each department was working on its own systems with too little performance and its own, very limited data pool. Therefore, our most important step was to consolidate all data with maximum detail in a modern enterprise Data Warehouse (DWH) to network it and make it available company-wide.

The solution for our client

In the central enterprise DWH, we have combined the historical cash register data of the past three years. In total, this involves over 100 billion receipt lines or 30 TB of data. The enormous amounts of data as well as the complex requirements of a detailed receipt data analysis require a high-performance data model as well as modern, powerful technologies. In addition to our many years of experience, Microsoft products have provided us with the best services here, as usual.

The new solution offers our customer high data quality, great transparency of sources as well as very efficient data processing. For example, data for ad-hoc analyses can be retrieved within a few seconds. The data is processed intelligently – i.e. even different formats can be read out uniformly in one processing step. These processes are automated.

How data turns into new values

Our customer can now analyse every receipt down to the level of individual items. This benefits very different areas of the company, such as:

Controlling

  • Ad-hoc analyses with all relevant key figures and dimensions
  • Comparison of branches and regions as well as products and product groups
  • Data can be used as a reliable basis for important decisions

Marketing

  • Data on baseline sales per day, shop and article, as well as on the take-up effects of promotional merchandise
  • Model for advertising success control optimises marketing expenses
  • Integrated inventory management for supplementary evaluation of seasonal items and discount promotions
  • Customised offers and discounts for customers
  • Purchasing
  • Determination of the best price in relation to sales increases turnover and profits
  • Evaluation of autodisposition optimises shelf utilisation and capital commitment

Revision

  • Irregularities are automatically displayed or detected


turn your data into value.

At a glance

  • Central, digital platform brings together three years of historical POS data
  • For the first time, receipt data can be analysed down to item level
  • Various departments from controlling and marketing to purchasing and auditing benefit from the findings.
Jens Kröhnert
turn your data into value

Let’s get started!

Would you also like to use your POS data to comprehensively optimise your business and gain a clear advantage over your competitors?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Mobile providers: How to inspire your customers with tailor-made offers

At a glance

  • Digital “Interaction Advisor” supports staff in sales talks
  • System automatically delivers action guidelines and individual product suggestions
  • Tailor-made offers inspire customers and optimise contribution margins

The business situation of our client

Mobile phone providers are faced with a dichotomy: on the one hand, individual contracts must generate the highest possible contribution margin. On the other hand, it is important to inspire consumers with tailor-made offers and to retain them in the long term. The example of one of our clients shows how these seemingly contradictory requirements can be effectively combined with the targeted use of data. Using Microsoft technologies, we have built a system that automatically defines offers based on comprehensive customer and tariff information, from which both the company and its customers benefit equally.

The solution for our client

Our solution is a so-called Interaction Advisor in the contact mask of the company-wide CRM. It provides the hotline and shop agents in direct customer contact with all important information about the respective purchase history and the current contract value. At the same time, the salesperson receives a guide to action as well as a selection of individual product and solution proposals with exact contribution margin forecasts. The system makes use of hundreds of predefined tariff and option combinations. Likewise, possible negotiation margins as well as the agent’s reward for successful contract conclusions or extensions are taken into account.

How data turns into new values

The information provided enables the salesperson to advise the customer much better and to respond to his or her individual needs with tailor-made offers. The customer feels personally addressed and in good hands with the provider. Thus, the new system contributes to higher customer satisfaction and customer loyalty. At the same time, the solution makes an effective contribution to churn management. And finally, the company benefits from optimised contribution margins.


turn your data into value.

At a glance

  • Digital “Interaction Advisor” supports staff in sales talks
  • System automatically delivers action guidelines and individual product suggestions
  • Tailor-made offers inspire customers and optimise contribution margins
Jens Kröhnert
turn your data into value

Let’s get started!

Would you also like to inspire your customers with tailor-made offers from which you as a company derive the greatest possible benefit?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Publisher increases circulation with data-driven forecasts

At a glance

  • Forecast model reliably predicts campaign success at every campaign level
  • Relevant key figures can be controlled in a targeted manner
  • Circulation figures and sales are sustainably increased

The business situation of our client

The digital transformation is not always a danger for publishers – it also opens up many opportunities. Because well-maintained databases can be converted into completely new values for the business with modern analysis platforms. For example, we have set up a data-driven forecasts for a large publishing house that reliably determines industry-relevant key figures – such as shelf life, conversion rates or circulation – for each stage of a sales campaign. Normally, this is only done retrospectively at defined points in time. Thus, the results of campaigns are often only available after several months. So there is hardly any possibility to specifically influence the success of ongoing campaigns.

The solution for our client

Our forecasting model combines existing order, customer and campaign data in each campaign phase in different ways and enriches them with additional information. Already in the planning stage of a campaign, initial statements can be made about response rates, conversion behaviour and resulting print runs on the basis of offers, advertising media, premium information and seasonal factors. These findings are refined with each subsequent campaign stage. For example, general information about the customers, such as geographic data or special interests, is added during address selection. Finally, with the start of the campaign, specific customer behaviour can be included, such as digital usage behaviour, payment information or interaction with customer service. The model thus continuously adapts its predictions to current developments.

How data turns into new values

With the data-driven forecasts, our client can reliably predict the success of its campaigns at any time based on significant key figures. This opens up the possibility of intervening if necessary and readjusting the measures – with corresponding positive effects on the relevant key figures or the specific conditions. Furthermore, short- and medium-term revenue forecasts, cash flow expectations and forecasts on terminations are possible. And what is decisive: for the first time, long-term goals, such as the improvement of conversion rates, shelf-life curves and payment rates, can be controlled in a targeted manner.


turn your data into value.

At a glance

  • Forecast model reliably predicts campaign success at every campaign level
  • Relevant key figures can be controlled in a targeted manner
  • Circulation figures and sales are sustainably increased
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to use your data to control and increase the success of your sales campaigns?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

How to sell more successfully with personality profiles

At a glance

  • Publisher uses data-based clusters to address customers
  • Advertising and offers are based on individual buying and contact behaviour
  • Solution boosts sales and subscription growth

The business situation of our client

From your own experience as a customer, you certainly know this: you constantly receive advertising that does not interest you. Most of the time it’s about the wrong products. Sometimes it is simply the wrong time. In any case, your current needs are not reflected in it. But from the advertiser’s point of view, you also know where the problem lies. Nowadays, customer wishes are very diverse and dynamic, making it difficult to address them individually with familiar methods. Classic segmentation according to socio-demographic criteria or sinus milieus simply no longer work.

So how do you define the right measures? What is the right approach? Answers to these questions are provided by your data on the purchasing and contact activities of your customers. On this basis, we have developed real personality profiles for a publishing house, which enable precisely fitting advertising messages. The initial questions were:

  • What do my target groups or typical personas actually look like?
  • What do these personas really want? What are their preferences and wishes?
  • How can I better understand my target groups?

The solution for our client

In principle, the personality profiles enable a 360° view of the respective customer. In concrete terms:

  • The real purchase and contact behaviour becomes transparent
  • Influencing factors for purchase decisions can be identified
  • Customer flows between different groups and products become visible
  • New groups with new preferences can be formed

To achieve this objective, we proceeded with our client’s data in the following way:

  1. Data review: We conducted an audit with available data and assessed its quality. For this purpose, we defined the effort required for any data procurement.
  2. Data preparation: We harmonised and weighted the data. Absolute key figures were translated into trend key figures.
  3. Data supplementation: We examined the potential of external data enrichment and filled data gaps.
  4. Grouping: We described individual clusters and defined their significant depth.
  5. Model use: We derived customer/product paths within the clusters and developed next-best-offer forecasts and goodness-of-fit tests of overall forecasts.

How data turns into new values

The different behaviors of the groups enable individual advertising messages that are directly oriented to the customers preferences. Our publishing client benefits from a significant gain in confidence and image as well as noticeably higher sales. At the same time, wastage is avoided: Advertising expenses decrease, while the success of the measures increases.

Qualitative benefits at a glance:

  • Customers are addressed at the right time with the right message via the right channel.
  • Offers can be customised – from product development and sales to operations and after-sales
  • Changes in customers/products are continuously incorporated into the clustering process.
  • Customer flows between clusters can be controlled
  • Transparent demand clusters are the basis of customer dialogue – the customer feels “picked up” at any time
  • The clusters support data-based campaign management with a high success rate or conversion rate.

Quantitative benefits at a glance:

  • Less wastage in marketing measures
  • Lower “cost per order
  • Significant increase in success with multi-stage campaigns: with four stages with a sales funnel of 25% on average, an increase of 5% each leads to a doubling of the result
  • Increase in subscription retention

For our publishing client this means in concrete terms

  • 8-fold higher response rate
  • 4-fold higher conversion on action chains
  • 30% increase in turnover
  • Subscription growth of 24


turn your data into value.

At a glance

  • Publisher uses data-based clusters to address customers
  • Advertising and offers are based on individual buying and contact behaviour
  • Solution boosts sales and subscription growth
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to use your data to increase your sales with precisely tailored advertising, to retain existing customers and to acquire new ones?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Shopping Portal improves its financial reporting with Power BI

At a glance

  • Financial reporting is automated through the use of Power BI
  • Even inexperienced users can work with data and create new value for the business
  • Collaboration platform enables company-wide dissemination of insights gained

The business situation of our client

Being “online” is no longer a competitive advantage. Shopping portals are also facing ever-increasing competitive pressure, which demands ongoing optimisation and quick decisions based on data. This was also evident at a well-known German supplier of branded goods. Until the time of our cooperation, the company’s financial reporting was exclusively created manually and sent by email. Likewise, there were no adequate tools for ad-hoc analyses of acute business issues. Finally, due to a massive backlog of requirements in the company’s own Data Warehouse, many important key figures were not available. Thus, there was an urgent need for a modern solution that would enable the finance department to use the existing data efficiently and flexibly.

The solution for our client

With the help of Power BI – Microsoft’s leading self-service service in the Azure cloud – we were able to quickly set up our own analysis solution for the department. For this, the data from the various sources was imported and merged into an updatable data model that depicts all relevant financial ratios for managing the company. Based on this, standard reports and dashboards can be provided automatically. Power BI also offers business users a wide range of options for carrying out ad-hoc analyses according to their own ideas. Alternatively, the more familiar Microsoft Excel is also available as a tool. In addition, we have established a company-wide collaboration platform in the cloud via the Power BI portal, which also gives other groups of people and areas in the company access to the department’s analysis results.

How data turns into new values

Thanks to the simple data model and the self-service tools used, even inexperienced users can work independently with data to create meaningful reports, dashboards and ad-hoc analyses. Last but not least, the complementary use of Excel ensures high user acceptance. Due to the free access via the collaboration platform, other company departments also benefit from the insights gained. Management and specialist departments can even access all important information on a mobile basis at any time. In addition, key figures can be realised or expanded much faster, so that the reporting of the finance department forms a much more valid basis for decision-making.

However, such isolated analysis solutions only give companies short-term breathing space in the digital race. In the medium to long term, these so-called data silos lead to a proliferation of reports and the loss of uniform key figures. The next step is to expand the existing DWH into a digital platform in the cloud that unites all company divisions and their data. Power BI not only offers the best prerequisites for this approach. The service is harmoniously integrated into the diverse eco-system of Azure Cloud Services. Accordingly, it can be expanded as needed into a modern DWH that serves every conceivable scenario of contemporary data evaluation, from forecast scenarios to digital products.


turn your data into value.

At a glance

  • Financial reporting is automated through the use of Power BI
  • Even inexperienced users can work with data and create new value for the business
  • Collaboration platform enables company-wide dissemination of insights gained
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to modernise your data analysis with Power BI and create sustainable competitive advantages?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

How a baker uses data to reduce returns from branches and increase sales

At a glance

  • Digital platform makes all data from operational business available for the first time
  • Real-time analyses enable fast and flexible reactions in day-to-day business
  • Customer satisfaction and sales increase while the return rate decreases

The business situation of our client

The efficient use of data offers bakery chains the opportunity to improve their business processes and service to the consumer in many ways. This is illustrated by the example of a medium-sized bakery business that is one of our clients. The company has set itself the goal of having a complete and fresh range of goods available at all times of the day in its 30 or so branches. At the same time, the return rate should be as low as possible.

In order to ensure the ongoing balancing act between an oversupply and an undersupply of the individual branches, enormous amounts of data are available, for example from checkout processes and logistics. However, our client lacked:

  • a central platform to bring all the data together and enable consistent reports and insights across all business units
  • suitable tools that enable users from the specialist departments to carry out their own targeted analyses
  • Real-time data that allows fast and flexible reactions in day-to-day business.

The solution for our client

To enable our client to effectively transform its data into value for its business, we first built a central database based on Microsoft technologies. Here, all data from the operative business is processed and merged almost in real time. This includes not only receipt and delivery data, but also information on stocks, returns, orders, production, personnel, energy consumption and the weather. The bottom line is that the entire process from production to sales is mapped.

All company departments – whether sales, controlling, production or office work – have access to this integrated data platform. For evaluation, the various user groups have access to suitable analysis tools, such as Power BI, Excel or Reporting Services. In this way, all employees can carry out individual ad-hoc-analyses on the desired data quickly and easily. Standard reports on the relevant key figures are delivered automatically. We have optimised the design of the reporting system with a uniform information design according to IBCS specifications.

How data turns into new values

Through the ongoing analysis of daily updated sales data, our client has achieved its goals:

  • Staff can identify any bottlenecks or surpluses at an early stage
  • Missing goods can be delivered or transferred immediately.
  • Consumers can choose from the full range of products at any time and in any shop
  • Customers are more satisfied and can be retained for longer periods of time
  • Sales potential is optimally unlocked, so that turnover increases
  • The returns rate has been noticeably reduced

In addition, the company benefits from fraud analyses that effectively uncover irregularities in the checkout systems. Last but not least, the diverse analysis options of sales data, buying behaviour, shop development as well as production and delivery quantities provide different departments with a much more well-founded basis for planning. In the process, users no longer have to invest time in data procurement and preparation, as the relevant information is centrally available and easily accessible. Similarly, the automation of processes saves manual effort in many places.


turn your data into value.

At a glance

  • Digital platform makes all data from operational business available for the first time
  • Real-time analyses enable fast and flexible reactions in day-to-day business
  • Customer satisfaction and sales increase while the return rate decreases
Dirk Ohligschläger
turn your data into value

Let’s get started!

Do you also want to make better use of the potential in your data to unlock new value for your business, your customers and your employees?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Predictive maintenance: machine builder inspires customers with AI-based forecasts

At a glance

  • Packaging equipment manufacturer enhances its products with data-based services
  • AI-supported forecasts reliably predict machine downtimes and defects
  • Efficiency gains range from warehousing to overall productivity

The business situation of our client

In global competition, efficient production processes are a decisive factor for success. Against this backdrop, digitalisation offers manufacturers of machines and production lines many opportunities to inspire their customers with data-based services from the field of Artificial Intelligence (AI). For example, we implemented prognosis scenarios for predictive maintenance for a globally operating machine manufacturer, which significantly increase the efficiency of the manufactured plants.

The objective of our client was to:

  • Prevent machine downtimes
  • To exclude machine damage
  • Minimise downtimes
  • Identify typical malfunctions
  • Optimise maintenance intervals
  • Improve productivity

The solution for our client

The starting point for our data-based forecasting services is historical as well as current machine data. On this basis, a prognosis model is set up and continuously improved:

  1. We continuously collect the sensor data of the machines
  2. We supplement current measured values with quality-assured master data
  3. We generate diagnostic data on machine problems
  4. We train a machine learning model on the basis of the diagnostic data.
  5. We continuously compare our optimisation algorithms with real-time data.

How data turns into new values

By using our AI-based prognosis model, the machine operators can specifically prevent possible malfunctions and defects. The availability of the machines in operation has improved significantly as a result. But our customer also benefits from the optimisations at its customers: Testing costs and costly recall campaigns are avoided, and warranty costs are significantly reduced. At the same time, customer satisfaction and loyalty have increased.

The improvements for all involved in concrete figures:

  • Machine defects and failures are detected 75% proactively
  • Downtimes have been reduced by 50 to 80%.
  • Maintenance costs have been reduced by 50 to 80%
  • Warranty costs have been reduced by over 50%
  • Inventory costs reduced by 20 to 30%
  • Overtime costs reduced by 20 to 50%.
  • Overall productivity increased by 20 to 30%.


turn your data into value.

At a glance

  • Packaging equipment manufacturer enhances its products with data-based services
  • AI-supported forecasts reliably predict machine downtimes and defects
  • Efficiency gains range from warehousing to overall productivity
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to use your data to sustainably increase the efficiency of your products and to bind your customers with data-based services?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Digital transformation in heating technology: How to predict malfunctions and reduce consumption costs

At a glance

  • Cloud solution enables continuous monitoring of heating data
  • Forecast scenarios ensure more reliable operation and fewer failures
  • Intelligent heating control reduces costs for the consumer

The business situation of our client

An internationally leading manufacturer of heating systems demonstrates what is possible when data is used consistently. As direct customers of the manufacturer, heating engineers have always been able to act only reactively. System defects could only be detected when they occurred. And the necessary spare parts were usually not readily available, which meant a lot of work for the fitter and cold nights for the heating user.

Together with ORAYLIS, those responsible now wanted to tackle the digital transformation of the company and create new values on different levels through continuous monitoring of the extensive heating data. On the one hand, the objective was to enable the heating engineer to take anticipatory measures and optimise maintenance intervals. On the other hand, it was necessary to improve the settings of the heating system and to reduce consumption costs.

The solution for our client

The core of our solution is a flexibly scalable platform in the Microsoft Azure Cloud. A long-term hardware solution in the company’s own data centre would hardly have been calculable due to the high data volume. On the cloud platform, the continuous stream of operating, configuration and status data of the heating systems is collected and compared with existing system data. The findings are first displayed in a real-time dashboard so that the manufacturer can immediately detect irregularities and proactively intervene. At the same time, typical consumption patterns are identified, such as for the use of hot water or the heating system as such. On this basis, activity and rest phases of the systems can be intelligently controlled. Last but not least, we train forecast models with the current and historical data. These not only make increasingly reliable statements about the expected consumption. Likewise, forecasts on malfunctions and individual wear parts, including recommendations for action, are automatically delivered to the service technician’s mobile phone.

How data turns into value

Everyone involved benefits from the many possibilities opened up by our cloud solution:

Consumers

  • The data-based, automated control of the systems saves up to 20 percent in costs.
  • Continuous monitoring of the heating data ensures reliable system operation

Installer

  • Positioning as a modern service provider that ensures smooth operation
  • Massive savings in time and effort through intelligent supply chains

Manufacturer

  • Positioning as a technological innovation driver and industry pioneer in the heating business
  • Installers and consumers increasingly opt for the manufacturer’s products and remain loyal to them


turn your data into value.

At a glance

  • Cloud solution enables continuous monitoring of heating data
  • Forecast scenarios ensure more reliable operation and fewer failures
  • Intelligent heating control reduces costs for the consumer
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to seize the opportunities of digitalisation and stand out from your competitors with data-driven services?

Join #teamoraylispeople

Shape the world
of data with us

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