Chapter 7, Problem 1OC

Program Plan Intro

Data warehouse:

Data warehouse is also known as enterprise data warehouse which is nothing but a system that is used to report and analyse the data. It is taken as the core component of business intelligence. Data warehouses become the central repositories for the integrated data that is collected from one or more disparate sources. They store the current and historical data in the single place. The stored data is used for creating analytical reports for workers throughout the enterprise.

Explanation of Solution

Explanation:

• For any organization, information plays a vital role, it tells an organization about the current operations and helps it estimate and strategize about how future operations might perform.
• The key to success and growth is the ability to understand, digest, analyze, and filter information.
• The new opportunities and new perspective can be opened up when the right data is turned into information and ultimately into business intelligence.
• But with the growing number of systems, it becomes difficult to run a business which lets data warehouse to store and manage all the required information.
• Data warehouse is a central location for all the data so customer service systems can store data that can be crossed referenced with accounting data and sales data and allowing a complete view of the customer.