BBS654 - DATA WAREHOUSING and DATA MINING

Course Name Code Semester Theory
(hours/week)
Application
(hours/week)
Credit ECTS
DATA WAREHOUSING and DATA MINING BBS654 Any Semester/Year 3 0 3 6
Prequisites
Course languageTurkish
Course typeElective 
Mode of DeliveryFace-to-Face 
Learning and teaching strategiesLecture
Question and Answer
Drill and Practice
Problem Solving
Other: individual work  
Instructor (s)Prof. Dr. Murat Caner TESTÄ°K 
Course objectiveDevelop skills to find patterns and regularities in massive data sets and extract useful knowledge from raw data 
Learning outcomes
  1. Upon completion of this course, the students should be able to
  2. ? Define data types for variables
  3. ? Evaluate data quality and preprocess data
  4. ? Construct classification and regression trees and interpret the findings
  5. ? Apply cluster analysis and interpret the findings
  6. ? Determine association rules and interpret them
  7. ? Use a data mining software and interpret the output of the analysis
Course Content? Concepts of data mining
? Data preprocessing
? Principal components analysis
? Clustering
? Classification
? Prediction
? K-nearest neighbor algorithm
? Decision trees
? Artificial neural networks
? Association rules.
 
References? Tan, P.N., Steinbach, M., Kumar, V. (2006). Introduction to Data Mining, Addison Wesley.
? Larose, D.T. (2005). Discovering Knowledge in Data: An Introduction to Data Mining. Wiley Interscience.
? Shumeli, G., Patel, N.R., Bruce, P.C. (2012). Data Mining for Business Intelligence: Concepts, Techniques and Application in Microsoft Excel with XLMiner. E & B Plus.
 

Course outline weekly

WeeksTopics
Week 1Introduction to Data Mining
Week 2Types of Data/Data Quality
Week 3Data Preprocessing/Measures of Similarity
Week 4Exploring Data
Week 5Classification- Decision Trees
Week 6Classification- Decision Trees
Week 7Classification- Artificial Neural Network
Week 8Classification- Support Vector Machine
Week 9Midterm exam
Week 10Association Analysis
Week 11Multivariate Linear Regression
Week 12Cluster Analysis
Week 13Cluster Analysis
Week 14Project Presentations and Discussions
Week 15
Week 16Final exam

Assesment methods

Course activitiesNumberPercentage
Attendance00
Laboratory00
Application00
Field activities00
Specific practical training00
Assignments00
Presentation00
Project130
Seminar00
Midterms130
Final exam140
Total100
Percentage of semester activities contributing grade succes260
Percentage of final exam contributing grade succes140
Total100

WORKLOAD AND ECTS CALCULATION

Activities Number Duration (hour) Total Work Load
Course Duration (x14) 14 3 42
Laboratory 0 0 0
Application000
Specific practical training000
Field activities000
Study Hours Out of Class (Preliminary work, reinforcement, ect)12448
Presentation / Seminar Preparation155
Project14040
Homework assignment000
Midterms (Study duration)11616
Final Exam (Study duration) 12424
Total Workload3092175

Matrix Of The Course Learning Outcomes Versus Program Outcomes

D.9. Key Learning OutcomesContrubition level*
12345
1. Has detailed knowledge about Information Systems (IS).   X 
2. Understands the interaction of theory and practice and the links between them.   X 
3. Has a good understanding of common concepts such as abstraction, complexity, security, concurrency, software lifecycle and applies their expertise to the effective design, development and management of IS.    X
4. Has the ability to think at different levels of abstraction and detail; understands that an IS can be considered in different contexts, going beyond narrowly identifying implementation issues.    X
5. Solves any technical or scientific problem independently and presents the best possible solution; has the communication skills to clearly explain the completeness and assumptions of their solution.    X
6. Completes a project on a larger scale than an ordinary course project in order to acquire the skills necessary to work efficiently in a team.    X
7. Recognises that the field of informatics is rapidly evolving. Follows the latest developments, learns and develops skills throughout their career.    X
8. Recognises the social, legal, ethical and cultural issues related to informatics practice and conduct professional activities in accordance with these issues.    X
9. Can make oral presentations in English and Turkish to different audiences face-to-face, in writing or electronically.    X
10. Recognises that informatics has a wide range of applications and opportunities.    X
11. Is aware that informatics interacts with different fields, can communicate with experts from different fields and can learn necessary field knowledge from them.   X 
12. Define a research problem and use scientific methods to solve it.    X 

*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest