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 comprehensive knowledge in fundamental areas of software engineering.  X  
2. Has knowledge in the area of software requirements understanding process planning, output specification, resource planning, risk management and quality planning.   X 
3. Understands the interplay between theory and practice and the essential links between them.    X
4. Defines real life problems by identifying functional and non-functional requirements a software has to satisfy. X   
5. Overcomes technical or scientific software engineering problems on their own and is in a position to propose the most suitable solution; has good communication skills to explain the completeness of their solution and clearly state the assumptions that were made.   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. Identifies, evaluates, measures and manages changes in software development by applying software engineering processes.  X  
8. Understands the social, legal, ethical and cultural issues involved in the deployment and use of software engineering and conducts all occupational pursuits in an ethical and responsible manner. X   
9. Has good command of technical terms in both Turkish and English, where they have the ability to make succinct presentations (including face-to-face, written or electronic) to a range of audiences about technical/scientific problems and their solutions.   X 
10. Identifies and conducts research by applying scientific methods in order to solve scientific problems.     X

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