Developing a corporate DWH is a costly and challenging project. Despite this, the use of a custom DWH pays off by minimizing the risk of sensitive data loss.
A DWH is needed in the following cases:
1. The company uses external data sources. Patient notes, for example.
2. The number of used data sources exceeds 3-4. In fact, such a quantity is the norm of controllability.
3. There are several consumers of the same data. The DWH can be a source of information for an unlimited range of consumers.
4. The amount of the data collected exceeds certain given limits. For example, one of the leaders in BI, Power BI by Microsoft, limits a project to 100 GB of data for a Premium subscription.