School of Business and Economics

Course Title: Data Warehouse and Mining

Course Code:
Resource Person:
Department: Information Systems

SBE Vision
SBE envisions its success in the sustainable contribution that it will make to the industry, academia and research in
public and private sector. SBE will lead by providing professionally competent and ethically conscious human
resources engaged in the global and local context to foster socio-economic growth and sustainability for the society.
SBE envisages having faculty with high research potential and a deep desire for cutting edge research including
collaboration with national and international partners.

SBE Mission
Being a research-oriented and student-centric business school, we emphasize research publications in impact journals
as well as state-of -the-art learning methodologies.  We will prepare our students to become the future ethical business
leaders and the guiding post for the society, while equipping them with the knowledge and skills required by world-
class professionals.  We will be the leading choice for organizations seeking highly talented human resource. SBE
will foster internationalization with key stakeholders and actively work to exchange best practices with business
schools across Pakistan through collaborations, workshops, conferences and other means.

Program Objectives
BBIS aims provide students clout on best use of Information Systems for cutting the cost, time and resources in order
to amplify the revenue by restructuring the business processes and by engaging conceptual, analytical and managerial
competencies transformed by outcome based learning experience.

Course Objectives
A data warehouse is used for the purpose of providing and analyzing information from a number of sources including
inside as well as outside of the organization. The course introduces students to the terms and architecture of data
warehousing, dimensional modeling, data sources, Extract-Transform-Load (ETL) processes and subsystems, and
schemas. Moreover Online Analytical Processing (OLAP) and Online Transactional Processing (OLTP) will also be

Course Outline Page 1

discussed. A few case studies will be used to help students understand the importance as well the implementation of
data warehouses in a corporate environment

Learning Objectives
1. Introduction to the concepts and techniques of data warehousing
2. Help understand the Extract-Transform-Load process.
3. Understand how OLAP and OLTP work
4. Data mining and concepts

Learning Outcomes
1. Students will get familiar with the dynamics and functionality of a data warehouse as well as how it performs
in the corporate environment.
2. Students will understand how the ETL process works which includes the requirements and the subsystems
3. Students will understand the dynamics and functionalities of OLAP and OLTP and the purposes they serve in
the real world.
4. Students will learn about data mining concepts as well as the process, clustering, classification and
association rules, as well as text and web mining

Teaching Methodology (List methodologies used –example are given below)

Interactive Classes
Case based teaching
Class activities
Applied Projects
Experiential Learning

STUDENTS ARE REQUIRED TO READ AND UNDERSTAND ALL ITEMS

OUTLINED IN THE PARTICIPANT HANDBOOK
Class Policy:-
 Be On Time
You need to be at class at the assigned time. After 10 minutes past the assigned time, you will be marked
absent.

 Mobile Policy
TURN OFF YOUR MOBILE PHONE! It is unprofessional to be texting or otherwise.

 Email Policy
READ YOUR EMAILS! You are responsible if you miss a deadline because you did not read your email.
Participants should regularly check their university emails accounts regularly and respond accordingly.

 Class Attendance Policy

A minimum of 80% attendance is required for a participant to be eligible to sit in the final examination. Being
sick and going to weddings are absences and will not be counted as present. You have the opportunity to use
6 absences out of 30 classes. Participants with less than 80% of attendance in a course will be given grade ‘F’

Course Outline Page 2

 (Fail) and will not be allowed to take end term exams. International students who will be leaving for visa
during semester should not use any days off except for visa trip. Otherwise they could reach short attendance.

 Withdraw Policy

Students may withdraw from a course till the end of the 12th week of the semester. Consequently, grade W
will be awarded to the student which shall have no impact on the calculation of the GPA of the student.A
Student withdrawing after the 12th week shall be automatically awarded “F” grade which shall count in the
GPA.

 Moodle
UMT –LMS (Moodle) is an Open Source Course Management System (CMS), also known as a learning
Management System (LMS). Participants should regularly visit the course website on MOODLE Course
Management system, and fully benefit from its capabilities. If you are facing any problem using moodle, visit
http://oit.umt.edu.pk/moodle. For further query send your queries to moodle@umt.edu.pk

 Harassment Policy
Sexual or any other harassment is prohibited and is constituted as punishable offence. Sexual or any other
harassment of any participant will not be tolerated. All actions categorized as sexual or any other harassment
when done physically or verbally would also be considered as sexual harassment when done using electronic
media such as computers, mobiles, internet, emails etc.

 Use of Unfair Means/Honesty Policy

Any participant found using unfair means or assisting another participant during a class test/quiz, assignments
or examination would be liable to disciplinary action.

 Plagiarism Policy

All students are required to attach a “Turnitin” report on every assignment, big or small. Any student who
attempts to bypass “Turnitin” will receive “F” grade which will count towards the CGPA. The participants
submit the plagiarism report to the resource person with every assignment, report, project, thesis etc. If
student attempts to cheat “Turnitin”, he/she will receive a second “F” that will count towards the CGPA.
There are special rules on plagiarism for final reports etc. all outlined in your handbook.

 Communication of Results

The results of quizzes, midterms and assignments are communicated to the participants during the semester
and answer books are returned to them. It is the responsibility of the course instructor to keep the participants
informed about his/her progress during the semester. The course instructor will inform a participant at least
one week before the final examination related to his or her performance in the course.

Course Outline Page 3

 Course Outline
Course code……..... Course title…… Data Warehouse and Mining ……

BBIS
Program

3
Credit Hours
15 weeks
Duration

Prerequisites (If any)

Resource Person
Name and Email

Counseling Timing

