Customer success

Quarry 4.0 – Fabric passes the IoT test at Basalt

Heiko Bornemann
Head of IT Infrastructure, Basalt AG

We are truly impressed with how quickly we were able to achieve the desired results within our joint Fabric PoC. In the end, the results in fact exceeded our expectations. Thanks to our new data platform, we are now perfectly prepared to gradually guide our company towards Industry 4.0. With their extensive data expertise, our consultants from ORAYLIS were the missing piece of the puzzle for us to successfully implement a project of this kind.

At a glance

  • Client: Basalt AG
  • Industry: Building Industry
  • Project objective: Implementing a cloud platform with Microsoft Fabric for the business use of IoT data
  • Technologies: Microsoft Fabric

Basalt AG’s products are quite literally fundamental to our society’s mobility. A significant share of the asphalt on German roads originates from the company’s quarries and production sites. The same applies to the track ballast that provides the basis for our railroads. Basalt covers the entire supply chain from raw material extraction to provision at the point of use, as well as recycling and disposal.

Asphalt-Maschine aus der Vogelperspektive

A considerable share of the asphalt laid in Germany originates from Basalt plants. (Basalt AG)

As a result, sustainability-related topics play a major role at Basalt. At the same time, they are also posing the greatest challenge: It is not only about meeting the continually growing demands of the government and the public. Sustainability is in fact a key factor in production within the natural stone sector and is therefore one of the most important business objectives. Improvements in this area always can potentially create a competitive edge for the company in economic terms as well. However, how do we manage to further promote sustainable actions in this day and age?

Those in charge at Basalt already have the answer to that question: “We simply have to make use of the wide range of data resources available to us across the entire supply chain,” says Heiko Bornemann, Head of IT infrastructure. “Currently, this treasure trove of data is scattered across almost 300 locations in Germany, buried within various systems and data silos.” This is why the company has decided to launch a large-scale digitalization initiative aiming at centralized data that can be made available for various types of application scenarios across the company.

Digitalization = Industry 4.0

At Basalt AG, digitalization means a commitment to the implementation of Industry 4.0 and its very foundation, the Internet of Things (IoT). This is because, until now, the extensive data streams from large stone crushers, for example data on capacity utilization and productivity, have not yet generated any business value. Heiko Bornemann explains: “In the future, we want to combine the sensor data from all plants in an Operational Data Management System and then link it to the rest of our company data. Of course, the data should then be made available for business applications in real time if possible.”

Zwei Basalt-Mitarbeiter im Steinbruch

The extensive data streams at the Basalt quarries have not yet generated any business value until now. (Basalt AG)

Basalt is not only hoping for better decision-making and a number of new insights. The company also intends to use the Operational Data Management System to further interconnect people and machines as well as to digitalize and automate processes. Heiko Bornemann underscores that Basalt is not only focused on sustainability targets: “We are also facing site-specific challenges such as the generational change and a shortage of skilled labor. We consider automated processes to be a lever, helping us to break down knowledge silos and to deploy our valuable staff in a more efficient manner.”

With these requirements in mind, Basalt started its search for a suitable data technology and the right partner to implement it. One thing was unnegotiable from the beginning: It has to be a Microsoft solution because the existing systems are already running in the Azure Cloud.

Microsoft Fabric is the base technology

During their research, the team repeatedly came across Fabric – Microsoft’s brand-new technology approach that allows a complete data platform to be rolled out and ready to use at the touch of a button. “We had already attended a presentation in Munich,“ says Heiko Bornemann. “To us, it sounded like the ideal concept, since we are hoping for a high degree of autonomy and would like to do as many things ourselves as possible.” After an individual presentation by Microsoft, Basalt opted to trial Microsoft Fabric within a sponsored Proof of Concept (POC), as, although the technology is currently celebrating its first notable practical successes in many areas, it has so far only had limited opportunities to prove itself in Industry 4.0 scenarios.

When it came to choosing the ideal partner, ORAYLIS GmbH was able to impress Basalt by focusing on the essentials: “We had conversations with several service providers. Ultimately, to me, the decisive factor was the fact that the ORAYLIS consultants quickly grasped our use case and shared tangible ideas, instead of jumping straight to huge digital twin concepts. Additionally, ORAYLIS boasts proven Fabric expertise. Thanks to its early involvement in introducing and promoting the technology, Microsoft recently selected ORAYLIS as one of its few “Fabric Featured Partners” in Germany.

Real-time sources can be integrated smoothly

The basic objective of the PoC was to link plant data with standard business data for the first time and to visualize the results on a dashboard in near real time. This meant bringing together all key interest groups involved in company-wide digitalization. In addition to representatives from IT infrastructure, these included the “Central Technology” department, which is responsible for machine systems, and the “Industry Solutions” department, which is in charge of operational systems.

Fabric expert Dirk Ohligschläger was part of the project as solution architect. (ORAYLIS GmbH)

Dirk Ohligschläger, Senior Solution Architect at ORAYLIS, describes the next steps as follows: “We first set up our central platform using Fabric, which was very easy. It actually only takes a few steps to set up the entire architecture, including data integration, processing and the respective analysis tools.” Afterwards, the platform was linked to the four pilot plants. “The bridge between stone crusher and platform serves as an edge device. It receives the data streams from the plant sensors and feeds them directly into our cloud database. And just like that, we were able to see the first real numbers in Power BI after just a short time. The integration process was completely trouble-free.”

Our Fabric expert has only reported a few minor hitches along the way to the first real-time results at Basalt: “At one point, we exceeded our capacity limits, which led to Reporting being down for a few hours. However, that was simply a matter of configuration. Moving forward, we’ll know better. In my opinion, Fabric has clearly passed our IoT test.”

Expectations were in fact exceeded

Heiko Bornemann, too, is highly pleased with the PoC’s progress: “We are truly impressed with how quickly we were able to achieve the desired results. In the end, our expectations were in fact exceeded. It doesn’t stop with feeding data from the stone crusher to the dashboard via the cloud; ORAYLIS has already integrated filters for specific sites and set up a dashboard for individual figures.” At the same time, another business case was implemented; an energy monitoring system which critically analyzes the plants’ energy consumption. This system will also be a fixed part of the Operational Data Management System.

According to Heiko Bornemann, the teamwork between Basalt and ORAYLIS was one of the project’s main success factors: “It was a perfect match, especially since we lack the necessary expertise in data processing and the linking of new sources. The consultants at ORAYLIS don’t keep their expertise to themselves. The whole team has benefited from them sharing their knowledge. This is why it is safe to say that ORAYLIS was the missing piece of the puzzle for us to successfully implement a project of this kind.”

Driving digitalization with purpose

