ITEC79 (Ma'am Karen) Flashcards
is composed of individual discreet facts that collect
descriptive, quantitative, and qualitative value of business
interests.
Data
produced by corporate
applications, such as the one used to fill customer orders
for its products or the one used to manage financial
transactions.
Run-the-Business Data
built to improve the quality
of and synchronize two or more applications, such as a
master list of customers.
Integrate-the-Business Data
presented to end users for
reporting and decision support, such as financial
dashboards.
Monitor-the-Business Data
is an organized collection of data presented
in a specific and meaningful way
Information
it encompasses the familiarity, awareness,
understanding, and perceptions of a person about a given
subject
Knowledge
is the process of doing something
Action
is a subject-oriented, integrated, non-
volatile, time-variant collection of data in support of management’s decisions.
- is a powerful database model that
significantly enhances the user’s ability to quickly analyze
large, multidimensional data sets. It cleanses and
organizes data to allow users to make business decisions
based on facts.
◼ is a collection of integrated, subject
oriented databases designed to support the decision
support function where each unit of data is relevant to
some moment of time.
data warehouse
refers to de-duplicating information and
merging it from many sources into one consistent definition
Integrated Data
is a way of storing data and creating information through
leveraging data marts.
Data Warehousing
are segments or categories
of information and/or data that are grouped together to provide
insights into that segment or category.
Data Mart
is the leveraging of a data warehouse to help make business
decisions and recommendations.
◼ Business Analytics
A system that keeps track of an organization’s daily
transactions and updates the warehouse at periodic intervals
On-Line Transaction Processing
A technology that uses a multi-dimensional view of aggregate
data to provide quick access to strategic information for further
analysis
Enables end-users to perform ad-hoc analysis of data in
multiple dimensions, thereby providing the insight and
understanding they need for better decision making
OLAP: On-Line Analytical Processing
A subject-oriented, integrated, volatile, current-valued data
store containing only corporate detailed data
ODS: Operational Data Store
of a data warehouse can
be legacy data sources,
is either pushed or pulled
into the landing area in a pre-determined
format from respective source systems.
Source Systems
is a volatile intermediate
area for operational data before
transformation takes place.
Landing Area
is a place where you
hold temporary tables on the data
warehouse server.
Staging Area
is defined as standardizing and
consolidating customer and/or business
data.
Data quality
is
a set of software design patterns
used to determine the data that
has changed in a database so that
action can be taken on the
changed data.
-occur mostly in data
warehouse environments
Change Data Capture (CDC)
This involves analysis of metadata and
data values, and detection of
differences between defined and
inferred properties.
Analyze the Data
is a process to assess
current data conditions, or to monitor
data quality over time. It begins with
collecting measurements about data,
and then looking at the results
individually and in various combinations
to see where anomalies exits.
Profile the Data / Data profiling
is the act of detecting and
correcting (or removing) corrupt or
inaccurate records from a record set,
table, or database.
Cleanse the Data / Data cleansing
This involves integration and
consolidation of data from various
source systems to form a single system
of record.
Integrate the Data
