BI & Data Analytics Archive - Page 2 of 3

At a glance

Digital platform in the Microsoft Azure Cloud provides mass data centrally
Cross-divisional analyses enable diverse synergies for the business
New requirements can be implemented quickly and effectively

The business situation of our client

One of the fundamental obstacles in the digitalisation of companies is that each specialist department only works in isolation on its own data files. One of our customers from the energy sector also had to realise this. The provider wanted to finally unlock the potential in its data and achieve valid insights across the company.

The obstacles at a glance:

Employees could not work with data across disciplines, so potential synergies remained unused
Without a “single point of truth”, divergent key figures and results were circulating in the company.
New applications and innovations could not be implemented due to the lack of a uniform, consolidated database.
Resources were unnecessarily tied up within the departments for the operation of their own, small data solutions.

Consequently, our client’s objective was:

Consolidate all regions and divisions
To take over all existing use cases and data
To store and process structured and unstructured data
To enable the solution to be operated by the company’s own IT department.
To implement the technological basis within three months

The solution for our client

The basis of our solution is a digital platform that we built quickly and efficiently using Microsoft Azure Cloud services. This not only enabled us to meet the tight schedule. Rather, our customer has the possibility to use storage and computing capacities according to their current needs.

All company data is now united on the central platform and made available for the most diverse application scenarios:

We store data on customer contracts, prices and smart metering in a data lake.
The local ERP is connected to the platform and also makes its data available via the cloud.
Data from the hydropower sector is visualised directly in real-time dashboards.
We also make the data from the wind power sector available to the specialist departments via a real-time route

Microsoft’s leading analysis service Power BI serves as a front-end tool for the presentation of the information as well as free analyses by the specialist departments.

How data turns into new values

With the cloud platform, our client has created the ideal conditions for its digital transformation from a technological point of view. Users from all areas can now finally evaluate data in a combined way to unlock new values and synergies for the company.

Some examples:

Customer management: cross-divisional analyses provide new insights and enable the construction of forecasting models.
Finance: For the first time, users can carry out independent reporting and make it accessible to other company divisions.
Hydropower: Real-time dashboards can be published via a collaboration platform and made available for collaborative editing.
Wind power: Users can carry out free analyses on real-time data and combine them with other sources.

There is also the technical benefit:

IT can offer business departments an integrated platform for all use cases.
Development processes can be made agile
All departments can start new application projects within minutes.
Data scientists can carry out analyses in isolated environments without burdening the platform or users.

turn your data into value.

At a glance

Digital platform in the Microsoft Azure Cloud provides mass data centrally
Cross-divisional analyses enable diverse synergies for the business
New requirements can be implemented quickly and effectively

turn your data into value

Let’s get started!

Do you also want to equip yourself for the digitalisation of your company and tap into the diverse values in your data with a central platform?

Contact Jens Kröhnert

Further customer successes

Quarry 4.0 – Fabric passes the IoT test at Basalt

Microsoft Fabric celebrates its first practical successes. At Basalt AG, the innovative cloud platform is now enabling the business utilisation of machine data. Find out …

Digital services support car park owners and car park users

In almost every industry, business intelligence (BI) systems offer the possibility of using data to develop new values for one’s own business and the customer. A leading …

How to sell more successfully with personality profiles

You certainly know this from your own experience as a customer: you constantly receive advertising that does not interest you. But from the advertiser’s point of view, you …

How mobile providers can predict the value of new contracts

Evaluating sales performance has always been a special challenge for mobile phone providers: normally, the revenues and contribution margins from new contracts and contract …

Data-based churn model maps customer behaviour in the future
Potential churn candidates are automatically recognised
Model optimises itself independently through artificial intelligence and machine learning

The business situation of our client

The market for energy suppliers is characterised by a similar level of performance and quality of the suppliers as well as very low switching barriers for consumers. The willingness to change suppliers is correspondingly high. Companies react to this decreasing customer loyalty with so-called churn management, whereby “churn” is an artificial term made up of “change” and “turn”. In other words, it is about measures that prevent customer churn.

The comprehensive use of data can considerably increase success while reducing costs. This is illustrated by the example of one of our clients. At an early stage, we set up a learning churn model for the now established market entrant that not only reliably identifies potential churn candidates. At the same time, it ensures that the customers who fit the products are addressed.

The solution for our client