At the same time, the work of the dream team has already generated appetite for more among the company: “Our colleagues, especially those working on the Operational Data Management System, were already showing great enthusiasm before the PoC had even ended. They were keen to immediately get started on validating even more data and introducing further requirements. This was of course highly motivating for us. However, we have to make sure to not get carried away too quickly, because we are not working with a live system yet.”

To Heiko Bornemann, that means to pause for a moment and take stock: “I believe that by introducing the Fabric platform, we laid the ideal foundation for gradually digitalizing our company. We see huge potential, especially in terms of Predictive Maintenance and Alerting. We will analyze the PoC’s results precisely and then structurally integrate further data and approach new use cases. The course of action is now clearly defined.”

turn your data into value.

At a glance

  • Client: Basalt AG
  • Industry: Building Industry
  • Project objective: Implementing a cloud platform with Microsoft Fabric for the business use of IoT data
  • Technologies: Microsoft Fabric
Dirk Ohligschläger
turn your data into value

Let’s get started!

Do you also want to optimally use the potential of your data and open up new business opportunities?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

starpool: Entering a new digital age with Fabric

Lena Gädke
Data Product Owner & Developer, Starpool Finanz GmbH

Microsoft Fabric is perfect for our current situation. We can quickly and efficiently build a modern data and AI platform that is fully up to date. This opens up all kinds of possibilities for us in the future.
The collaboration with ORAYLIS is going very well. We have an honest, almost friendly relationship. I can ask any question without hesitation. Even short-term changes are handled in a pragmatic and solution-oriented manner. This is how I imagine successful collaboration between equals. It’s just a lot of fun.

At a glance

  • Client: starpool
  • Industry: Financial services
  • Project objective: Building a modern, scalable data and AI platform
  • Technologies: Microsoft Fabric

Many medium-sized companies are currently faced with the challenge of setting the course for their digital future. Since the ChatGPT revolution, at the latest, the business applications of data and artificial intelligence seem almost endless. But what is the right path for your own company? Which technologies make sense and how do I proceed?

Lena Gädke from starpool knows what it means to face these questions. As both data product owner and developer, she is primarily responsible for all data-related issues at the financial services provider, which has 132 employees. Until now, a Qlik Sense system was the main tool she used in her daily work. “We developed the solution ourselves. We connected our data sources directly and developed analysis paths as needed. That was sufficient for creating reports. However, as our requirements grew, we reached our limits in many respects. Above all, we lacked a central location where we could consolidate all our data and make it available for analysis with other tools – in other words, what is essentially a modern data lakehouse.”

It was clear to everyone involved that a completely new solution was needed. The wish list included a comprehensively scalable data and AI platform that could be operated and continuously developed even with a small team.

Starpool

Data-driven company as a target vision

Starpool’s digital vision corresponds to that of a typical data-driven company: “Overall, we want to make working with data easier,” says Lena Gädke. “Every employee should have access to existing data and evaluations and be able to use them for their activities in a self-service manner. In addition, our goal is to gradually automate as many business processes as possible on the basis of data.”

Against this backdrop, the search for the right technology began. Fabric, a new all-in-one data platform from Microsoft, ultimately won the race. “Our data landscape and that of the group is already based on Microsoft components. Therefore, the move in this direction was only logical. At the same time, Fabric’s enormous innovation potential convinced us. Much of it happens at the touch of a button and is easy to use. This suits our small team very well. Ultimately, the technology is perfect for our initial situation. We can quickly and efficiently build a modern data & AI platform that is fully up to date. This opens up all kinds of possibilities for us in the future.”

All that was missing was the right partner for strategic planning and implementation of the solution. Starpool found this partner through an internet search. “ORAYLIS appears high up in the search results. The company is one of the leading fabric partners in Germany and Austria. From the very first conversation, I felt very comfortable with them, both professionally and personally. In addition, the ORAYLIS consultants were the best prepared of all the candidates. That made the decision easy. Together with my team leader at the time, René Kutz, we then made a pitch to the management and got the final go-ahead for the project.”

Strategy workshop defines the approach

The collaboration began with a special strategy workshop, the Fabric Adoption Planning Series. Here, the goals, the technical solution, and the implementation plan were defined jointly. The participants also put exemplary use cases to the test, which were to be implemented as a first breakthrough during platform development. This way, the solution can generate the first business value right from the start.

The development process itself was extremely straightforward thanks to the all-in-one approach: “Working closely with the group IT department, we only had to make a few basic settings and within a few minutes we had rolled out the basic platform, from data integration and consolidation to data analysis. Fabric clearly delivers what it promises,“ explains André Nünninghof, project manager at ORAYLIS. ”We were then able to connect the desired sources directly and run initial evaluations in Power BI. The tool is an integral part of Fabric and will replace Qlik Sense as the company-wide analysis interface in the future. We are currently seeing this kind of switch from classic BI tools to Fabric and Power BI very frequently.”

The Fabric platform also includes OneLake, a highly scalable data lake. This is where data is collected and made available in an open format for cross-system analysis. The necessary governance and security measures can also be managed centrally. There have been no significant hurdles in applying the new technology: “Fabric is now running very stably,” says André Nünninghoff. “Due to its high complexity, not all functions are fully mature yet. But when the need arose, we always found good solutions without incurring any technical debt.”

Use cases with business value

The first of the selected use cases is a standard application. “We transferred our proven reports from Qlik Sense to Power BI, putting them on a solid foundation,” explains Lena Gädke. “As a result, we can offer our users not only better evaluation functions, but also optimal performance and data quality at all times, as our various sources are now systematically merged and processed.” With the introduction of Power BI, the company-wide database is available to every employee. At the same time, data products such as reports can be integrated into Dynamics and made available to the entire company. This saves the company license costs, as all the necessary resources can be scaled in small increments. From an F64 capacity onwards, the costs for report consumers are completely eliminated.

The second use case, on the other hand, shows where starpool is headed in the future. For the first time, a business process that was originally manual has been successfully automated. “Our customers are primarily financial advisors, whom we support with tools such as our Europace comparison platform and direct consulting services. Newcomers receive special assistance. For example, our key account managers contact them directly after their first sale to offer further support.

Previously, they had to actively check the BI tool and manually record the status. This process is now fully automated in Dynamics. The key account manager receives a notification from the system and can then contact the customer immediately.

Digitalization is being driven forward

With the Fabric platform behind it, starpool’s digitalization initiative is now being driven forward in various areas. “The first step is to connect more and more data sources in order to end the parallel operation of Qlik Sense and Fabric as quickly as possible,” says Lena Gädke. “We are also already working on a follow-up project with ORAYLIS, in which we are integrating additional data products relating to our partners’ activities and transactions into Dynamics. In the future, we also plan to support our partners with data-driven services.”

