Offers “what-if” scenarios to inform practical decisions based on more comprehensive analysis Predicting future performance (data mining)ĭevelops visualizations and forward-looking business intelligence Provides relational information to create snapshots of business performanceĮxpands capabilities for deeper insights and more robust analysis Sandboxes are private, secure, safe areas that allow companies to quickly and informally explore new datasets or ways of analyzing data without having to conform to or comply with the formal rules and protocol of the data warehouse. When the data is ready for use, it is moved to the appropriate data mart. Adding data marts between the central repository and end users allows an organization to customize its data warehouse to serve various lines of business. Although this can be done programmatically, many data warehouses add a staging area for data before it enters the warehouse, to simplify data preparation. Operational data must be cleaned and processed before being put in the warehouse. The repository is fed by data sources on one end and accessed by end users for analysis, reporting, and mining on the other end. All data warehouses share a basic design in which metadata, summary data, and raw data are stored within the central repository of the warehouse. The architecture of a data warehouse is determined by the organization’s specific needs. Middleware BI environments that provide end users with reports, The data warehouse serves as the functional foundation for Meet a variety of demands-whether at a high level or at a very fine,ĭetailed level. “slice and dice” or reduce the volume of data for closer examination to High data throughput, and provide enough flexibility for end users to Data warehouse analysis looks at changeĪ well-designed data warehouse will perform queries very quickly, deliver Data warehouses create consistency amongĭifferent data types from disparate sources. Particular subject or functional area (such as sales). Warehouses to deliver this overarching benefit. Inmon, who is considered the father of the data warehouse) allow data
Significant value from it, as well as to keep a historical record.įour unique characteristics (described by computer scientist William
Organizations to analyze large amounts of variant data and extract Data warehouses offer the overarching and unique benefit of allowing