GASTRONOMY (TURKISH)
Bachelor TR-NQF-HE: Level 6 QF-EHEA: First Cycle EQF-LLL: Level 6

Course Introduction and Application Information

Course Code Course Name Semester Theoretical Practical Credit ECTS
COP4408 OBASE Business Intelligence Fall 3 0 3 5
This catalog is for information purposes. Course status is determined by the relevant department at the beginning of semester.

Basic information

Language of instruction: English
Type of course: Non-Departmental Elective
Course Level: Bachelor’s Degree (First Cycle)
Mode of Delivery: Face to face
Course Coordinator : Prof. Dr. ADEM KARAHOCA
Course Lecturer(s): Prof. Dr. ADEM KARAHOCA
Recommended Optional Program Components: None
Course Objectives: The course provides the student with an introduction to the basic and more advanced concepts of Business Intelligence and discusses the architectures of possible solutions.

Learning Outcomes

The students who have succeeded in this course;
1. Define basic concepts and categories of business intelligence and business intelligence market
2. Describe data warehouse architectures
3. Define relational models, construct normalized data models and identify queries to data sources with SQL.
4. Discuss case studies in terms of business intelligence concepts
5. Specify data mining and clustering methods
6. Describe neural networks
7. Define decision trees
8. Identify business intelligence front end applications
9. Prepare project presentations

Course Content

Concepts of business intelligence, data warehousing, rdbms concepts, modeling the dimensions and creating the aggregations, panel - case studies, introduction to data mining unsupervised methods, supervised methods, business intelligence front end

Weekly Detailed Course Contents

Week Subject Related Preparation
1) Introduction to Business Intelligence
2) Data Warehousing
3) RDBMS Concepts I
4) RDBMS Concepts II
5) Modeling the Dimensions and Creating the Aggregations
6) Modeling the Dimensions and Creating the Aggregations
7) Panel - Case Study: Migros
8) Introduction to Data Mining Unsupervised Methods
9) Introduction to Data Mining Unsupervised Methods
10) Supervised Methods
11) Supervised Methods
12) Business Intelligence Front End
13) Project Presentations
14) Panel – Case Study: Turkcell

Sources

Course Notes / Textbooks: Corporate Information Factory, W. H. Inmon, Claudia Imhoff, Ryan Sousa, 2001, 0471399612

Business intelligence : a managerial approach, E. Turban, R. Sharda, J.E. Arnsson, D. King, 2007, 013234761X

The Data Warehouse Toolkit, R. Kimball, M. Ross, 1996, 0471153370
References: Yok

Evaluation System

Semester Requirements Number of Activities Level of Contribution
Attendance 1 % 10
Project 1 % 35
Midterms 1 % 15
Final 1 % 40
Total % 100
PERCENTAGE OF SEMESTER WORK % 25
PERCENTAGE OF FINAL WORK % 75
Total % 100

ECTS / Workload Table

Activities Number of Activities Duration (Hours) Workload
Course Hours 14 3 42
Study Hours Out of Class 3 5 15
Project 1 20 20
Midterms 1 18 18
Final 1 20 20
Total Workload 115

Contribution of Learning Outcomes to Programme Outcomes

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution
1) - Possess advanced level theoretical and practical knowledge supported by textbooks with updated information, practice equipments and other resources.
2) Use of advanced theoretical and practical knowledge within the field. -Interpret and evaluate data, define and analyze problems, develop solutions based on research and proofs by using acquired advanced knowledge and skills within the field.
3) Inform people and institutions, transfer ideas and solution proposals to problems in written and orally on issues in the field. - Share the ideas and solution proposals to problems on issues in the field with professionals and non-professionals by the support of qualitative and quantitative data. -Organize and implement project and activities for social environment with a sense of social responsibility. -Monitor the developments in the field and communicate with peers by using a foreign language at least at a level of European Language Portfolio B1 General Level. -Use informatics and communication technologies with at least a minimum level of European Computer Driving License Advanced Level software knowledge.
4) Evaluate the knowledge and skills acquired at an advanced level in the field with a critical approach. -Determine learning needs and direct the learning. -Develop positive attitude towards lifelong learning.
5) Act in accordance with social, scientific, cultural and ethic values on the stages of gathering, implementation and release of the results of data related to the field. - Possess sufficient consciousness about the issues of universality of social rights, social justice, quality, cultural values and also, environmental protection, worker's health and security.
6) Conduct studies at an advanced level in the field independently. - Take responsibility both as a team member and individually in order to solve unexpected complex problems faced within the implementations in the field. - Planning and managing activities towards the development of subordinates in the framework of a project