Otherwise, the players are currently focusing primarily on organizational issues. After all, 132 potential internal users need to be empowered to work with data on a daily basis. A training concept for Power BI is currently being developed. New reports are now being developed hand in hand with users. The goal is to increase data literacy throughout starpool and to install a data ambassador in each team. This person will then be the first point of contact for data issues and will clarify concerns in direct exchange with the data team.

One thing is certain: starpool will continue on its path to becoming a data-driven company together with ORAYLIS. “The collaboration is going very well. We have an honest, almost friendly relationship. I can ask any question without hesitation. Even short-term changes are handled in a very pragmatic and solution-oriented manner. This is how I imagine a successful collaboration between equals. It’s just a lot of fun.”

turn your data into value.

At a glance

  • Client: starpool
  • Industry: Financial services
  • Project objective: Building a modern, scalable data and AI platform
  • Technologies: Microsoft Fabric
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to optimally use the potential of your data and open up new business opportunities?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Putzmeister: On the way to the digital construction site

Rüdiger Felleisen
Global Business Strategist Digitalisierung & IIoT, Putzmeister GmbH

ORAYLIS is a real stroke of luck for the realignment of our data world. We hit it off right away, and I immediately felt that they understood what we needed. The ORAYLIS consultants are not afraid to touch on sensitive issues and voice necessary criticism. That hurts at first, but in the end it helped us tremendously. The team went the extra mile as a matter of course. They always gave 120 percent. I really appreciated that.

In addition, ORAYLIS is one of the few Microsoft Managed Partners in Germany, which meant we were able to benefit from extensive funding throughout the entire project.

At a glance

  • Client: Putzmeister GmbH
  • Industry: Construction industry
  • Project objective: Development of a cloud platform for processing real-time data and developing digital services
  • Technologies: Databricks, Azure Event Hub, Azure Data Lake

In the concrete and mortar industry, the Putzmeister brand is the benchmark. It goes without saying that the pumps and conveyor systems from the global market leader based in Aichtal, Baden-Württemberg, are used on every major construction site – including prestigious projects such as the Fehmarn Belt Tunnel, the Lisbon Metro, and the gigantic Burj Khalifa in Dubai.

Putzmeister machines impress with their sophisticated technology, ongoing developments, and high durability. But quality alone is no longer enough to keep customers happy these days. After all, digitalization has not stopped at the construction industry: “Everywhere, there is a growing demand for data that can be used to bring more efficiency to complex construction processes,” explains Rüdiger Felleisen, Global Business Strategist Digitalization & IIoT. “AI services and automation based on real-time data are particularly in high demand due to the shortage of skilled workers.”

Verteilermasten von Putzmeister-systemen gießen eine große Beotonform.

In order to meet demand, those responsible for data strategy need to make significant changes. The starting point is a modern cloud platform that centrally consolidates the machine data generated in many locations and makes it available for the respective area of application.

Earning money with machine data

“Basically, the growing demand for data-based insights and services suits us very well,” says Rüdiger Felleisen. “Because let’s be honest – high-quality products always have the disadvantage for manufacturers that they are replaced less often. Our machines sometimes last for decades. At some point, there are natural limits to growth.”

Against this backdrop, digital services serve to raise the company’s profile in relation to its competitors. On the other hand, they can also develop into a tangible revenue factor and enable completely new business models. The key to this is always high-quality data that flows reliably and at high performance to its destination – an issue that Putzmeister had to address first and foremost. “Until now, we have collected our data in many isolated silos and processed it using a very heterogeneous system landscape. So the conditions were not ideal. There was also a lack of a structured approach to the development of specific data products. We had a lot of work ahead of us that we couldn’t do on our own.”

Mitarbeiterin von Putzmeister montiert einen Verteilermast

As a result, those responsible sought support from the data experts at Microsoft. Together, the players held the first rounds of consultations. One of Microsoft’s most important partners in Germany, ORAYLIS GmbH from Düsseldorf-Meerbusch, was ultimately recommended for the rest of the project.

Strategic advice on getting started

“ORAYLIS is a real stroke of luck for us,” says Rüdiger Felleisen. “Even during the pitch, I felt that they understood my needs best. We spoke the same language and got along great right away. What’s more, the company is one of the few Microsoft Managed Partners in Germany, which meant we were able to benefit from extensive funding throughout the entire project.”

The official start of the collaboration was marked by a Data Strategy Assessment (DSA). With the overarching vision of a digitally controlled construction site in mind, a suitable technical solution was defined and the next steps were planned. In addition, the participants prioritized initial use cases based on costs and benefits in order to gradually approach the overall objective. From Rüdiger Felleisen’s point of view, the effort was worth it: “I found the DSA perfect in every respect. What we have achieved for this amount of money and in such a short time is remarkable.”

Data platform for real-time processing

The most important change in Putzmeister’s data strategy is that data silos are being broken down and made accessible centrally on a single platform. For future plans, it is particularly important that real-time data from the machines can be processed efficiently. The technological foundation has been built accordingly: “At Putzmeister, we rely on a special combination of Databricks and proven Azure services,” explains Benjamin Laerbusch, technical project manager at ORAYLIS. “Experience shows that this is the most economical and powerful approach in such complex projects.”

Another important aspect for getting started with digital construction site management is the scalability of the data platform: “We started with an initial, still fairly manageable use case. After that, the platform will be expanded step by step with additional areas of application until we can finally map complete construction site processes and support them with data. That’s why our solution has a modular structure that can be expanded according to the building block principle. New requirements, machine types, and data sources can be seamlessly integrated at any time.”

Controlling construction sites with data

The first specific use case involves an ISO-certified interface that allows processing companies to import the enriched data from their pump systems directly into an industry-standard scheduling tool. “Customers receive detailed information, for example, on the position, operating hours, and delivery rates of the machines, enabling them to better plan and coordinate processes on the construction site,” explains Benjamin Laerbusch.

Putzmeister-System gießt eine große Deckenfläche

This enables significantly more efficient and sustainable fleet management. Operating times, utilization, and maintenance intervals can be comprehensively optimized. In addition, predictive scenarios help to avoid malfunctions and downtime. Last but not least, companies can use the data provided to develop their own applications, analyses, or dashboards. Intelligent Dispatching is currently undergoing intensive practical testing and refinement in collaboration with selected customers.

From manufacturer to digital service provider

Those responsible have now created the ideal starting point for the further development and expansion of digital construction site management. Putzmeister has a future-proof data architecture and can gradually expand its offering for customers, partners, and third-party providers on the basis of the first open interface.

