Lesson 7 Flashcards
Business intelligence (BI)
A comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making.
cube cache
In multidimensional OLAP, the shared, reserved memory area where data cubes are held. Using the cube cache assists in speeding up data access.
dashboards
In business intelligence, a web-based system that presents key business performance indicators or information in a single, integrated view with clear and concise graphics.
data cube
The multidimensional data structure used to store and manipulate data in a multidimensional DBMS. The location of each data value in the data cube is based on its x-, y-, and z-axes. Data cubes are static, meaning they must be created before they are used, so they cannot be created by an ad hoc query.
data mart
A small, single-subject data warehouse subset that provides decision support to a small group of people.
data visualization
Abstracting data to provide information in a visual format that enhances the user’s ability to effectively comprehend the meaning of the data.
data warehouse
An integrated, subject-oriented, time-variant, nonvolatile collection of data in a specialized database that stores historical and aggregated data in a format that provides support for decision making.
decision support system (DSS)
An arrangement of computerized tools used to assist managerial decision making within a business.
dimension tables
In a data warehouse, tables used to search, filter, or classify facts within a star schema.
drill down
To decompose data into more atomic components—that is, data at lower levels of aggregation. This approach is used primarily in a decision support system to focus on specific geographic areas, business types, and so on.
What is the acronym ETL?
- Extraction
- Transformation
- Loading
ETL
- In a data warehousing environment, the integrated processes of getting data from original sources into the data warehouse.
- ETL includes retrieving data from original data sources (extraction), manipulating the data into an appropriate form (transformation), and storing the data in the data warehouse (loading).
governance
In business intelligence, the methods for controlling and monitoring business health and promoting consistent decision making.
key performance indicators (KPIs)
In business intelligence, quantifiable numeric or scale-based measurements that assess a company’s effectiveness or success in reaching strategic and operational goals. Examples of KPIs are product turnovers, sales by promotion, sales by employee, and earnings per share.
master data management (MDM)
In business intelligence, a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.
