These tools copy data from place to place and also scrub and clean the data.
#DESCRIPTION OF EACH FACT IN ADVENTUREWORKS2012 DW SOFTWARE#
It is meant to help youīetter understand the content and quality of the data.ĮTL (extract, transfer & load) tools, as well as realtime integration tools like the ESB (enterprise service bus) software tools. This tool accesses the data and explores it, looking for patterns such as typical values, outlying values, ranges, and allowed values. This tool provides a detailed design capability that includes the design of tables, columns, relationships, rules, and business definitions.Ī software tool that supports understanding data through exploration and comparison. Here are the two kinds of metadata: business metadata and technical metadata.Ī software tool that enables the design of data and databases through graphical means.
The data warehouse's technical architecture includes data sources, data integration, BI/analytics data stores, and data access.Ī software tool that contains data that describes other data. Transactional data that is managed in application data stores will not reside in a data warehouse.
A data warehouse does not only consist of historic data - it can be made up of analytics and reporting data, too. "Data warehouse," by the way, is not another name for "database." Some people incorrectly use the term "data warehouse" as if it's a generic name for a database. It does not, however, contain original data. This data is often obtained from multiple data sources and is useful for strategic decision-making. What a Data Warehouse is and is NotĪ data warehouse is a database whose data includes a copy of operational data.
See the book The Analytical Puzzle: Profitable Data Warehousing, Business Intelligence and Analytics (ISBN 978-1935504207) for details. Inmon has provided an alternate and useful definition of a data warehouse: "A subject-oriented, integrated, time-variant, and nonvolatile collection of data in support of management's decision-making process."Īs a total architecture, data warehousing involves people, processes, and technologies to achieve the goal of providing decision-support data that is consistent, integrated, standardized, and easy to understand. A data warehouse is one of the artifacts created in the data warehousing process. Data warehousing is a broad subject that is described point-by-point in this Refcard. Data warehousing is a process for collecting, storing, and delivering decision-support data for some or all of an enterprise.