Data-supported additional services in particular offer new business prospects: “Against the backdrop of market developments, we are increasingly striving for a business model in the direction of ‘Concrete as a Service’,” says Rüdiger Felleisen. “This means that we are not selling the value of the machine, but rather the digital services that surround it, such as real-time monitoring, predictive maintenance, or particularly in-depth data and insights. Billing is then based on operating hours.”

Rüdiger Felleisen also attributes the successes achieved so far to the collaboration with the ORAYLIS team: “The ORAYLIS consultants never shied away from touching on sensitive issues and voicing necessary criticism. That hurt at first, but ultimately helped us enormously. The team went the extra mile as a matter of course. They always gave 120 percent. I really appreciated that.”

turn your data into value.

At a glance

  • Client: Putzmeister GmbH
  • Industry: Construction industry
  • Project objective: Development of a cloud platform for processing real-time data and developing digital services
  • Technologies: Databricks, Azure Event Hub, Azure Data Lake
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to optimally use the potential of your data and open up new business opportunities?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Blum Group: Effective organizational structures for successful digitalization

Alicia Manglano
Lead Business Analytics Strategy, Blum Group

It was a great advantage for us to receive technical and organizational consulting from a single source during our digital realignment. The collaboration with ORAYLIS worked really well. With the standards and structures we developed together, we were able to massively accelerate company-wide data analysis. Our users are very satisfied with the results. Today, they get what they really need much faster.

At a glance

  • Client: Julius Blum Group
  • Industry: Manufacturing industry
  • Project objective: Establishment of a cloud platform and development of organizational structures
  • Technologies: Databricks, Azure Data Lake, Azure Data Factory, Azure Storage Account, Power BI

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, produces high-quality hinge, flap, and box systems. Today, the Swedish furniture giant is one of its largest customers.

Zwei Mitarbeitende der Blum Group im Austausch.

Blum is one of the world’s leading manufacturers of furniture fittings. To manage its global business, the company increasingly relies on data-driven decisions. But until recently, neither the technologies nor the organizational structures kept pace with its rapid growth.
“We were struggling with a growing backlog of requests from the specialist departments in our central IT department,” explains Alicia Manglano, Lead Business Analytics Strategy. “At the same time, management wanted key performance indicators for corporate management. So we had to act urgently.”

Realignment with decentralized structures

The large-scale digitalization initiative focused not only on technology but also on the organization of data analysis.
“Our challenges were not only technical in nature,” says Alicia Manglano. “Many were related to processes and the distribution of responsibilities. It makes no sense for business users to go through IT every time they need something new.”
One of the core objectives was therefore decentralization: specialist departments should be able to design reports and dashboards independently and take more responsibility for their data.

Zwei Mitarbeiter der Blum Group beraten vor einem Bildschirm

To achieve this, Blum brought in external support. ORAYLIS GmbH, already selected to build the new data platform, was also tasked with helping set up the necessary organizational structures.
“This was a recommendation from our neighbors at ALPLA,” recalls Alicia Manglano. “ORAYLIS had been very successful in helping them revamp their company-wide data analysis. It was a great advantage for us to receive all consulting services for our transformation from a single source.”

Data mesh as an organizational concept

The collaboration began with a Data Strategy Assessment (DSA), covering both technological and organizational aspects.
On the technology side, the result was a cloud platform in Microsoft Azure, designed as a hybrid data mesh. This supports controlled decentralization: individual analysis teams – primarily specialist departments – access the same consolidated data set. Created reports, tables, and models are published as data products on a shared platform.

Meanwhile, the organizational stream addressed processes, roles, and responsibilities.
“These principles are essential in a data mesh,” stresses Simon Esser, project manager and strategy expert at ORAYLIS. “Without clear standards, there’s a risk of everyone doing their own thing – at the expense of data quality. That would jeopardize the entire project.”

Simon Esser stehend vor einer Betonwand

The starting point for the further work of the organizational project was two exemplary use cases that were intended to reflect the two typical characteristics of the desired mesh construct: a more user-oriented “standard analytics product” in the form of order-to-cash reporting, and a complex case for visualizing quality data, which served as an example of “advanced analytics products.”

Processes and roles for different data products

“Blum’s standard and advanced products differ greatly,” explains Simon Esser. “That’s why we defined separate lifecycles for each. From initial data research to the finished product, we mapped out all tasks, assigned them to roles, and defined the required skills and responsibilities.”

With this foundation, the organization team set up specific work packages and began step-by-step implementation. The close cooperation between organizational and technical teams, supported by ORAYLIS, created a stable foundation for becoming a data-driven company.

Departments are very satisfied

“The collaboration with ORAYLIS worked really well. Our processes have accelerated massively,” says Alicia Manglano. “Thanks to the roles we defined together, each department now has its own data product team that independently creates dashboards and is the first point of contact for user concerns. If IT support is needed, our new template ensures fast, efficient processing. Our users are very satisfied – today, they get what they need much faster.”

Employees now also have direct access to the company’s central database. Relevant data can be used in daily work without relying on IT. As a result, the data mesh construct is growing dynamically, with more and more departments acting as independent analysis teams.

Blum is already planning further development:
“We are currently working on a certification to ensure the quality of our data products,” says Alicia Manglano. “We also plan to introduce monitoring to track their costs. Once these steps are complete, we will be ready to roll out the concept globally across our subsidiaries.”

Turn your data into value.

At a glance

  • Client: Julius Blum Group
  • Industry: Manufacturing industry
  • Project objective: Establishment of a cloud platform and development of organizational structures
  • Technologies: Databricks, Azure Data Lake, Azure Data Factory, Azure Storage Account, Power BI
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to optimally use the potential of your data and open up new business opportunities?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

ALPLA: Platform services ensure optimum operational reliability

Andreas Weilguny
Senior Business Analyst, ALPLA Group

For me, good platform service is like electricity from a power outlet—it’s always available, and you don’t even notice it. Applied to our daily business, this means that errors are fixed before users or I even notice them. The ORAYLIS team gives me a great deal of peace of mind and security in this regard. We have noticeably fewer service tickets. This gives me more time to focus on my core tasks and drive improvements together with the specialist departments – always with the certainty that everything is running reliably in the background.

At a glance

  • Client: ALPLA Group, Austria
  • Industry: Manufacturing industry
  • Project objective: Ongoing operational services for the global data platform and support for further development
  • Technologies: Databricks, Azure Data Lake, Azure Data Factory, Azure DevOps

Some companies launch new data solutions and only then realize that operating them involves a multitude of ongoing tasks. Not so for the ALPLA Group from Hard, Austria. The leading packaging manufacturer planned its global data platform—known as AlplaMART—based on the latest findings in a Data Strategy Assessment (DSA) and implemented it using modern technologies from the Azure Cloud. The future operating services were also outlined in detail in advance.

