A data warehouse allows users to have quick access to financial and operational reporting capabilities. A top-tier data warehouse will have both pre-built integrations for popular Enterprise Resource Management systems and customizable modules.
ERP with Datawarehouse provides “central single source of information” so that all necessary decisions may be taken correctly. ERP system creates central repository for current information sharing, while Datawarehouse creates central re- pository for current as well as past information sharing.
Where Is It used?
It is used for reporting and analysis. It stores old data and also uses real-time data to generate business reports Data Warehouse Types
1 Relationship Between Data Warehouse, Database, and Data Lake
There are several potential relationships between these three types of data stores:
1 How Can A Data Warehouse Benefit An Organization?
1. Subject-oriented
A specific business purpose can be analyzed with the data collected here Disadvantages
Cost v/s Benefit
It is an IT project that consumes more person-hours and more money from the budget. Moreover History
In the 1950s American government and businesses started using punch cards to store computer-generated data Data Warehouse Tools
1. QuerySurge
2. Oracle
3 Conclusion
The data warehouse is a term that has been around for more than two decades ERP software attempts to link all internal company processes into a common set of applications that share a common database. It is the common database that allows an ERP system to serve as a source for a robust data warehouse that can support sophisticated decision support and analysis.Datawarehouse is responsible for providing information needed for supporting executive decision making. As a re-sult, datawarehousing technology has been integrated into ERP systems. An ERP generates enormous amount of data on a daily basis and to keep the database size manageable, older data is archived periodically.Enterprise Data Warehouse (EDW):It helps to provide decision support services throughout the enterprise and also helps to classify data according to the subject. 2. Operational Data Store:It helps to store records of employees. 3. Data Marts: It helps to collect data directly from sources.