Manufacturing Data Warehouse¶

A Data Warehouse is a repository that contains the data of a company or organization and is used to easily produce analysis and relations to support business decision-making.

In our context, the structure of the data warehouse conforms to international standards such as ISA-95 and is moving toward Industry 4.0 models.

This repository collects most relevant business data from the data model. It stores business information instead of detailed production data to allow the personnel responsible for plant and line operations to easily access business reports, providing constantly updated information.

Data provided by Siemens and third-party products can be read, injected or stored in the data warehouse by means of miscellaneous data processing systems, such as stream processing or the ETL (Extract, Transform and Load) system to update data model implementation and fit the data model of new data.

Data can also be exposed in order to enable KPI reporting and advanced analytical functions.