MINDMAPPED

Question 1

Optimization (robust vs non-robust)

Answer 1

Robust
stochastic
multiple parameter sets

not robust
deterministic
solution for one parameter set

Question 2

Data Analysis Types

Answer 2

descriptive

model driven

data driven

Question 3

Types of Analytics

Answer 3

Descriptive
Predictive
Prescriptive

Question 4

Forecast Data

Answer 4

Transaction
Controls
Auxiliary
Historical

Question 5

Estimation Objectives

Answer 5

unbiased
efficient
consistent

Question 6

Forecasting Methods

Answer 6

structural

time-series

Question 7

Steps of Business Intelligence

Answer 7

1 store in DBS
2 ETL into warehouse
3 analyze and present for BI

Question 8

Data Base System consists of

Answer 8

Data Base + Data Base Management System

Question 9

Tasks of Database Systems

Answer 9

Queries (interpret and optimize)

Access (parallel and rights)

Storing Data (consistency, back-ups, memory allocation)

Question 10

DBS
what data?
aggregation level?
ease of use?

Answer 10

operational, transactional
detailed
complex

Question 11

DWH
what data?
aggregation level?
ease of use?

Answer 11

strategic data (historical)
aggregate data
polished user interface

Question 12

Data Warehouse

Components

Answer 12

Data Marts
Central Data Warehouse
Enterprise Data Warehouse

Question 13

Data Marts

Answer 13

for user-specific analytics

Question 14

OLAP

Answer 14

access data warehouse

ad-hoc queries w/o technical expertise

Question 15

OLAP Cube dimensions

Answer 15

time period
area
product

Question 16

OLAP Cube Functions

Answer 16

drilling (up/down, through)
pivoting
slicing
dicing