COP4408 OBASE Business IntelligenceBahçeşehir UniversityDegree Programs FILM AND TELEVISIONGeneral Information For StudentsDiploma SupplementErasmus Policy StatementNational QualificationsBologna Commission
FILM AND TELEVISION
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) Being familiar to the main concepts and methods of the social sciences and the fine arts devoted to understanding the world and the society 4
2) Having comprehensive knowledge regarding different media and branches of art 3
3) Knowing the historical background of audio-visual moving images in the world and in Turkey and keeping pace with the new developments in the area 1
4) Having a good command of the language and the aesthetics of audio-visual moving images in the world and in Turkey 1
5) Being able to create a narrative that could be used in a fiction or a non-fiction audio-visual moving image product 2
6) Being able to write a script ready to be shot 2
7) Having the skills to produce the photoboard of a script in hand and to shoot the film using the camera, the lights and other necessary equipment
8) Being able to transfer the footage of a film to the digital medium, to edit and do other post-production operations
9) Being able to create a documentary audio visual moving image from the preliminary sketch stage to shooting, editing and post-production stages
10) Being able to produce an audio visual moving image for television and audio products for radio from preliminary stages through shooting and editing to the post-production stage
11) Being culturally and theoretically equipped to make sense of an audio-visual moving image, to approach it critically with regard to its language and narration and being able to express his/her approach in black and white 3
12) Having ethical values and a sense of social responsibility 5