Luftbild von ALPLA-Werkshalle

The reasons are obvious to Andreas Weilguny, Senior Business Analyst and Operations Manager at ALPLA: “We have to ensure the best possible operational reliability, otherwise there is no point in even starting such a comprehensive platform project. Nobody wants to work with a solution that is unreliable and provides incomplete figures.

First the service plan, then the development work

AlplaMART brings with it many new challenges. That is why those responsible for the ongoing platform services rely on external support. The data experts at ORAYLIS GmbH have been involved in shaping this large-scale digitization project from the very beginning: “Our partner not only implemented the technical solution, but also provided important strategic and organizational impetus. The ORAYLIS operations team was already on board in the initial DSA and drew our attention to many relevant issues. It quickly became clear that we would tackle the further operation of the solution together.”

Zwei ALPLA Mitarbeitende unterhalten sich vor einem Bildschirm.

As a result, a detailed service plan containing all important processes, measures, and roles was already in place before the platform development began. At the same time, the effort and costs involved became transparent. Andreas Weilguny sums up what he considers to be good platform services: “For me, it’s like electricity from a power outlet—it’s always available, and you don’t even notice it. Applied to our daily business, this means that errors are fixed before users or I even notice them. The ORAYLIS team gives me a great deal of peace of mind and security in this regard.”

Measures for optimum operational safety

How are the services related to the platform organized? What components are needed to ensure optimal operational reliability? “A core element of our services is ongoing monitoring, which covers all processes related to data extraction, loading, and transformation,” explains Recep Gümüs, operations expert at ORAYLIS. “For company-wide production reporting alone, we process data from more than 190 plants worldwide.”

Recep Gümüs im ORAYLIS Office

Monitoring is visualized via customer-specific reports and dashboards. In the event of irregularities—such as when loading processes are interrupted or delayed—the operations team has set up automatic alerts. This allows many problems to be resolved before they reach the operational level. If this is not possible, there are clear procedures in place: “We inform the BI team, who then communicate with the relevant departments. At the same time, we start troubleshooting. Everything is geared toward finding a solution as quickly as possible and maintaining transparency for all involved.”

Service Desk for user inquiries

Another component of the operating concept is a service desk that specialist departments can contact with technical questions and problems. The initial point of contact and interface here are the business analysts from ALPLA’s BI team. More complex development issues in particular are immediately forwarded to the ORAYLIS operations team.

“We then take care of the users’ concerns and stay on the ball until the case is resolved,” explains Recep Gümüs. “With a multi-level ticket system, we maintain an overview and enable fast processing. At the same time, we can also guarantee full transparency about the current status.”

Ongoing improvement through regular exchange

Every quarter, the team of ALPLA and ORAYLIS employees reviews the ongoing processes and measures in a service management meeting. During these meetings, open issues are addressed, potential areas for optimization are explored, and new and further developments are discussed. “I always look forward to these meetings,” says Andreas Weilguny. “We talk openly about everything and always find good solutions. Afterwards, I always feel that we have made progress. Our regular exchange contributes to the continuous improvement of AlplaMART.”

The success of the collaboration is reflected in concrete results: “I am receiving noticeably fewer tickets – a clear sign that our joint service system is working and that we are proactively solving more and more problems. This gives me more time to focus on my core tasks and drive improvements together with the specialist departments. Ultimately, the ORAYLIS team gives me the reassuring certainty that everything is running reliably in the background.”

turn your data into value.

At a glance

  • Client: ALPLA Group, Austria
  • Industry: Manufacturing industry
  • Project objective: Ongoing operational services for the global data platform and support for further development
  • Technologies: Databricks, Azure Data Lake, Azure Data Factory, Azure DevOps
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to optimally use the potential of your data and open up new business opportunities?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

Digital transformation: evm turns its data into value

Mona Meyer
Division Manager Sales Control and Sales Strategy, Energieversorgung Mittelrhein AG

Before we started working with ORAYLIS, we could only derive business value from our data at great expense. Since the data was stored in many different systems, there was a need for merging the information into one “numerical truth”.

Thanks to their structured and agile approach, the experts at ORAYLIS were able to quickly develop a Modern Data Warehouse in the cloud. We now have a uniform data basis for our business issues – a solid foundation we can build on together. Without external support, such a complex project could have never been realised successfully.

At a glance

  • Client: Energieversorgung Mittelrhein AG
  • Industry: Energy
  • Project objective: Merging the company’s data for new use cases and to create uniform KPIs
  • Technologies: Azure Data Factory, Data Lake Storage, Databricks, Power BI

Energieversorgung Mittelrhein (evm) is the largest municipal energy and service company in Rhineland-Palatinate. Approximately 1,000 employees ensure the supply of green electricity, natural gas, heat and drinking water to a total of 340,000 costumers. Naturally, a large amount of data has always been generated in the daily business – valuable information that, for example, could have been used for creating customer potentials. However, due to the inconsistency of the system at that time, this opportunity went unused: “Our data was available in different individual solutions, some of which were not directly linked,” Mona Meyer, Division Manager Sales Control and Sales Strategy at evm, says. Accordingly, employees in the specialist departments often had to create their queries manually, which cost a lot of time. Quick ad-hoc analyses were also very difficult to carry out.

Reliable decisions were difficult to make

“Above all, however, we had no uniform results and key figures due to the various individual solutions,” Mona Meyer explains. This basis did not allow for reliable decision-making, for example on the distribution of budgets or investments in business and product areas. There was an urgent need for merging the information into one ‘numerical truth’.” A task that initially seemed like an insurmountable hurdle to those responsible: “Given the high level of complexity, the number of people involved and the numerous data sources, we seriously had to ask ourselves: Can this even work?”

An agile approach reduces complexity

The problem was solved by working together with ORAYLIS. “Thanks to the structured and agile approach of our new partner, we were able to quickly get an overview of our initial situation and the next steps,” Mona Meyer says. From day one, the project management team set the right course and involved the appropriate employees in the process. The team quickly worked its way into both the complex structure of the source data and the at times complex technical content. “As the project progressed, the ORAYLIS team was keeping track of everything. Among other things, regular success check-ins and coordination led the project to success in a targeted manner.”

Modern Data Warehouse enables valid decision-making

After only a short period of time, evm had a modern Data Warehouse in the Microsoft Azure Cloud. As a “single point of truth”, the solution collects all data on one platform and finally delivers the desired, consistent key figures. On this basis, the management can now make valid decisions regarding urgent business issues. At the same time, cross-divisional analyses are considerably simplified for employees in controlling, marketing, customer service and sales.

