B.Sc. (Data Science) Data Warehousing Syllabus - Mumbai University
This is the SY BSc Data Science syllabus under NEP 2020, in force from the academic year 2025-26. The University still sets the earlier Choice Based papers alongside it for ATKT candidates, so check which scheme your exam form names before you revise.
Loading syllabus...
Syllabus for Data Warehousing
Module I: Evolution of Decision Support System
- Need for Strategic Information System, Failures of Past Decision Support Systems, Operational Database vs Decision Support System, Data Warehouse defined, The Data Warehousing Movement, Evolution of Business Intelligence.
- Data Warehousing:
- Need for Data Warehouse, Features of data Warehouse, Data Warehouse Components, Data Warehouse Architecture, Approaches of Data Warehouse Design, Properties of Data Warehouse, Types of Data Warehouse Architecture, Differences between Operational Database Systems and Data Warehouses.
Module II: Data Warehouse Processing
- ETL in Data Warehousing, ETL vs ELT, Introduction to OLAP, Characteristics of OLAP, OLTP vs OLAP, OLAP Operations, Types of OLAP, Role of Metadata, Data Marts.
- Data Warehouse Modeling:
- Conceptual Modelling of Data Warehouse, Dimensional Modelling, Star Schema, Snowflake Schema, Dimensional Tables, Multi- Dimensional Data Modelling
Textbooks
- 1 Data Warehousing and Mining by Dr. Arti Deshpande & Dr, Pallavi Halarnkaer, published by TechKnowledge.
- 1 Data warehousing fundamentals for it professionals by Paulraj Ponniah, A John wiley & sons, inc., publication
- 2 Building the data warehouse by William h. Inmon, Wiley publishing, inc.
Reproduced from the University of Mumbai syllabus for B.Sc. (Data Science) under NEP 2020, in force from the academic year 2025-26. Wording is as printed in that syllabus. Module numbering is as printed there too.
The complete syllabus
This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.