IT 274

Data Warehousing and Data Mining

TU BIM · Semester 7 · BIM curriculum effective from 2021

Requirement
elective
Credits
3
Syllabus
4 sections

Syllabus

What this course covers and how the teaching time is divided.

course syllabus loaded.

Data Warehousing and Data Mining Syllabus

Official TU PDF

Tribhuvan University

Faculty of Management

Office of the Dean

Bachelor of Information Management (BIM)

Course Title: Data Warehousing and Data Mining

Course Code: IT 274

Semester: Semester 7

Nature of Course: elective

Full Marks: 100

Pass Marks: 50

Credit Hours: 3 Cr.

Curriculum: BIM curriculum effective from 2021

Course Objective

:

The main objective of this course is to provide knowledge of different concepts of data ware housing and data mining to students. After completing this course, students will be able to

  • Understand different concepts of data warehousing and data mining.
  • Learn to design and use data warehouses and OLAP.
  • Know and apply pattern mining algorithms.
  • Understand and use classification and clustering algorithms.
  • Learn outlier detection and related algorithms.

Course Description

:

This course covers different concepts of data warehousing and data mining including data mining, data warehousing and OLAP, and different concepts and algorithms of pattern mining, classification, clustering and outlier detection.

Course Contents:

Lecture hours show the approximate classroom time allocated to each unit.

Unit 1.Introduction

6 hours
  • Data Mining and Knowledge Discovery
  • Mining Various Kinds of Knowledge
  • Data Mining Applications
  • Data Types
  • Statistics of Data
  • Similarity and Distance Measures
  • Data Quality, Data Cleaning, and Data Integration
  • Data Transformation
  • Dimensionality Reduction

Unit 2.Data Warehousing and Online Analytical Processing

8 hours
  • Data Warehouse
  • Data Warehouse Modeling: Schema and Measures
  • OLAP Operations
  • Data Cube Computation
  • Data Cube Computation Methods

Unit 3.Pattern Mining

5 hours
  • Basic Concepts
  • Frequent Itemsets, Closed Itemsets, and Association Rules
  • Frequent Itemset Mining Methods: Apriori and Pattern -Growth Approach
  • Generating Association Rules from Frequent Itemsets
  • Pattern Evaluation Methods

Unit 4.Classification

12 hours
  • Basic Concepts
  • Decision Tree Induction
  • Bayes Classification Methods
  • Lazy Learners
  • Linear Classifiers
  • Model Evaluation and Selection
  • Techniques to Improve Classification Accuracy

Unit 5.Cluster Analysis

10 hours
  • Cluster Analysis
  • Partitioning Methods (k-Means, k-Mediods and k-Modes)
  • Hierarchical Methods (Agglomerative and Divisive)
  • Desisty -Based (DBSCAN)
  • Evaluation of Clustering

Unit 6.Outlier Detection

7 hours
  • Basic Concepts
  • Statistical Approaches
  • Proximity -Based Approaches
  • Reconstruction - Based Approaches
  • Clustering-Based Approaches
  • Classification-Based Approaches Laboratory Works: The laboratory work includes implementing data warehouse and algorithms for pattern -miming, classification, clustering and outlier detection using any appropriate programming language. Students should also learn to use visualization tools during implementation of these algorithms.

Suggested Readings:

  1. Jiawei Han, Jian Pei, and Hanghang Tong, Data Mining Concepts and Techniques, 4th Edition, Morgan Kaufmann, 2023.