Data warehousing


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