DATA WAREHOUSING — Winter 2021

What is data warehouse? Explain the need for building a data warehouse.

Differentiate between Primitive data and derived data.

What do you mean by data granularity? Explain the concerns of granularity in a data warehouse.

Draw and explain the data warehouse architecture

Explain various data structures found in a data warehouse in detail.

Write a short note on midlevel data model.

Explain the Normalization and De-Normalization in Data Warehouse design

Differentiate between data warehouse and transactional database.

What are profile records? Explain the concept of creating multiple profile records along with appropriate example

What is OLAP? Explain the Various operations of OLAP

Explain the relation between EIS and data warehouse in detail.

Explain the process of relating the structured and unstructured environments of data warehouse.

What is EIS? State the uses of EIS.

Discuss Unstructured Data with Proper example.

Explain Self Organized Map(SOM) also Discuss its Advantages

Explain two-tiered data warehouse in detail.

What is data visualization? Explain structured and unstructured data visualization in brief.