Bi Unit 2 Flashcards
1
Q
Bi vs dw
A
2
Q
OLAP
A
3
Q
Tools in bi
A
4
Q
Need for business intelligence
A
5
Q
Difference b/w OLAP Vs OLTP
A
6
Q
Dimensional analysis
A
7
Q
What are cubes
A
8
Q
Drill-down and roll-up- slice and dice or rotation
A
9
Q
ROLAP Vs MOLAP
A
10
Q
Defining schemas….stars, snowflakes, and fact constellations
A
11
Q
Differentiate b/w star schema and snowflake schema
A
12
Q
Fact tables and dimension tables
A