In your own words what is a data warehouse and why is it important to have another copy of the data in a data warehouse?
1) What is it?
A data warehouse is a storage place for all the previous information of a user of such data. You are able to analyze the trends over many previous years. Before the data gets sent into the data warehouse it is "cleaned" and integrated to fit into the standards and labels of the warehouse. The data warehouse brings everything together and collects all the information from different parts of the company and puts it all in one place.
2) Why is it important?
There are a variety of reasons why a data warehouse. The necessity of having previous years' data at a quick and accessible reach is crucial to the success of a company. Sometimes one needs to view trends to see what sells best and what is a low seller so you can determine what you are going to keep in high stock this year and what you need to purchase less of. The data warehouse is important for all kinds of analytical processes and is crucial for every successful business. Furthermore, it is always good to have several backups of data even for recent data just in case an operational data system shuts down. If this data needs to be pulled up again, this shows another reason why it's important to have a data warehouse.
No comments:
Post a Comment