Data warehousing involves collecting and managing data from multiple sources to provide integrated and historical views of data to support decision making. It is subject-oriented, nonvolatile, and time-variant. A data warehouse architecture is used to support applications in various industries like retail, banking, insurance, healthcare, manufacturing, sports, and telecommunications.