Accessing Organizational Information - Data Warehouse Flashcards
repository
A central location in which data is stored and managed.
data warehouse
A logical collection of information—gathered from many different operational databases—that supports business analysis activities and decision-making tasks.
extraction, transformation, and loading (ETL)
A process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse.
data mart
Contains a subset of data warehouse information.
dirty data
Erroneous or flawed data.
information cleansing or scrubbing
A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.
data point
An individual item on a graph or a chart.
data broker
A business that collects personal information about consumers and sells that information to other organizations.
data lake
A storage repository that holds a vast amount of raw data in its native format until it is needed.
source data
Identifies the primary location where data is collected.
data set
An organized collection of data.
comparative analysis
Compares two or more data sets to identify patterns and trends.
data-driven decision management
An approach to business governance that values decisions that can be backed up with verifiable data.
competitive monitoring
A company keeps tabs of its competitor’s activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.
data map
A technique for establishing a match, or balance, between the source data and the target data warehouse.