Likewise, the manual effort for standard reports has been eliminated, as these are now provided automatically via Power BI. This saves a lot of time and resources in the process of compiling relevant information. Employees can concentrate on their core tasks. “This is only the beginning of what can and needs to be done. Both our database and our reporting system must now be developed continuously. The expandable cloud approach in Azure and the new platform offer the best conditions for this development. There is one thing that we have learned during this process: For projects like this, it is key to have an experienced partner on your side. We would have never been able to realise our visions successfully with internal resources alone. ORAYLIS provided us with excellent support,” Uwe Worch, head of IT at evm, says.

turn your data into value.

At a glance

  • Client: Energieversorgung Mittelrhein AG
  • Industry: Energy
  • Project objective: Merging the company’s data for new use cases and to create uniform KPIs
  • Technologies: Azure Data Factory, Data Lake Storage, Databricks, Power BI
Dirk Ohligschläger
turn your data into value

Let’s get started!

Do you also want to optimally use the potential of your data and open up new business opportunities?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

GermanPersonnel: Digital transformation with new customer services

Christian Oberstädt
Manager Data & Product Strategy, GermanPersonnel

We can now deliver far more quality candidates to our clients for their existing budgets. Thanks to the automated recommendations and success forecasts of our software, ads can be created and distributed much more precisely. And the personal advice provided by our staff has also gained considerably in quality thanks to data-driven standardisations. With this offer we have a real USP that clearly sets us apart from the competition in the e-recruiting market. ORAYLIS has triggered many innovations for us. Together, we are an outstanding team from which much more can be expected in the future.

At a glance

  • Client: GermanPersonnel e-search GmbH
  • Industry: Personnel services
  • Project objective: Establishment of a uniform database and development of innovative recruiting services
  • Technologies: Azure Data Lake, Microsoft SQL Server, Databricks, Power BI Embedded

GermanPersonnel is one of the leading providers of software and services for employee search on the internet in Germany. The company cooperates with Germany’s largest personnel service providers and job portals. With the products of the e-recruiting experts, customers can design their job advertisements and place them on job boards as well as manage applications. In this way, the company has gained special unique selling points on the market. At the same time, it was clear to those responsible that they would not be able to stand out from the growing competition in the long term with this range of services.

Potential in the data was not utilised

“In fact, until then we had only used the extensive data from the recruiting processes selectively, for example for the further development of business processes, products and algorithms for intelligent channel selection,” explains Christian Oberstädt, Manager Data & Product Strategy at GermanPersonnel. “In addition to data, our expertise and a pinch of gut feeling still flowed into our decision-making processes. There was still a lot of potential hidden there.” Therefore, a conscious decision was made to change to a data-driven company. New goals were formulated, such as automatic recommendations when creating job advertisements and predictions about the expected number of applicants. In addition, data should also be used internally by all employees, for example through comprehensive reporting.

Consistent database for reliable evaluations

In order to tackle the ambitious plans in a targeted manner, ORAYLIS was brought in as a partner and guide. An initial status quo analysis revealed that although GermanPersonnel had extensive data, it was not suitable for the desired comprehensive evaluations due to a lack of structure. Therefore, all data from the recruiting processes and other data sources were first brought together in a structured way in a Data Warehouse in the Microsoft Azure Cloud. The preparation of the data for further analysis processes is automated and updated on a daily basis. Thanks to the cloud approach, the solution can grow flexibly depending on the volume of data and the number of customers and key figures.

Michael Althaus ORAYLIS Projekt GermanPersonnel

However, innovations such as predicting clicks and applicant numbers could not have been implemented on this basis alone. “For such requirements, exact information on the entire candidate journey is needed,” explains Michael Althaus, project manager at ORAYLIS. Therefore, a special tracking tool is used. “The tool continuously collects anonymised, event-driven web data from almost 180,000 job ads, with data sovereignty remaining with GermanPersonnel.”

Customers save time and money

Christian Oberstädt, Manager Data & Product sums up the added value of the intelligent, data-based recruiting solution: “Today, we can provide our clients with significantly more high-quality candidates for their existing budgets. Thanks to the automated recommendations and success forecasts of our software, advertisements can be created much more precisely and distributed to the mass of recruiting channels. And the personal advice provided by our staff has also improved considerably thanks to data-driven standardisations.”

Finally, the daily updated statistics enable a targeted control of the ads already placed. At the same time, successes become transparent and measurable. Last but not least, the user saves a great deal of time through a clear and structured management of his job advertisements and applicants.

New service is a USP on the market

GermanPersonnel also benefits directly from the solution. “With this offer, we have a real USP that clearly sets us apart from the competition in the market for e-recruiting,” says Christian Oberstädt. In addition, the company has been able to define economically sensible packages for ad placements thanks to the new analysis options. The more valid planning basis ensures noticeable savings when purchasing traffic and clicks from the relevant job boards. Meanwhile, the fast-growing company is preventing staff shortages in-house by automating processes.

Overall, the digitalisation of all processes leads to significantly higher efficiency and more reliable decisions. Together with ORAYLIS, the company has completed the transformation to a Data Driven Company, and according to Christian Oberstädt, this development is far from complete: “ORAYLIS has triggered many innovations for us. Together, we are an outstanding team from which we can expect a lot more in the future.”


turn your data into value.

At a glance

  • Client: GermanPersonnel e-search GmbH
  • Industry: Personnel services
  • Project objective: Establishment of a uniform database and development of innovative recruiting services
  • Technologies: Azure Data Lake, Microsoft SQL Server, Databricks, Power BI Embedded
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to optimally use the potential of your data and inspire your customers with innovative services?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

WMF upgrades commercial coffee machines with real-time services

At a glance

  • Machine data is analysed in real-time and used for innovative customer services
  • Individual apps provide massive savings in time and effort for the various target groups
  • Product manufacturer transforms into holistic solution provider

The business situation of our client

There are countless opportunities in your data to improve your business and make your customers more satisfied – not only in the form of process optimisations and better decisions. Rather, you can create completely new customer experiences with innovative products and digital business models and thereby stand out from your competitors.

Just like our client WMF – the world’s leading manufacturer of commercial coffee machines faced these challenges, among others:

  • Low growth opportunities due to market saturation.
  • Competing products of similar performance and quality
  • Costly service business with regard to required spare parts
  • Data management in heterogeneous system landscape
  • Service instructions mostly in German language

As a result, together with those responsible, we have expanded the company’s products with data-driven applications that significantly facilitate the daily work of the core target groups – specifically: facility managers, food chain managers and service technicians. WMF is thus developing more and more from a pure product manufacturer to a provider of digital services.

WMF Group: Digitale Echtzeitservices für Profi-Kaffeemaschinen 