The model thrives on the linking of diverse sources and variables on a modern, digital platform. The goal is to represent each customer as accurately as possible. For example, existing customer feedback from the call centre and from marketing campaigns flows into the model. The respective consumption data is also included, as an unsuitable tariff can also cause dissatisfaction. In addition, information on the profitability of the contract is included. All this data is compared with price comparison portals – i.e. are there competing tariffs that could be more interesting for the customer? And: How does the company actually compare to the competition in individual tariff segments?

Further information is provided by campaigns such as “Customers recruit customers”. Because active “recruiters” are considered relatively safe. The same applies to those who have been recruited. On the other hand, if such opinion leaders leave, the danger increases that other customers will follow suit. Last but not least, external sources are taken into account, such as population density and market penetration in certain postcode areas. For example, in regions with low population density and penetration, customers migrate more quickly through the recommendations of neighbours.

How data turns into new values

On this basis, the churn model independently provides a timely warning for each profitable customer with potential switching intentions. Accordingly, the provider can take targeted – and usually successful – countermeasures with individually tailored marketing measures.

The special feature of the model is that it continuously optimises itself through Artificial Intelligence and Machine Learning functions and adapts to changing conditions. The starting point is the existing data from contract renewals and contract terminations. This “learning material” is continuously searched for regularities and patterns. Over time, relevant variables emerges, such as dissatisfaction with prices or certain services. The ideal time to approach the change candidate can also be determined in this way.

turn your data into value.

Artificial Intelligence Big Data Engineering Azure

At a glance

Data-based churn model maps customer behaviour in the future
Potential churn candidates are automatically recognised
Model optimises itself independently through artificial intelligence and machine learning

turn your data into value

Let’s get started!

Would you also like to use your data to inspire your customers and retain them in the long term?

Contact Jens Kröhnert

Further customer successes

Quarry 4.0 – Fabric passes the IoT test at Basalt

Microsoft Fabric celebrates its first practical successes. At Basalt AG, the innovative cloud platform is now enabling the business utilisation of machine data. Find out …

How BD Rowa reduces the downtimes of order picking systems

Becton Dickinson Rowa Germany GmbH (BD Rowa) is one of the world’s leading manufacturers of order picking systems for pharmacies, hospitals and pharmaceutical wholesalers. …

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

An internationally leading manufacturer of heating systems demonstrates what is possible when data is used consistently. Together with ORAYLIS, the company wanted to tackle …

Information design training and a company-wide style guide optimise reporting
Standardised reporting elements increase readability and information flow
Clear presentation of information allows for more reliable decisions

The business situation of our client

The management of a leading German seaport was dissatisfied with its reporting: the different business units all worked with different analysis solutions, so that a proliferation of different reports and dashboards circulated in the company. Documents from one department were therefore difficult for the other to understand. In addition, there were often inaccurate figures and superfluous content.

Reason enough to use the introduction of a new SAP system to standardize the entire reporting system. The presentation of maps, which are important for port management, was also to be included. The objective was to sustainably improve the flow of information in the company and thus enable faster and more reliable decision-making.

The solution for our client

Against this background, one of our information design experts first trained the port management staff in the use of data visualization standards in reporting. Afterwards, joint workshops took place in which an individual notation concept was developed for the company according to IBCS specifications. In addition, selected reports and dashboards were analyzed and optimized. Finally, we jointly created a company style guide with templates for all important use cases, such as tables, charts and maps.

How data turns into new values

The relevant business figures are now presented much more accurately and provide decision-makers with a much more precise basis for their planning. At the same time, the information contained is much easier to read, so that the speed of decision-making processes is also increased. Last but not least, the use of standardised elements throughout the company makes it easier for departments to tap into the insights of other departments.

turn your data into value.

BI & Data Analytics

At a glance

Information design training and a company-wide style guide optimise reporting
Standardised reporting elements increase readability and information flow
Clear presentation of information allows for more reliable decisions

turn your data into value

Let’s get started!

Would you also like to make your business more successful with faster and better decisions?

Contact Jens Kröhnert

Further customer successes

Quarry 4.0 – Fabric passes the IoT test at Basalt

Microsoft Fabric celebrates its first practical successes. At Basalt AG, the innovative cloud platform is now enabling the business utilisation of machine data. Find out …

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

In retail, the analysis of cash register receipts can be a source for a variety of business improvements. However, not all receipt data analysis is the same, as the example …

Retail: How data can optimise business with perishable goods

The right use of data can improve processes at every point in your business and lead to considerable savings in time and money. Example retail: For a European market …

