Glossary
- Attribute
Individual data element that is represented and stored in a dimension. Each attribute contains data relating to that dimension.
- Base fact
A fact that is physically stored in the data warehouse, in a fact table.
- Business dimension
The part of a business dimensionalmodel that diagrams the business abstraction of data elements or attributes used to describe the major categories of reference data, such as customer or product. The diagrams also show how these attributes relate to one another, including hierarchies, groupings, and drill paths. The business dimension reflects the business perspective regardless of the number of physical tables used to store the data. See also dimension.
- Business dimensionalmodel (BDM)
A data model that provides a business abstraction of the data needed to support reporting and analysis. The model shows diagrams of dimensions and facts so that the details can be reviewed and discussed in business terms. It also separates the business perspective from technical implementation details.
- Business intelligence (BI)
The collection of one or more reports or analyses, using data from the data warehouse, that provide insight into the performance of a business organization. These reports and analyses are typically interactive to enable further understanding of specific areas of interest. They are used to support business professionals in their decision-making processes.
- Business measures
The complete set of facts, base and derived, that are defined and made ...
Get A Manager's Guide to Data Warehousing now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
