Problem
Read on about certain examples of how the application of data warehousing concept is applied in several business industries today. Then, answer the following questions below.
Application of Data Warehousing
Construction
The construction firms require data on every purchase made during the construction timeline. This purchase needs to be attributed to a source to make financial decisions. The same goes for the wages of contractual employees. All this data will be recorded in a data store and later used for business intelligence by key decision-makers to estimate the overall spending of the company on a single construction site.
Healthcare
In healthcare, these central stores of data are used to record patient information from different units of the medical unit. This would include patient personal information, financial transactions with the hospital, and insurance data. All this is consolidated in the data warehouse and connected through the database schema.
Retail
For the retail industry, a good example would be a retail data mart that incorporates customer information from cash registers, mailing lists, websites, and feedback cards.
Task
Give an example of how the idea or concept of data warehousing is being used to improve one or more business processes for at least ten different business sectors and/or unique companies. Then, explain your chosen business sectors thoroughly.