Data warehousing Contents
1. Basic concepts of data
warehousing
2. What is data
warehousing
3. Why do we need a data
warehousing
4. Characteristics of data
warehousing
5. Architecture of data
warehousing
6. Approaches to build a
data warehouse
7. OLTP vs OLAP
8. Dimension and fact tables
9. Types of dimension and
fact tables and their role in the data ware house
10. SCD with their types and
importance.
11. Different type of Schemas
with examples
12. ETL process and data flow
13. Dimensional modelling and
design process to build the same with a real time example (retail sales)
which includes case study,dimension table attributes,schema in action surrogate
keys and market basket analysis
No comments:
Post a Comment