(Room# )

Contact no.

Web Links:-
(Face book, Linked In,
Google Groups, Other
platforms)

Chairman/Director Programme signature………………………………….Date……………………..

Dean’s signature………………………… ………………….Date………………………………………….

Course Outline Page 4

Grade Evaluation Criteria
Following is the criteria for the distribution of marks to evaluate final grade in a semester.

Marks Evaluation Marks in percentage

Quizzes 10%
Assignments
Mid Term 20%
Attendance & Class Participation 25%
Term Project
Presentations 15%
Final exam 30%
Total 100

Recommended Text Books:

The Data Warehouse Toolkit, Third Edition, Ralph Kimball, Margy Ross, 2014

Reference Books:

1. Data Warehousing, Reema Thareja, 2009

2. Handouts

Course Outline Page 5

 Course: - Data Warehouse and Mining -Course code: ------- ------------Book: ------------------------------------

Topics to be
Deadlines
covered in the Learning Objective Teaching Assessment
No Expected Outcomes from Students and
course of this topic Method Criteria
Homework
Introduction, Introduction of data warehouses, and
general differences and limitation of Assign. / Within a
Gather requirements for data Presentation /
1 information and Operational Databases, differences Quiz / Surprise Week
warehousing White Board
key terms of the between OLAP and OLTP and Questions
subject. schema types of Data Warehouses

Assign. /
Quiz / Surprise
Questions. A
final project
will be
Dimensional Understanding the four components of
assigned to Within a
modeling and a data warehouse environment. A case Presentation /
2 Explain data warehouse architecture students at Week
architecture and study will be done to help understand White Board
this point.
case study fact table and dimensional modeling
This project
will be due in
second last
week of the
semester.

Steps in dimensional design process.

Dimensional Assign. / Within a
Introduction of Star schema, Fact-less Presentation /
3 modeling and case Explain data warehouse architecture Quiz / Surprise Week
fact table, degenerate dimensions, White Board
study Questions
snowflaking and surrogate keys.

Implications of value chain, periodic

Value chains, fact snapshots, semi-additive facts, Bus Assign. / Within a
Design a dimensional model for data Presentation /
4 tables, and matrix, Role playing, Junk Quiz / Surprise Week
warehousing White Board
dimensions. dimensions, outrigger and mini- Questions
dimensions and grain of fact tables.

5 Role playing, Junk Understanding the concepts of Role Design a dimensional model for data Presentation / Assign. / Within a

Course Outline Page 6

 playing, Junk dimensions outrigger
dimensions,
and mini-dimensions. The grain of
outrigger and mini- Quiz / Surprise Week
fact tables will also be discussed in- warehousing White Board
dimensions and Questions
depth because of its importance with
grain of fact tables
the final assignment.

Students will complete a Case study Design a physical model for data Assign. / Within a
Presentation /
6 Case Study (To better understand how to do the warehousing  Comprehend extract, Quiz / Surprise Week
White Board
final project) transform and load strategies Questions

10 requirements for ETL, process

ETL requirements, Design a physical model for data Assign. / Within a
steps and sub-systems 1-3 Extracting Presentation /
7 process steps, and warehousing  Comprehend extract, Quiz / Surprise Week
process, and 4-8 Cleaning and White Board
subsystems. transform and load strategies Questions
conforming process

Sub-systems 9-21 the cleaning and Comprehend extract, transform and Assign. /
Presentation / Within a
ETL sub-systems conforming process, sub-system 21-34 load strategies  Identify Online Quiz / Surprise
8 White Board Week
supporting the management Analytical Processing (OLAP) Questions
databases
Purpose of OLAP, relationship
between OLAP and data warehousing, Comprehend extract, transform and Assign. /
Presentation / Within a
OLAP representing multi-dimensional data, load strategies  Identify Online Quiz / Surprise
9 White Board Week
categories and comparisons of OLAP Analytical Processing (OLAP) Questions
tools. databases

Identify Online Analytical Assign. /

OLAP with Main categories of OLAP tools, Presentation / Within a
Processing (OLAP) databases  Quiz / Surprise
10 extensions in SQL OLAP extensions in SQL, White Board Week
Design and develop business Questions
intelligence applications
Data mining and its applications, Identify Online Analytical Assign. /
Introduction to Presentation / Within a
decision trees, classification, Processing (OLAP) databases  Quiz / Surprise
11 data mining White Board Week
assosciation, the data mining process Design and develop business Questions
intelligence applications
Introduction to
Data mining and its Neural networks, supervised v Assign. / Within a
Design and develop business Presentation /
12 applications – unsupervised learning, k-means Quiz / Surprise Week
intelligence applications White Board
Classification and clustering, MLP. Questions
clustering

Course Outline Page 7

 What kinds of
K-means algorithm, categories of Assign. / Within a
patterns can be Expand and support a data Presentation /
13 clustering, confidence and support, the Quiz / Surprise Week
mined? Clustering warehouse White Board
aprori algorithm, data mining myths Questions
and assosciation

Text and web mining concepts,

Assign. /
Text and Web Application area and process, NLP, Expand and support a data Presentation /
14 Quiz / Surprise
minig Web-content and web structure warehouse White Board
Questions
mining.

Concept of Data Warehouse Ethics,

Its Vales, Ethics Standards, Important
Commands

Exploring Sustainability through Data Documentary & Class discussion Class Within a
Ethics & Discussion
15 Warehouse , Areas of computing that Participatio Week
Sustainability Hall
are relevant to n
sustainability(Computer Cyber
physical System, Intelligent System,
Mobile Computing)

Final project
16 Final project presentation Presentation
presentation

Course Outline Page 8