Introduction to Data Management and Business Intelligence
Course Code
Semester
Course Name
LE/RC/LA
Course Type
Language of Instruction
ECTS
MTH0003
Introduction to Data Management and Business Intelligence
3/0/0
DE
English
5
Course Goals
This course aims to examine, apply, and teach the processes of taking data from operational systems and transferring it to a central model with data transfer technologies, modeling the data, preparing it for presentation, and transforming it into a decision support system.
Prerequisite(s)
None
Corequisite(s)
Course Code Course Name…
Special Requisite(s)
The minimum qualifications that are expected from the students who want to attend the course.(Examples: Foreign language level, attendance, known theoretical pre-qualifications, etc.)
Instructor(s)
Lecturer Vedat Güneş
Course Assistant(s)
Schedule
This course is not offered in this semester.
Office Hour(s)
This course is not offered in this semester.
Teaching Methods and Techniques
Oral presentation
Principle Sources
W. H. Inmon, Building the Data Warehouse, Wiley 4th Edition, 2005.
Other Sources
Slides and course notes
Course Schedules
Week
Contents
Learning Methods
1. Week
Data creation in source systems
Oral presentation
2. Week
ETL, ELT and CDC data transfer methods
Oral presentation
3. Week
ETL, ELT and CDC data transfer methods
Oral presentation
4. Week
Data Modelling - The Kimball approach
Oral presentation
5. Week
Data Modelling - The Kimball approach
Oral presentation
6. Week
Data Modelling - The Inmon approach
Oral presentation
7. Week
Data Modelling - The Inmon approach
Oral presentation
8. Week
Displaying data
Oral presentation
9. Week
Data visualization
Oral presentation
10. Week
Data visualization
Oral presentation
11. Week
Data quality
Oral presentation
12. Week
Data privacy
Oral presentation
13. Week
Data governance
Oral presentation
14. Week
Data governance
Oral presentation
15. Week
16. Week
17. Week
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
20
Homework / Term Projects / Presentations
4
20
Project(s)
1
20
Final Exam
1
40
Program Outcomes
PO-1
Ability to apply theoretical and practical knowledge gained by Mathematics, Science and their engineering fields and ability to use their knowledge in solving complex engineering problems.
PO-2
Ability of determining, defining, formulating and solving complex engineering problems; for that purpose develop the ability of selecting and implementing suitable models and methods of analysis.
PO-3
Ability of designing a complex system, process, device or product under real world constraints and conditions serving certain needs; for this purpose ability of applying modern design techniques
PO-4
Ability of selecting and using the modern techniques and devices which are necessary for analyzing and solving complex problems in engineering implementations; ability of efficient usage of information technologies.
PO-5
Ability of designing experiments, conducting tests, collecting data and analyzing and interpreting the solutions to investigate of complex engineering problems or discipline-specific research topics.
PO-6
Ability of working efficiently in intra-disciplinary and multi-disciplinary teams; individual working ability and habits.
PO-7
Ability of verbal and written communication skills; and at least one foreign language skills, ability to write effective reports and understand written reports, ability to prepare design and production reports, ability to make impressive presentation, ability to give and receive clear and understandable instructions
PO-8
Awareness of importance of lifelong learning; ability to access data, to follow up the recent innovation in science and technology for continuous self-improvement.
PO-9
Conformity to ethical principles; knowledge about occupational and ethical responsibility, and standards used in engineering applications.
PO-10
Knowledge about work life implementations such as project management, risk management and change management; awareness about entrepreneurship and innovativeness; knowledge about sustainable development.
PO-11
Knowledge about effects of engineering applications on health, environment and security in global and social dimensions, and on the problems of the modern age in engineering; awareness about legal outcomes of engineering solutions.
Learning Outcomes
LO-1
Knows the dynamics of data creation in operational systems.
LO-2
Applies the methods for transferring and copying data.
LO-3
Understands the concept and methods of data modelling.
LO-4
Understand how to present data.
LO-5
Understands data visualization methods and technologies