Exam 1

Question 1

___ is an umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies.

Answer 1

BI

Question 2

______ is data that cannot be stored or processed easily using traditional tools/means.

Answer 2

Big data

Question 3

A(n) _____ is a major component of a BI system that holds source data.

Answer 3

Data Warehouse

Question 4

A(n)_____ is a major component of a BI system that is often browser based and often presents a portal or dashboard.

Answer 4

User Interface

Question 5

OLAP

Answer 5

Online Analytical Processing

Question 6

In Chapter 1our authors defined three types of business analytics. Identify the three types and the two questions typically answered by each of the three.

Answer 6

Descriptive - 
     What happened?
     Why is it happening?
Predictive -
     What will happen?
     why will it happen?
Prescriptive -
     What should i do?
     why should i do it?

Question 7

_____ statistics is about drawing conclusions about population based on sample data.

Answer 7

Inferential

Question 8

______ is used to charecterize the relationship between explanatory (input) and response (output) variables.

Answer 8

Regression

Question 9

_____ refers to the use of visual representations to explore, make sense of, and communicate data.

Answer 9

Data visualization

Question 10

the fundemental challenge of _____ design is to display all the required information on a single screen, clearly and without distraction, in manner that can be assimilated quickly

Answer 10

dashboard

Question 11

KPI

Answer 11

Key Preformance Indicator

Question 12

In chapter 2, our authors defined four main tasks in their summary of data preprocessing tasks and methods. First, briefly describe why data preprocessing is necessary and then identify the four main tasks.

Answer 12

real world data is dirty, misaligned, overly complex, and inaccurate.
     data:
          consolidation
          cleaning
          transforming
          reduction

Question 13

common features of a data warehouse

Answer 13

single version of truth
checked for quality
transaction system of Independence

Question 14

common features of the semantic model

Answer 14

inventory of data elements
common business names
pre-defined joins
standardized calculations

Question 15

common features of a presentation layer

Answer 15

multiple tools available
choose based on purpose
all point at same data

Question 16

ETL

Answer 16

Extract Transform Load

Question 17

A(n) _____ the most commonly used and simplest style of dimensional modeling, contains a fact table surrounded by an connected to several dimension tables.

Answer 17

Star Schema

Question 18

Star Schema

Answer 18

• most commonly used and the simplest style of dimensional modeling
• Contains fact table surrounded by and connected to several dimension tables

Question 19

briefly describe some of the defining characteristics of Kimbell’s data warehouse development approach:

Answer 19

Dimensional model/star-schema
incremental
high development difficulty

Question 20

_____ is the nontrivial process of identifying valid, novel, potentially useful, and ultimatly understandable patterned in data stored in structured databases

Answer 20

Data mining

Question 21

CRISP DM

Answer 21

Cross Industry Standard Process for Data Mining

Question 22

identify the three types of patterns used in data mining

Answer 22

assosiation
prediction
segmentation
sequential

Question 23

identify the 6 steps in the CRISP DM process

Answer 23

1. business understanding
2. data understanding
3. data preparation
4. model building
5. testing and evaluation
6. deployment