Time and time again, we hear how important standardised data management can be for a smooth workflow. If you have never worked with large amounts of data before, Excel and the like appear to be a good solution for storing and analysing data. At some point, it is then realised that this is no longer enough and an ERP system such as SAP Business One is introduced. Often years later, the next step follows: the data warehouse.
From the database to the data warehouse
databases or database systems are usually used to manage customer and billing data, control inventory and handle accounting.
The so-called data warehouse is usually also used for this purpose. Data from different sources is standardised in this warehouse as soon as the corresponding business transaction has been completed. This turns the data warehouse into an archive. For example, information is also stored that cannot initially be assigned but may be relevant at a later date. A good example of this is always the address data that is to be used in marketing.
Tap into multiple data sources
In this sense, the data warehouse as a kind of data pool in the company is the basis for many decisions.
The data collections are realised with data warehouse systems. The data is collated from various sources. It is then converted into standardised formats so that it can be processed for queries.
SAP HANA - the new strategy for data analysis
The use of a data warehouse is not really widespread among medium-sized companies. In combination with SAP Business One, this will only make limited sense in the future. Because with the analytical possibilities of SAP HANA idata mining has entered a new dimension. Although the approaches of Warehouse and Analytics-DB HANA are different, they can both deliver similar results.
Do not forget data protection
Of course, the data warehouse is also subject to the strict guidelines of the Data protection. In particular personal data are subject to these rules. With the new EU General Data Protection Regulation (GDPR) looming on the horizon, this becomes all the more important.
Data quality & AI : AI can only be as good as your data
SAP tools for integration & data analysis 2023
SAP Business One - Reporting
Dashboard functions in MARIProject
More key figures transparency in the ERP system
