OIM 350 Exam 3
duck charts
"self promoting graphs"
time series
- Graphs where the X axis is time - Measures change(s) over that time
bivariate graphs
- two variables - typically scatterplots - useful for examining one-to-one relationships (correlations)
spatial graphs (maps)
Applying an overlay of data visualization where the location in space is important
faceting
Several distinct graphs arranged in a manner for comparison
transaction time
a column representing the time of the transaction
transaction identifier
a column representing the transaction ID
row indicator
a column that provides a quick indicator of whether the record is currently valid
dimensional modeling
a data design methodology used for designing subject-oriented analytical databases, i.e., data warehouses or data marts
normalized data warehouse
a data warehouse modeled by using the traditional database modeling techniques of ER modeling, relational modeling, and/or normalization, resulting in a normalized set of tables
slowly changing dimensions
a dimension that contains attributes whose values can change
detailed fact tables
a fact table in which each record refers to a single fact
line-item detailed fact table
a fact table in which each record represents a line item of a particular transaction
transaction-level detailed fact table
a fact table in which each row represents a particular transaction
surrogate key
a noncomposite system-generated key assigned to each dimension of a star schema
snowflake models
a star schema tat contains the dimensions that are normalized
type 2 approach
an approach to handling slowly changing dimensions that is used in cases when history should be preserved; it creates a new additional dimension record using a new value for the surrogate key every time a value in a dimension record changes
type 3 approach
an approach to handling slowly changing dimensions that is used in cases when there is a fixed number of changes possible per column of a dimension, or in cases when only a limited history is recorded; it creates a "previous" and "current" column in the dimension table, for each column where the changes are anticipated
degenerate dimension
an event identifier included within the fact table (rather than having its own separate dimension)
timestamps
columns in tables that indicate the time interval for which the values in the records are applicable
detailed data
data composed of single instances of data
aggregated data
data representing summarization of multiple instances of data
dimensionally modeled data warehouse
data warehouse modeled using dimensional modeling
granularity
describes what is depicted by one row in the fact table
aggregated fact tables
fact tables in which each record summarizes multiple facts
data-ink
ink that is used to convey data
star schema
schema containing fact tables and dimensions
conformed dimensions
standardized dimensions created before development of star schemas; typically used with multiple fact tables
constellation (galaxy) of stars
star schema containing multiple fact tables
Moiré Effects (Visual Vibrations)
static images appear to move (vibrate) when lines are too close to each other or overlap
dimension tables (dimensions)
tables in a dimensional model that contain descriptions of the business, organization, or enterprise to which the subject of analysis belongs and contain a primary key and attributes that are used for analysis of the measures in the fact tables
fact tables
tables in a dimensional model that contain measures related to the subject of analysis and foreign keys that connect the fact table to the dimension tables
type 1 approach
the approach to handling slowly changing dimensions based on overwriting values in records of dimension; it is used mostly when a change in a dimension is the result of an error