The solution for our client

In order to achieve the set goals, we have networked all active customer machines with the services of the Microsoft Azure Cloud via the Internet of Things. The central component here is a digital cloud platform. Here, the status data generated by the machines is collected, processed and made available for the various application scenarios. There is also a feedback channel through which the user can send commands to the machines.

In addition, we have connected the company network to the platform and with it other data sources, such as CRM, ERP, telemetry database and media pool. As a result, the platform also functions as a knowledge database that bundles comprehensive information and problem solutions for WMF employees and customers. In this context, existing text documents are automatically extracted and translated into different languages.

Finally, a real-time analysis of the machine data enables very different digital innovations. We provide these as user-friendly apps in a modern UX design. The applications can be seamlessly integrated into other business applications via a standardised interface, so that the user can work with them comfortably in his familiar environment. Meanwhile, WMF’s specialist departments and analysts receive interactive reports for more in-depth analyses.

How data turns into new values

As it turns out, it is not that difficult to make analogue products “intelligent” with cloud services and the Internet of Things. The resulting applications make the work of the various customer groups easier, above all through massive savings in time and effort:

Service technician

  • App provides detailed instructions for fault analysis and rectification
  • Immediate ordering of spare parts on site saves further effort

Food Chain Manager

  • Performance of branches and machines can be evaluated and controlled in real time
  • Necessary measures – for example with regard to capacity utilisation and quality – can be initiated directly
  • Example: New recipes or promotions can be sent directly to the displays of the machines in the shops

Facility Manager

  • App informs which machines in the building require action – for example, to refill coffee beans.
  • In the event of problems and defects, information is also provided for diagnosis and solution.


turn your data into value.

At a glance

  • Machine data is analysed in real-time and used for innovative customer services
  • Individual apps provide massive savings in time and effort for the various target groups
  • Product manufacturer transforms into holistic solution provider
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to inspire your customers with digital services and create a sustainable competitive advantage?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

How o2 improves its social media marketing performance

At a glance

  • Central reporting and analytics platform enables an overall view of all channels
  • All activities can be efficiently monitored and controlled
  • Insights ensure better content and greater awareness on an ongoing basis

The business situation of our client

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 success? Like most companies, our client o2 has asked itself this question – or even more specifically:

  • How do the individual channels perform?
  • Which content generates attention and possibly sales?
  • Where can content and costs be optimised?

Online data to answer these questions was available to o2 in large quantities. After all, the company not only operates various Facebook pages, websites and customer forums. There are also accounts on Instagram and YouTube as well as data from Google AdWords and Google Analytics. What was lacking, however, was an efficient way to evaluate it.

The solution for our client

Our solution for o2 brings together the multitude of channels on a unified analytics platform in the Microsoft Azure Cloud. The solution structure is as follows:

  • Data is imported using SSIS, with CData acting as an add-on that connects to the interfaces of the various sources.
  • The raw material is collected on a local SQL server, processed and made available for analysis.
  • The prepared data can be accessed via a fully integrated interface in Power BI.

Telefonica Projektbericht ORAYLIS

User-defined filters and dashboards then enable the individual teams to evaluate and publish the relevant data in a targeted manner. Due to the high system performance and continuous updates, the data is never more than a few hours old. Since Power BI is also used as a cloud service, users can access the solution on the move at any time.

How data turns into new values

The central reporting and analytics platform now offers social media staff an overall view of all channels and their data. The user can efficiently check and control all activities through analyses down to the posting level as well as plan-actual comparisons of content, costs and results.


This creates new values in many ways:

  • The quality of the content produced increases
  • The perception of the published postings increases
  • Social media budgets are invested more successfully
  • Community questions are answered more quickly
  • The overall effort is reduced


turn your data into value.

At a glance

  • Central reporting and analytics platform enables an overall view of all channels
  • All activities can be efficiently monitored and controlled
  • Insights ensure better content and greater awareness on an ongoing basis
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to use your social media data to continuously improve your performance?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

How innogy is preparing for the future with a digital platform

At a glance

  • Data Analytics system in the Azure cloud enables flexible growth
  • All user groups can work with data and generate new values
  • Data from SAP BW can be seamlessly integrated into analyses

The business situation of our client

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 – and with them the ever increasing demands on data analysis. As a result, a great deal of potential for business remains unused.

The energy supplier innogy also found itself in this situation and turned to us for help. The company needed a future-proof platform that met the following requirements:

  • New data sources can be connected quickly and easily
  • Data can be made available to the largest possible group of users
  • Grow flexibly as new requirements arise
  • Data-driven innovations can be implemented easily
  • The efficiency of company-wide data analysis is increased

A particular challenge was to integrate an existing SAP BW on Hana into the solution. Above all, this data should later be seamlessly available across the entire system.

innogy Projektbericht ORAYLIS

The solution for our client

Due to the high demands on flexibility and future-proofing, we built innogy’s new data analytics platform in the Microsoft Azure Cloud. Our platform consists of a data warehouse with classic layer architecture as well as a Data Lake to which new data sources can be quickly connected and used by defined user groups. This means that data from SAP BW can also be accepted, processed and made available very easily.

The Microsoft services Power BI and Excel are primarily available as analysis tools. However, third-party tools can also be used if required. In this way, the needs of all user groups can be covered. It is possible to automatically provide business users with interactive standard reports as well as to give data scientists and business analysts the necessary freedom for ad-hoc analyses. Comprehensive authorisation concepts regulate access to the data.

How data turns into new value

With the new cloud platform, innogy is now optimally positioned for the future in the value-oriented use of its data:

  • The platform can grow flexibly with new requirements at any time
  • Data scientists, business analysts and specialist users can all create new value from data in equal measure
  • Data is quickly and easily available to business departments for analytical purposes
  • Staff can concentrate on the core tasks of value-oriented data analysis
  • Efficiency has increased while costs have decreased
  • The protection of sensitive data is fully ensured


turn your data into value.

At a glance

  • Data Analytics system in the Azure cloud enables flexible growth
  • All user groups can work with data and generate new values
  • Data from SAP BW can be seamlessly integrated into analyses
Jens Kröhnert
turn your data into value

Let’s get started!

Do you also want to optimally use the potential of your data and open up new business opportunities?

Join #teamoraylispeople

Shape the world
of data with us

Customer success

From SAP to Microsoft BI: Krones AG modernises its data analysis

Jonas Heindl
Teamleader Business Intelligence, KRONES AG

With ORAYLIS, we have gained a long-standing partner with a lot of competence and reliability. Originally, we used various solutions for the evaluation of our data. These included an SAP BW and an Oracle DWH. This meant that we did not have a uniform database that would have given our employees worldwide a comprehensive view of all data and the corresponding analysis scenarios. Practically every department benefits from our new solution – and first and foremost the customer.