How to make your production more efficient with real-time data

Production processes have to be as efficient as possible for companies to survive in global competition. This was also recognised by one of our industrial customers, a …

Manufacturer of special pumps monitors its entire production in real time
Companies, customers and employees benefit from more transparency and improved processes
Solution connects local SAP ERP with services in the Azure Cloud

The business situation of our client

Production processes must be as efficient as possible in order for companies to survive in global competition. This was also recognised by one of our industrial customers, a global leader in the manufacture of special pumps. Together, we implemented a monitoring system based on real-time data for its entire production line and achieved a large number of improvements as a result. Because: Up until this point, neither the production status nor the progress of an order could be tracked. The finished goods usually reached the shipping department without notice.

The solution for our client

Our customer’s production process involves pushing the picked individual parts of a pump from one production cell to the next on a transport trolley. In our solution, each trolley receives its own RFID tag, which is linked to the relevant order. The individual manufacturing cells are equipped with corresponding RFID gates. We process the resulting data stream via a real-time route based on services from the Microsoft Azure cloud: An Azure Event Hub receives the data and distributes it further. The data is then analysed in real time via Azure Stream Analytics. We have also connected a local SAP ERP with quality-assured reference data. Only by linking it to the SAP data do the findings from the real-time information gain concrete significance. Finally, the data is visualised via a real-time monitoring dashboard in Power BI.

How data turns into new values

The data-driven real-time monitoring generates new values for our customer on very different levels. The status quo of each individual pump can now be precisely tracked. Likewise, those responsible can obtain an overview of all current orders in real time. As a result, the various production steps can be coordinated much more precisely. For example, the efficiency of the employees in the production cells has increased significantly, as they are now informed about upcoming orders at an early stage. And of course, the company’s customers are also much more satisfied: they receive much more precise information about the status and delivery date of their goods.

turn your data into value.

Artificial Intelligence Azure Power BI

At a glance

Manufacturer of special pumps monitors its entire production in real time
Companies, customers and employees benefit from more transparency and improved processes
Solution connects local SAP ERP with services in the Azure Cloud

turn your data into value

Let’s get started!

Would you like to analyse your data in real-time to make business and production processes more effective and customer-friendly?

Contact Jens Kröhnert

Further customer successes

Quarry 4.0 – Fabric passes the IoT test at Basalt

Microsoft Fabric celebrates its first practical successes. At Basalt AG, the innovative cloud platform is now enabling the business utilisation of machine data. Find out …

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

In global competition, efficient production processes are a decisive factor for success. Against this backdrop, digitalisation offers manufacturers of machines and …

How innogy is preparing for the future with a digital platform

In many companies, long-standing analytics systems are increasingly reaching their limits. They can no longer cope with the constantly growing number of users and data – …

Retail business: How to optimise your advertising expenses

“I know half of my advertising is money thrown away. I just don’t know which half.” – The much-quoted wisdom of Henry Ford has lost none of its relevance for the trade. On …

A simple forecasting model makes the success expectations of new contracts and contract extensions transparent
Deviations from actual results amount to a maximum of two percent
The success of new products and cannibalisation effects can also be recognised at an early stage.

The business situation of our client

Assessing sales performance has always been a special challenge for mobile providers: usually, the revenues and contribution margins from new contracts and contract extensions can only be precisely quantified after a few months. Concrete sales figures for upcoming contract periods are difficult to estimate simply because customers often change their tariff or take advantage of supplementary options during this period. At the same time, sales successes are often incorrectly estimated and rewarded.

Therefore, one of our clients, a leading mobile phone provider in Germany, wanted more transparency and planning security. With relatively simple means, we developed a predictive model that reliably predicts the desired figures.

The solution for our client

The provider has an extensive data pool on the usage behaviour and thus the contribution margins of its customers. However, it is not that easy to predict these figures, as behaviour tends to be variable at the beginning of the contract and only stabilises after a few months. In addition, there are also differences between the customers, depending on the respective region and the sales channel.

We used this diverse detailed data to build our forecast model. A relatively simple technical set-up was sufficient for this. The entire solution is based on an already existing Microsoft SQL Server as well as the Analysis and Reporting Services. In essence, the model applies average calculations to similar customer data and then outputs a corresponding contribution margin.

How data turns into new values

Despite its simple structure, the forecasting process delivers very accurate estimates of future sales directly when a contract is signed. Likewise, the sales performance can be evaluated in a stable manner already on the following day. The deviations from the actual results amount to a maximum of two percent. This also allows our client to recognise the success or failure of new products at an early stage and make immediate adjustments. In addition, cannibalisation effects across different sales channels can be identified very quickly.

