A data warehouse is a type of data management system that is designed to enable and support business intelligence (BI) activities, especially analytics. Data warehouses are solely intended to perform queries and analysis and often contain large amounts of historical data. The data within a data warehouse is usually derived from a wide range of sources such as application log files and transaction applications.
A data warehouse centralizes and consolidates large amounts of data from multiple sources. Its analytical capabilities allow organizations to derive valuable business insights from their data to improve decision-making. Over time, it builds a historical record that can be invaluable to data scientists and business analysts. Because of these capabilities, a data warehouse can be considered an organization’s “single source of truth.”
For your initial post in this discussion:

Imagine that you are put in a position to design a data warehouse. Based on your research and observations, what would be the steps that you would take?
Based on your research and observations, what are the advantages and disadvantages of a data warehouse?

Respond to at least two of your peers.
Your responses should encourage a thought-provoking discussion. This means asking questions, providing further elaboration, including additional resources, and/or agreeing/disagreeing with strong reasoning. Be sure to respond first to a classmate that does not yet have a response from anyone else. Try to respond with at least 150 words or more.
Note: If you are referencing the ideas of others and/or quoting text verbatim, you must include the author’s last name, year of publication, and page numbers. If you are referencing an internet source, you must include the URL at the bottom of your posting.