Business Intelligence Flashcards
central repository of information, queryable source of of data for enterprise, used for analysis and not transaction processing, data in a ??? ??? is nonvolatile, is target location for integrating data from external / internal sources to an enterprise. Is arranged around relevant subject areas important to corp. as a whole.
data warehouse
expose in greater detail
drill down
dimensions of data analyzed in ??? are arranged in cube structure (hypercube).
OLAP
assemble infrastructure needed for aggregating the raw data sets and for app of the transformation to be forwarded to data warehouse, usually combo of hardware / management software known as staging area.
ETL (Extraction Stage)
data type conversion, data cleansing, integration, referential integrity check, derivations, aggregation, audit information, null conversion.
ETL (Transformation Stage)
based on continuous improvement of business process driven by discovery of actionable knowledge and taking action.
Virtuous Cycle
when we already have the problem we want to solve and apply data mining methods to discover relationship between variables under scrutiny in terms of other available variables.
directed knowledge
using data mining techniques to find interesting patterns w/in data set as way to highlight some potentially interesting issue.
undirected knowledge
examining attributes of object and assigning it to a defined class.
Classification
assigning some continuously valued numeric value to an object.
Estimation