At a glance

  • Client: Krones AG
  • Sector: Industry/Filling and packaging technology
  • Project objective: Integration of SAP and Oracle data on a uniform Microsoft platform
  • Technologies: Microsoft SQL Server, Excel, SAP modules, Theobald connector

“Progress” has always been a top priority at Krones AG: The company was founded in 1951 as a classic machine manufacturer. Since then, Krones has developed to the world’s leading supplier of system technology with various subsidiaries, whereby the portfolio includes modern systems from the areas of process, filling and packaging technology. In order to be able to continue to live up to this claim to leadership in the face of global competition, those responsible had to seize the opportunities offered by digitisation and convert their constantly growing data stocks as comprehensively as possible into new values for the business, the employees and, above all, the customers. The starting point for this was the company’s disparate system landscape.

Zentrale Krones AG

Analysis functions were limited

“Originally, we used various solutions to evaluate our data,” explains Jonas Heindl, Team Leader Business Intelligence at Krones AG. “These included an SAP BW and an Oracle DWH with Business Objects. So we didn’t have a consistent, uniform database available that would have given our employees worldwide a comprehensive view of all data and corresponding application scenarios.” In the same way, the individual systems did not meet the demands in terms of performance and analysis possibilities. “The specialist departments could only carry out independent evaluations to a very limited extent and with great effort. Therefore, we decided to replace the existing technologies with a modern, integrated Enterprise Data Warehouse (DWH) with a self-service approach. Whereby the work on the new solution was, of course, not allowed to influence the ongoing business.”

All data on one platform

Thus, with ORAYLIS as implementation partner, a group-wide enterprise data warehouse based on Microsoft technologies was set up in parallel with current SAP developments, and the changeover went absolutely smoothly. “This platform provides Krones with a so-called single point of truth for the first time,” explains Matthias Petig, Senior Consultant at ORAYLIS. “All relevant source systems are consolidated here, such as the SAP ERP and CRM or even the telephone system and planning applications. Data is then updated automatically from the source systems to the analysis cubes of the specialist departments.”

As part of the self-service approach, departmental and power users now create and manage all analyses independently. In addition to tools for ad-hoc analysis, templates are also provided for all necessary standard reports. For the first time, the management receives a uniform board report folder on all key figures. The higher-level functionalities include, in part, multilingual evaluations and the consideration of multi-level authorisations.

Benefits for the client and Krones AG

“Thanks to the easy handling of the analysis tools, the new solution has been very well received by our users,” says Jonas Heindl. “Practically every department benefits from it – and first and foremost the client.” For example, availability analyses and targeted staff scheduling have a positive effect on customer service. The same applies to the analysis of order and complaint processes. With a 360° view of customers and their assets, the sales department can track details of all orders and respond to quotation requests more quickly. Likewise, customer and market potentials can be determined in a well-founded manner.

Meanwhile, Marketing can evaluate its campaign successes in detail and manage them with foresight, so that advertising funds are invested much more efficiently. Purchasing has the opportunity to take a closer look at price developments and suppliers. In production, the evaluation of production data optimises throughput times and the use of personnel and materials. At the same time, the evaluation of material stocks ensures better warehouse utilisation and capital commitment. Finally, the finance and controlling department has a much better basis for decision-making thanks to an automated solution for internal and external reporting. In addition, a valid control of costs and revenues, including profit and loss accounting, is made possible.

Last but not least, Krones has created a basis for the further digitisation of its business: “From a long-term perspective, our aim is to implement data-driven scenarios from the field of Industry 4.0. The new solution provides an excellent basis for this,” says Jonas Heindl.


turn your data into value.

At a glance

  • Client: Krones AG
  • Sector: Industry/Filling and packaging technology
  • Project objective: Integration of SAP and Oracle data on a uniform Microsoft platform
  • Technologies: Microsoft SQL Server, Excel, SAP modules, Theobald connector
Dirk Ohligschläger
turn your data into value

Let’s get started!

Do you also want to merge your data stocks from outdated systems such as SAP and Oracle on a modern analysis platform and thus create a stable basis for the digitalisation of your business?

Join #teamoraylispeople

Shape the world
of data with us

CUSTOMER SUCCESS

Predictive Policing: How criminals can be tracked using Artificial Intelligence

At a glance

  • AI solution relieves scarce police personnel resources
  • Crime hotspots are identified with foresight and task forces are controlled in a targeted manner
  • Success rates are significantly higher compared to experience-based approaches

The initial situation of our client

Artificial intelligence (AI) can make processes more efficient in practically every area and can therefore significantly reduce the needed human effort. For example, we developed an AI solution for the police department of one of the largest cities in Germany to predict crimes – also called predictive policing. Just like the rest of Germany, the city was struggling with far too few personnel resources to get a grip on the rising number of burglaries by organised gangs. Statistical methods for identifying potential hot spots hardly helped, as they practically made no use of the extensive case data that had been documented.

The solution for our client

The design of our solution shows that developing AI applications does not necessarily require high investments in new technologies. Since the police department’s IT infrastructure was already based on Microsoft technologies, we simply used the already existing SQL Server as a basis.

With the Analysis Services, we built a customised forecasting software that directly accessed the police’s internal databases, such as case details or geographic and demographic data. The Reporting Services were used to create an easy-to-use forecasting tool as well as a forecasting quality assessment. Finally, a special classification procedure identifies the quadrants with the highest probability of burglary and displays them in colour on a map in Power BI. The resulting forecasts are generated automatically on a daily basis and distributed to all police directors in the city.

How data turns into new values

With the diverse police data as a basis, the forecasting software makes an effective contribution to the prevention of residential burglaries by intensive offenders. Currently, the prediction of future burglaries is up to seven times better than previous experience-based approaches. The police forces show a targeted presence in the identified danger areas. In this way, potential perpetrators are deterred and residents are made aware of possible subsequent offences.

As the data used is constantly supplemented by new findings, the system continues to learn and provide ever more accurate insights. The new solution also proves to be an efficient repository of many years of police experience. Last but not least, the forecasting software can be maintained by the police themselves and can also be extended to other areas of crime.

turn your data into value.

At a glance

  • AI solution relieves scarce police personnel resources
  • Crime hotspots are identified with foresight and task forces are controlled in a targeted manner
  • Success rates are significantly higher compared to experience-based approaches
Dirk Ohligschläger
turn your data into value

Let’s get started!

Do you also want to use AI applications for your individual tasks in order to achieve much more with less effort?

Join #teamoraylispeople

Shape the world
of data with us