turn your data into value.

BI & Data Analytics Artificial Intelligence

At a glance

A simple forecasting model makes the success expectations of new contracts and contract extensions transparent
Deviations from actual results amount to a maximum of two percent
The success of new products and cannibalisation effects can also be recognised at an early stage.

turn your data into value

Let’s get started!

Would you also like to use your data to optimise your business and unlock new value?

Contact Jens Kröhnert

Further customer successes

Quarry 4.0 – Fabric passes the IoT test at Basalt

Microsoft Fabric celebrates its first practical successes. At Basalt AG, the innovative cloud platform is now enabling the business utilisation of machine data. Find out …

How innogy is preparing for the future with a digital platform

In many companies, long-standing analytics systems are increasingly reaching their limits. They can no longer cope with the constantly growing number of users and data – …

Retail business: How to optimise your advertising expenses

“I know half of my advertising is money thrown away. I just don’t know which half.” – The much-quoted wisdom of Henry Ford has lost none of its relevance for the trade. On …

Blum Group: Effective organizational structures for successful digitalization

Anyone who owns IKEA furniture is also familiar with the products of the Blum Group. Now in its third generation, the family-owned company from Vorarlberg, Austria, …

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:

Formation of a BI Competence Centre in Controlling
Data modelling: We network all data on the platform in maximum detail. The flexible data model enables rapid adaptation to market changes.
Data integration: All departments and their data are integrated step by step.
Near-real-time: Based on a Lambda architecture, we enable the processing of real-time data in all required processes.
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.
Ad-hoc analysis: Business users have the option of carrying out free analyses in the data rooms provided.
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.

BI & Data Analytics Power BI Data Strategy

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

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?

Contact Jens Kröhnert

Further customer successes

Quarry 4.0 – Fabric passes the IoT test at Basalt

Microsoft Fabric celebrates its first practical successes. At Basalt AG, the innovative cloud platform is now enabling the business utilisation of machine data. Find out …

How BD Rowa reduces the downtimes of order picking systems

Becton Dickinson Rowa Germany GmbH (BD Rowa) is one of the world’s leading manufacturers of order picking systems for pharmacies, hospitals and pharmaceutical wholesalers. …

How an energy supplier prevents customer churn

The market for energy suppliers is characterised by a similar level of performance and quality of the suppliers as well as very low switching barriers for consumers. Learn …

Retail: How data can optimise business with perishable goods

The right use of data can improve processes at every point in your business and lead to considerable savings in time and money. Example retail: For a European market …

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.

Project Management BI & Data Analytics

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

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?

Contact Daniel Esser

Further customer successes

Quarry 4.0 – Fabric passes the IoT test at Basalt

Microsoft Fabric celebrates its first practical successes. At Basalt AG, the innovative cloud platform is now enabling the business utilisation of machine data. Find out …

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

In retail, the analysis of cash register receipts can be a source for a variety of business improvements. However, not all receipt data analysis is the same, as the example …

WMF upgrades commercial coffee machines with real-time services

Real-time analysis of machine data enables very different digital innovations. For our customer WMF we have expanded the company’s product range with data-driven …

Shopping Portal improves its financial reporting with Power BI

Being “online” is no longer a competitive advantage. Shopping portals are also facing ever-increasing competitive pressure, which demands ongoing optimisation and quick …

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.

Artificial Intelligence BI & Data Analytics

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

turn your data into value

Let’s get started!

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

Contact Jens Kröhnert

Further customer successes

Quarry 4.0 – Fabric passes the IoT test at Basalt

Microsoft Fabric celebrates its first practical successes. At Basalt AG, the innovative cloud platform is now enabling the business utilisation of machine data. Find out …

How to make your production more efficient with real-time data

Production processes have to be as efficient as possible for companies to survive in global competition. This was also recognised by one of our industrial customers, a …

WMF upgrades commercial coffee machines with real-time services

Real-time analysis of machine data enables very different digital innovations. For our customer WMF we have expanded the company’s product range with data-driven …

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

An internationally leading manufacturer of heating systems demonstrates what is possible when data is used consistently. Together with ORAYLIS, the company wanted to tackle …

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.

BI & Data Analytics Project Management Big Data Engineering

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.

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?

Contact Jens Kröhnert

Further customer successes

