You have an old version of the software. The website may not work properly. Please update your system to view the page with all available features.
light
dark
EN
light
dark

Our own Nostradamus

Challenges

Our task was to build one consistent data source, integrating data from various systems, for a very large organization (ABB corporation), based on Microsoft and Snowflake tools. In 2021, a special Data Engineering / Data Analysis team was appointed for this purpose. The goal was to construct AI-based mechanisms, that would enable the analysis of data in warehouses in terms of process prediction. This, in turn, was to enable planning optimization of manufacturing, purchasing, logistics and forwarding processes, as well as service and replacement of devices. In short, it was essential to create mathematical and analytical models that would allow for automatic aggregation and interpretation of data.

Challenge

  • data distributed over domain-specific systems, tough access, especially at the level of decision-makers
  • no data integration for orders, deliveries, inventory, HR systems (resource and human resources)
  • a very large volume of data, no mechanisms to automate ETL processes as well as aggregation and systematization

Solution

The project is coordinated by a technical leader appointed by TTMS, who is also a solution architect. With the help of Snowflake and Microsoft tools, mechanisms for the automatic acquisition, cleaning and systematization of data in the central Data Warehouse, built for this purpose, have been constructed.

1 Technical Leader

Outcome

In the next stages, based on the acquired and available information, the construction of ML mechanisms and AI algorithms will be carried out, thanks to which predictive effects will be obtained regarding various aspects of the daily operations of the Corporation. Among others, optimization of orders is worth mentioning, as well as improvements in supply chains and production processes or repair planning, shortening the time of order fulfillment and increasing the efficiency of processes. This, in times of permanent shortage of qualified personnel, will enable better use of specialists. There are a lot of needs and ideas - we hope that the built artificial intelligence and machine learning will at some stage reach a level, that will be our constant support. This will be followed by the implementation by our client of already invented ideas and the creation of completely new areas and the development of one of the most technologically innovative entities in the industry.

See other Case Studies

Contact us!

We are at your disposal

Jaroslaw Szybinski

Microsoft Solutions
Sales Director

    Your email

    Your message

    Captcha

    captcha