Month: September 2018

In case of a classical data warehouse data are denormalized and stored in a so-called start schema modell. Because the main aim of such solutions is to serve the users with data as fast as possible and speed needs redundancy and hence denormalization. However, sometimes a certain level of normalization is necessary to make certain operation more manageable and automatized. …

Business Intelligence is a relatively new area of corporate IT. Very concise, it’s aim is to make company data understandable even for those users who are not really into IT (e.g. analysts, managers). Before the spread of BI, revealing relevant information required a great knowledge of databases and metadata. If data were derived from a number of core systems, beyond …