Blog

Probably the best-known approach to automation is the Toyota Production System. It is considered a general model for the automation of complex processes. DevOps has shown that these…

When implementing a data interface for BI, it is important to secure these interfaces. If the data submissions are not reliably available at the agreed time, if the…

For reporting, the data from Raw and Business Vault – the Core Warehouse – is transferred into a dimensional model. While the focus in the Core Warehouse is…

A data warehouse often has chronically too many unprocessed requests and at the same time the share of maintenance effort increases. The death blow for a data warehouse…

Principles provide quick orientation. Like a compass, they point the way. With a compass, there is often an obstacle on the direct path to the goal. With principles,…

Even with interfaces, standards reduce the complexity and lower the effort. The fewer exceptions there are, the easier maintenance and servicing are. Fewer exceptions mean that new employees…

Connecting a new data source for the data warehouse should be a simple process. However, each source system has its own requirements for exporting and transporting the data.…

When you work with data warehouse automation for a while, you notice that the bottleneck shifts. The actual gain in time lags behind the gain in productivity. Both…

Article in German from BI-Spektrum 05/2019: Many problems in BI have their root in the delivery of data. Often not even the word interface is used for this…

Data Vault has high goals and promises many improvements: Sustainable: The core warehouse remains stable through data integration via business objects/business keys Expandable: Hub, link and satellite provide…