| School/Faculty/Institute | Faculty of Economics, Administrative and Social Sciences | ||||
| Course Code | MGMT 431 | ||||
| Course Title in English | Business Intelligence | ||||
| Course Title in Turkish | İş Zekası | ||||
| Language of Instruction | EN | ||||
| Type of Course | Flipped Classroom | ||||
| Level of Course | Intermediate | ||||
| Semester | Fall | ||||
| Contact Hours per Week |
|
||||
| Estimated Student Workload | 124 hours per semester | ||||
| Number of Credits | 5 ECTS | ||||
| Grading Mode | Standard Letter Grade | ||||
| Pre-requisites |
MIS 301 - Management Information Systems |
||||
| Co-requisites | None | ||||
| Expected Prior Knowledge | None | ||||
| Registration Restrictions | Only Undergraduate Students | ||||
| Overall Educational Objective | To understand and query sql command for business/marketing professionals and the structure of Business Intelligence projects and development of main layer. | ||||
| Course Description | In business world, it is expected that all employees will be analytical enough to their needs and add value to their companies. Business Administration department graduates are expected to communicate with technical departments, adopt a data-driven company culture and improve themselves in the data analytics to be aware of the added value they can create. The aim of this course is to make the students more adaptable to the business analytics world by explaining the concept of purposeful business intelligence, successful/unsuccessful examples in real life, benefits of analytical layers to companies, layers of business intelligence projects and data visualization. |
Course Learning Outcomes and CompetencesUpon successful completion of the course, the learner is expected to be able to:1) do simple query on tables using SQL commands 2) understand of operational data layer 3) understand of analytical data layer 4) design to Business Intelligence project 5) visualize data. |
| Program Learning Outcomes/Course Learning Outcomes | 1 | 2 | 3 | 4 | 5 |
|---|---|---|---|---|---|
| 1) The ability to recognize and apply basic principles and theories of law, legal methodology, and interpretation methods. | |||||
| 2) The ability to follow, evaluate, interpret and apply the current developments and legislative amendments. | |||||
| 3) The ability to locate and use legal resources; to follow and evaluate current legislative amendments, legal science, and court decisions. | |||||
| 4) The ability to internalize social, scientific and ethical values while evaluating legal information. | |||||
| 5) The ability to recognize, examine and resolve legal issues with respect to general principles of law, de lege feranda and de lege lata; to take into consideration both national and international aspects of law; and to acknowledge the importance of personal conviction while making decisions. | |||||
| 6) The ability to critically analyze legal disputes, legislation, court decisions and different views in the legal science; to form his/her own opinions; to detect legal lacuna and suggest alternative solutions. | |||||
| 7) The ability to understand issues regarding different fields of law; to characterize and propose solutions to complex issues arising from legal practice. | |||||
| 8) The ability to participate in and organize legal projects and activities as a socially responsible individual; to put his/her legal knowledge and skill to use efficiently (in the public or private sector). | |||||
| 9) The ability to use a foreign language at least on a B2 Level on the European Language Portfolio, to follow legal developments and communicate with colleagues in that language; to use computer software and information and communication technologies necessary in the law field at an Advanced Level of the European Computer Driving License. | |||||
| 10) Adoption of a positive approach to the concept of lifelong learning. | |||||
| 11) The ability to understand the development, evolution, and problems of the society and to contribute to the solution of these problems by legal methods. | |||||
| 12) The ability to understand the structure, organization, and functioning of law on the national and international level; to contribute to the development thereof. |
| N None | S Supportive | H Highly Related |
| Program Outcomes and Competences | Level | Assessed by | |
| 1) | The ability to recognize and apply basic principles and theories of law, legal methodology, and interpretation methods. | S | |
| 2) | The ability to follow, evaluate, interpret and apply the current developments and legislative amendments. | N | |
| 3) | The ability to locate and use legal resources; to follow and evaluate current legislative amendments, legal science, and court decisions. | N | |
| 4) | The ability to internalize social, scientific and ethical values while evaluating legal information. | S | |
| 5) | The ability to recognize, examine and resolve legal issues with respect to general principles of law, de lege feranda and de lege lata; to take into consideration both national and international aspects of law; and to acknowledge the importance of personal conviction while making decisions. | N | |
| 6) | The ability to critically analyze legal disputes, legislation, court decisions and different views in the legal science; to form his/her own opinions; to detect legal lacuna and suggest alternative solutions. | N | |
| 7) | The ability to understand issues regarding different fields of law; to characterize and propose solutions to complex issues arising from legal practice. | N | |
| 8) | The ability to participate in and organize legal projects and activities as a socially responsible individual; to put his/her legal knowledge and skill to use efficiently (in the public or private sector). | N | |
| 9) | The ability to use a foreign language at least on a B2 Level on the European Language Portfolio, to follow legal developments and communicate with colleagues in that language; to use computer software and information and communication technologies necessary in the law field at an Advanced Level of the European Computer Driving License. | S | |
| 10) | Adoption of a positive approach to the concept of lifelong learning. | H | |
| 11) | The ability to understand the development, evolution, and problems of the society and to contribute to the solution of these problems by legal methods. | N | |
| 12) | The ability to understand the structure, organization, and functioning of law on the national and international level; to contribute to the development thereof. | N |
| Prepared by and Date | HANDE KARADAĞ , May 2023 |
| Course Coordinator | CEYHAN MUTLU |
| Semester | Fall |
| Name of Instructor | Öğr. Gör. KORAY KOCABAŞ |
| Week | Subject |
| 1) | Introduction and basics |
| 2) | Data Types |
| 3) | Basic Reporting and Querying |
| 4) | Business intelligence lifecycle & building the BI Plan |
| 5) | Business intelligence lifecycle & building the BI Plan |
| 6) | 10 Keys to BI Projects |
| 7) | 10 Risks to BI Projects |
| 8) | Thinking of marketing intelligence data layer |
| 9) | Designing Data Warehouse |
| 10) | ETL Development using SSIS 1 |
| 11) | ETL Development using SSIS 2 |
| 12) | Developing Customer oriented data layer for marketing analytics |
| 13) | Data Visualization 1 |
| 14) | Data Visualization 2 |
| 15) | Final Examination Period |
| 16) | Final Examination Period |
| Required/Recommended Readings | The Data Warehouse Toolkit, Building the Data Warehouse, T-SQL Fundamentals, Professional Microsoft SQL Server 2014 Integration Services, Professional Microsoft SQL Server 2016 Reporting Services | |||||||||||||||
| Teaching Methods | The methods which will be used throughout the course are real life data cultured company case studies, presentations, in-class discussions – brain storming. Every member of the class is expected to freely share her/his knowledge, ideas and questions with the group without any concern. Throughout the course, experiential, constructivist, research-based and reflective teaching strategies are used. In all kinds of teaching and learning activities, student participation, active learning and learning by doing are essential. | |||||||||||||||
| Homework and Projects | The students will be making one beginner level design a marketing based datawarehouse as a group at the end of the course | |||||||||||||||
| Laboratory Work | None | |||||||||||||||
| Computer Use | Personal notebook | |||||||||||||||
| Other Activities | None | |||||||||||||||
| Assessment Methods |
|
|||||||||||||||
| Course Administration |
kocabask@mef.edu.tr In this course, active participation is key to learning and applying. Thus the grading of the class participation will be done based on the quality of active student participation and contribution to in-class activities. Students are expected to attend all sessions and be in class on time. When they can not attend due to a sickness (which should require a report from a full facility hospital) or an excuse accepted my MEF regulations, they should inform the instructors by mail. As the feedback and questions are very valuable for making the course a distinctive learning experience, students may visit the instructors during office hours or send e mails, for any course related issues. Academic dishonesty and plagiarism will be subject to the YÖK disciplinary regulation. |
|||||||||||||||
| Activity | No/Weeks | Hours | Calculation | ||||
| No/Weeks per Semester | Preparing for the Activity | Spent in the Activity Itself | Completing the Activity Requirements | ||||
| Course Hours | 14 | 2 | 3 | 1 | 84 | ||
| Project | 2 | 8 | 2 | 20 | |||
| Midterm(s) | 2 | 8 | 2 | 20 | |||
| Total Workload | 124 | ||||||
| Total Workload/25 | 5.0 | ||||||
| ECTS | 5 | ||||||