Question

Why should we use data ware housing and how can you extract data for analysis with example?

Answer 1

Data warehouse allows business users to quickly access critical data from some sources all in one place, provides consistent information on various cross-functional activities, also helps to integrate many sources of data to reduce stress on the production system.