Management Information Systems
Bachelor TR-NQF-HE: Level 6 QF-EHEA: First Cycle EQF-LLL: Level 6

Ders Genel Tanıtım Bilgileri

Course Code: YBS306
Ders İsmi: Data Modeling and Data Warehouse
Ders Yarıyılı: Spring
Ders Kredileri:
Theoretical Practical Credit ECTS
1 2 2 5
Language of instruction: TR
Ders Koşulu:
Ders İş Deneyimini Gerektiriyor mu?: No
Type of course: Necessary
Course Level:
Bachelor TR-NQF-HE:6. Master`s Degree QF-EHEA:First Cycle EQF-LLL:6. Master`s Degree
Mode of Delivery: Face to face
Course Coordinator : Ar.Gör. FATMA NUR SARIKAYA
Course Lecturer(s):
Course Assistants:

Dersin Amaç ve İçeriği

Course Objectives: The aim of this course is to introduce and explain data warehouse steps and methods, to solve practical problems by introducing basic concepts and techniques, and to develop skills in using up-to-date data mining software.
Course Content: Data warehouse basics. Data warehouse planning, design, implementation and management. Calculation with data cubes. OLAP query processing. Fundamentals of data mining and its relation to data warehouses and OLAP. Association rule mining. It is clustering, classification and rule learning mining and so on.

Learning Outcomes

The students who have succeeded in this course;
Learning Outcomes
1 - Knowledge
Theoretical - Conceptual
2 - Skills
Cognitive - Practical
1) Uncover hidden information and patterns in data using techniques such as artificial neural networks, rule mining and decision trees.
2) Using the tools used for the data warehouse to learn and work
3 - Competences
Communication and Social Competence
Learning Competence
Field Specific Competence
1) Effective use of data in relational databases
2) Creating a clean and consistent data warehouse from the data in the data warehouse
3) Creating different levels and types of summary data for management decision support
Competence to Work Independently and Take Responsibility

Ders Akış Planı

Week Subject Related Preparation
1) Introduction to data warehouses PPT Documents, Textbooks
2) Multidimensional data modeling PPT Documents, Textbooks
3) Setting up a data warehouse 1 PPT Documents, Textbooks
4) Setting up a data warehouse 2 PPT Documents, Textbooks
5) Setting up a data warehouse 3 PPT Documents, Textbooks
6) Data mining and data visualization 1 PPT Documents, Textbooks
7) Data mining and data visualization 2 PPT Documents, Textbooks
8) Midterm
9) Data mining techniques: Clustering PPT Documents, Textbooks
10) Data mining techniques: Decision trees PPT Documents, Textbooks
11) Data warehouse and data mining applications 1 PPT Documents, Textbooks
12) Data warehouse and data mining applications 2 PPT Documents, Textbooks
13) Data warehouse and data mining applications 3 PPT Documents, Textbooks
14) Project Presentations PPT Documents, Textbooks

Sources

Course Notes / Textbooks: George M. Marakas, “Modern Data Warehousing, Mining, and Visualization: Core Concepts”, Prentice Hall, 2003.
References: Tan P.N., Steinbach M., Kumar V. Introduction to Data Mining. Addison Wesley, 2005.

Ders - Program Öğrenme Kazanım İlişkisi

Ders Öğrenme Kazanımları

1

2

3

4

5
Program Outcomes
1) To use concepts and theories related to different areas of business to solve problems related to institutions.
2) Making decisions using appropriate analytical and quantitative techniques as managers of the business.
3) To produce and analyze strategies that will improve creativity and innovation in information technology applications.
4) Develop techniques to understand and improve the enterprise information technology infrastructure, including the design and implementation of hardware and software components to support business requirements.
5) Defining and documenting operational business processes in a way that also determines the information technology components that will work together for the purpose of continuous process improvement.
6) To produce and analyze strategies that will improve creativity and innovation in information technology applications.
7) Demonstrate teamwork and leadership skills required in the business environment
8) Demonstrate awareness of ethical and environmental issues when dealing with business problems related to information technology.
9) To have research skills on how to obtain the necessary resources to evaluate and solve business-related problems.
10) To apply innovative and creative solutions to existing and diverse environments.
11) Using a foreign language and communicating with colleagues from all over the world to follow new developments in business and management
12) To use information and communication technologies with advanced computer programs in the field of management.
13) Preparing and presenting informative, effective and interesting presentations
14) To be able to produce and present quality documentation for all kinds of projects, including entrepreneurship projects

Ders - Öğrenme Kazanımı İlişkisi

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution
1) To use concepts and theories related to different areas of business to solve problems related to institutions. 4
2) Making decisions using appropriate analytical and quantitative techniques as managers of the business. 4
3) To produce and analyze strategies that will improve creativity and innovation in information technology applications. 4
4) Develop techniques to understand and improve the enterprise information technology infrastructure, including the design and implementation of hardware and software components to support business requirements. 4
5) Defining and documenting operational business processes in a way that also determines the information technology components that will work together for the purpose of continuous process improvement. 3
6) To produce and analyze strategies that will improve creativity and innovation in information technology applications. 4
7) Demonstrate teamwork and leadership skills required in the business environment 2
8) Demonstrate awareness of ethical and environmental issues when dealing with business problems related to information technology. 2
9) To have research skills on how to obtain the necessary resources to evaluate and solve business-related problems. 2
10) To apply innovative and creative solutions to existing and diverse environments. 2
11) Using a foreign language and communicating with colleagues from all over the world to follow new developments in business and management 1
12) To use information and communication technologies with advanced computer programs in the field of management. 4
13) Preparing and presenting informative, effective and interesting presentations 2
14) To be able to produce and present quality documentation for all kinds of projects, including entrepreneurship projects 2

Öğrenme Etkinliği ve Öğretme Yöntemleri

Anlatım
Beyin fırtınası /Altı şapka
Course
Problem Çözme
Soru cevap/ Tartışma
Örnek olay çalışması

Ölçme ve Değerlendirme Yöntemleri ve Kriterleri

Yazılı Sınav (Açık uçlu sorular, çoktan seçmeli, doğru yanlış, eşleştirme, boşluk doldurma, sıralama)
Uygulama
Bireysel Proje
Örnek olay sunma

Assessment & Grading

Semester Requirements Number of Activities Level of Contribution
Homework Assignments 1 % 10
Midterms 1 % 30
Final 1 % 60
total % 100
PERCENTAGE OF SEMESTER WORK % 40
PERCENTAGE OF FINAL WORK % 60
total % 100

İş Yükü ve AKTS Kredisi Hesaplaması

Activities Number of Activities Workload
Course Hours 14 14
Application 14 28
Study Hours Out of Class 14 98
Project 1 4
Quizzes 2 4
Midterms 1 1
Final 1 1
Total Workload 150