Abdallah II, 307
abstraction, 311
additive fact, 311
aggregate, 311
aggregated fact, 156
agile data warehousing, 22
analysis, 311
analytics, 11
architecture, 311
atomic data warehouse, 139–42
atomic stage, 135, 311
atomic warehouse, 311
attribute, 115–16, 128, 311
nominal, 110
ordinal, 110
qualitative, 110
quantitative, 110
balanced scorecard, 109, 264, 265, 267, 269, 279, 312
BAM. See business activity monitoring
Barry, Dave, 195
Batman, 285
BC. See business case
best of breed, 312
BI. See business intelligence
BICC. See business intelligence competency center
big data, 22
bridge table, 166, 312
BSC. See balanced scorecard
budgeting, 11, 23
business activity monitoring, 312
business architecture, 49–53, 312
business case, 26
business case development, 26
business intelligence, 11, 23, 312
assessing maturity of, 15–17
business intelligence competency center, 312
business process, 313
business user, 61
business value chain, 51
calculation engine, 262
candidate key, 313
canonical model, 313
cardinality, 314
Cass, Stephen, 279
CBA. See cost benefit analysis
CDC. See change data capture
CDI. See customer data integration
cell, 313
CEP. See complex event processing
change data capture, 313
class word, 106
Clemens, Roger, 247
cluster, 251, 293, 313
clustering, 255
code, 313
column based database, 22, 203
columnar database. See column based database
commercial off the shelf, 225
complex event processing, 313
conceptual data model, 112, 313
conformed dimension, 172, 313
constraint, 314
control group, 314
corporate performance management, 18
cost benefit analysis, 26
COTS. See commercial off the shelf
cumulative snapshot fact, 155
customer analysis, 298
customer data integration, 314
customer equity, 314
customer segmentation, 11, 23
dashboard, 270–71, 314
data, 110, 314
data architect, 314
data architecture, 73–79
data cleansing, 314
data custodian, 314
data dictionary, 182, 314
data element, 314
data exploration, 55
data governance, 175–79, 182, 314
data governance chair, 182
data governance council, 182
data integration, 211, 315
data integration competency center, 315
data lineage, 315
data map, 212
data mapping, 315
data mart, 80, 315
data mining, 11, 22, 236, 255, 315
descriptive, 255
predictive, 255
data model, 315
data modeler, 315
data modeling, 128
data modeling level, 111
data modeling tool, 111
data owner, 315
data partition, 315
data profiling, 191, 315
data quality management, 192, 316
data source, 316
data staging area, 143
data stakeholder, 316
data steward, 182, 316
data vault, 317
data visualization, 22
data warehouse, 14, 80, 82, 143, 316
data warehouse appliance, 204, 316
data warehouse architecture, 316
data warehouse bus, 172–73, 316
data warehouse modeler, 61
data warehouse system, 316
data warehouse technical stack, 100
data warehousing, 23
technology stack, 93
data warehousing appliances, 22
data warehousing business intelligence, 26
data warehousing enterprise architecture, 22
decision tree, 251, 255
definition, 317
degenerate dimension, 167, 317
delta stage, 133–35
Deming, W. Edwards, 101
denormalization, 317
descriptive data mining, 250
DG. See data governance
DICC. See data integration competency center
dice, 317
dicing, 231
dimension, 174, 317
conformed, 174
degenerate, 167, 317
hierarchy helper, 318
junk, 168, 319
outlier, 321
profile, 167
slowly changing, 159, 174, 323
dimensional data modeling, 146
DQM. See data quality management
Dreyfuss, Henry, 111
drill down, 229, 231, 317
Drucker, Peter, 175
DWBI. See data warehousing business intelligence
EAI. See enterprise application integration
EDW. See enterprise data warehousing
EII. See enterprise information integration
enterprise application integration, 317
enterprise data warehousing, 14
enterprise information integration, 78, 317
entity, 113–15, 128, 317
ETL. See extract, transform, and load
executive sponsor, 61
extract, transform and load, 78
extract, transform, and load, 318
extracting, 318
fact, 174, 318
factless fact, 156, 318
federated data warehouse, 173, 318
federated database, 22, 201
field aggregation, 318
foreign key, 318
functional requirement, 58, 70, 318
generalization, 120–21
grain, 151, 318
granularity, 318
grey data, 192, 318
Hadoop, 200
heat map, 52
hierarchy, 318
hierarchy helper dimension, 318
highly summarized data, 319
Holmes, Sherlock, 257
IEEE Spectrum, 279
ILM. See information lifecycle management
IMDB. See in memory database
Imhoff, Claudia, 129
in memory database, 22, 202
industry data model, 113, 128
information, 319
information lifecycle management, 319
Inmon, Bill, 14
instrumentation, 319
junk dimension, 168, 319
key, 128, 319
key performance indicator, 52, 58, 108, 319
Kimball, Ralph, 145
knowledge, 319
KPI. See Key Performance Indicator
landing stage, 319
Landre, Einar, 69
lightly summarized data, 320
loading, 319
logical data model, 112, 319
logical key, 319
Lombardi, Vince, 227, 263
mapping, 320
market basket analysis, 250
master data management, 320
materialized view, 320
MBA. See market basket analysis
MDM. See master data management
measure, 320
measures of central tendency, 246
measures of dispersion, 246
metadata, 100, 143, 179, 182, 320
metadata repository, 182, 320
metric, 52, 320
mobile computing, 22
modifier word, 106
MOLAP. See multi-dimensional online analytical processing
molap cube, 320
MonetDB, 203
multi-dimensional online analytical processing, 320
natural key, 320
net promoter score, 296
neural net, 252, 255
next best action, 320
non-functional requirement, 57, 59, 70
normalization, 122–25, 128, 321
NPS. See net promoter score
ODS. See operational data store
OLAP database, 206
operational data store, 321
optimization analytics, 321
outlier dimension, 321
pattern, 321
performance management, 321
performance measurement, 321
physical data model, 112, 321
pivot, 230, 321
POC. See proof of concept
power user, 322
predictive analytics, 22, 322
predictive data mining, 249–50
prescriptive analytics, 22
prime word, 106
probability, 246
product mix analysis, 11, 23
profile dimension, 167
project plan, 322
project roadmap, 35, 322
proof of concept, 55
prototype, 47
R, 22
range, 246
recency, frequency and monetary analysis, 298
recommendation engine, 322
reference architecture, 322
regression model, 246, 322
regression modeling, 11
relational database, 195
relational on-line analytical processing, 322
relationship, 116–20, 128
report, 322
requirements traceability matrix, 300
RFM. See recency, frequency and monetary analysis
Robertson, James, 49
Robertson, Suzanne, 49
ROLAP. See relational on-line analytical processing
roll up, 228, 231, 322
RTM. See requirements traceability matrix
samples, 246
SCD. See slowly changing dimension
SCD Type 0, 323
SCD Type 1, 323
SCD Type 2, 323
SCD Type 3, 323
scenario engine, 262
score, 323
scorecard, 265–69, 323
scribe, 61
scrum, 323
SCV. See single customer view
semi-additive fact, 323
Senge, Peter, 25
session leader facilitator, 61
single customer view, 285, 298
single version of the truth, 29
slice and dice, 228, 323
slicing, 231
slowly changing dimension, 159, 323
SMART. See specific, measurable, assignable, realistic and time-based
SME. See subject matter expert
snapshot fact, 154, 323
snowflake schema, 163, 324
SOR. See system of record
source system, 324
specialization. See generalization
specific, measurable, assignable, realistic and time-based, 45
standard deviation, 246
star schema, 147–50, 174, 324
statistical analysis, 11
statistician, 246
statistics, 324
descriptive, 246
inferential, 246
storage tier, 324
subject matter expert, 55, 212
subtyping. See generalization
supertyping. See generalization
surrogate key, 324
Sybase IQ, 204
system of record, 187
target, 52, 324
technical architecture
architecture roadmap, 73
technical architecture principles, 79–80
total product line, 312
Twain, Mark, 237
user manager, 61
variance, 246
variance from plan, 324
virtual database, 22
WBS. See work breakdown structure
Welch, Jack, 11
wireframe design, 324
wisdom, 324
work breakdown structure, 37
work package plan, 36