Quarry 4.0 – Fabric passes the IoT test at Basalt

Microsoft Fabric celebrates its first practical successes. At Basalt AG, the innovative cloud platform is now enabling the business utilisation of machine data. Find out …

Shopping Portal improves its financial reporting with Power BI

Being “online” is no longer a competitive advantage. Shopping portals are also facing ever-increasing competitive pressure, which demands ongoing optimisation and quick …

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

The efficient use of data offers bakery chains the opportunity to improve their business processes and consumer service in many ways. This is illustrated by the example of …

Retail business: How to optimise your advertising expenses

“I know half of my advertising is money thrown away. I just don’t know which half.” – The much-quoted wisdom of Henry Ford has lost none of its relevance for the trade. On …

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.

Big Data Engineering Data Strategy Artificial Intelligence

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

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?

Contact Jens Kröhnert

Further customer successes

Quarry 4.0 – Fabric passes the IoT test at Basalt

Microsoft Fabric celebrates its first practical successes. At Basalt AG, the innovative cloud platform is now enabling the business utilisation of machine data. Find out …

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

In global competition, efficient production processes are a decisive factor for success. Against this backdrop, digitalisation offers manufacturers of machines and …

How an energy supplier prevents customer churn

The market for energy suppliers is characterised by a similar level of performance and quality of the suppliers as well as very low switching barriers for consumers. Learn …

How o2 improves its social media marketing performance

Whether B2B or B2C – social media and content marketing have become important tools for companies in image building and sales. But do the measures really bring the desired …

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.

Artificial Intelligence BI & Data Analytics

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

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?

Contact Jens Kröhnert

Further customer successes

Quarry 4.0 – Fabric passes the IoT test at Basalt

Microsoft Fabric celebrates its first practical successes. At Basalt AG, the innovative cloud platform is now enabling the business utilisation of machine data. Find out …

How data visualisation standards enable faster and better decisions

The management of a leading German seaport was dissatisfied with its reporting: the different business units all worked with different analysis solutions, so that a …

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

An internationally leading manufacturer of heating systems demonstrates what is possible when data is used consistently. Together with ORAYLIS, the company wanted to tackle …

Retail business: How to optimise your advertising expenses

“I know half of my advertising is money thrown away. I just don’t know which half.” – The much-quoted wisdom of Henry Ford has lost none of its relevance for the trade. On …

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:

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.
Data preparation: We harmonised and weighted the data. Absolute key figures were translated into trend key figures.
Data supplementation: We examined the potential of external data enrichment and filled data gaps.
Grouping: We described individual clusters and defined their significant depth.
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.

BI & Data Analytics

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

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?

Contact Jens Kröhnert

Customer success

Energy giant manages digital transformation with a cloud platform

At a glance

The business situation of our client

The solution for our client

How data turns into new values

At a glance

turn your data into value

Let’s get started!

Further customer successes

Join #teamoraylispeople

Shape the world of data with us

Customer success

How an energy supplier prevents customer churn

At a glance

The business situation of our client

The solution for our client

How data turns into new values

At a glance

turn your data into value

Let’s get started!

Further customer successes

Join #teamoraylispeople

Shape the world of data with us

Customer success

How data visualization standards enable faster and better decisions

At a glance

The business situation of our client

The solution for our client

How data turns into new values

At a glance

turn your data into value

Let’s get started!

Further customer successes

Join #teamoraylispeople

Shape the world of data with us

Customer success

How to make your production more efficient with real-time data

At a glance

The business situation of our client

The solution for our client

How data turns into new values

At a glance

turn your data into value

Let’s get started!

Further customer successes

Join #teamoraylispeople

Shape the world of data with us

Customer success

How mobile providers can predict the value of new contracts

At a glance

The business situation of our client

The solution for our client

How data turns into new values

At a glance

turn your data into value

Let’s get started!

Further customer successes

Join #teamoraylispeople

Shape the world of data with us

Customer success

Digital platform gives mobile provider a competitive edge

At a glance

The business situation of our client

The solution for our client

How data turns into new values

At a glance

turn your data into value

Let’s get started!

Further customer successes

Join #teamoraylispeople

Shape the world of data with us

Customer success

Digital services support car park owners and car park users

At a glance

The business situation of our client

The solution for our client

How data turns into new values

At a glance

Shape the world
of data with us

Shape the world
of data with us

Shape the world
of data with us

Shape the world
of data with us

Shape the world
of data with us

Shape the world
of data with us