Bi Unit 2 Flashcards

1
Q

Bi vs dw

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

OLAP

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Tools in bi

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Need for business intelligence

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Difference b/w OLAP Vs OLTP

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Dimensional analysis

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are cubes

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Drill-down and roll-up- slice and dice or rotation

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

ROLAP Vs MOLAP

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Defining schemas….stars, snowflakes, and fact constellations

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Differentiate b/w star schema and snowflake schema

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Fact tables and dimension tables

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly