Case study - Our own Nostradamus | Transition Technologies MS

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.

Background

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.