dataroomtechs.info/virtual-data-warehouses-compared-to-traditional-technologies/
The aim of online data warehouses is to centralize information in a non-volatile standardized system that is accessible to all employees for making decisions. They also provide an historical archive for data and act as an authoritative source of information and allow users to analyze data from different sources without relying on outdated data.
There are a variety of factors to take into account when choosing the right platform, architecture, and tools for the Data Warehouse. For instance whether the warehouse should be located on premises or in the cloud? Should it utilize extract transform and loads (ETL) methods or direct-to database integration? How often should data be updated? How will the change data capture capability be used to capture and feed updates to the warehouse? In the end, deciding on the right technology should be based on the organization’s specific business needs.
A bicycle manufacturer, for example can utilize its data store to find out more about present customer habits. It might find that their customers are primarily women over 50 years old, and may be keen to learn more about the shops they shop at for bicycles. This information could help the company to improve its marketing and development efforts.
In addition an IT team might make use of its data warehouse to aid the process of auditing and regulatory compliance by efficiently supplying historical records for review. This can save a business time and resources by eliminating unnecessary information.