| 1. | Course Title | Data Warehouse and Purpose-built Data | |||||||||||
| 2. | Code | 4ФЕИТ07015 | |||||||||||
| 3. | Study program | 7-NKS, 8-KM-INN, 20-IMSA, 21-PNMI | |||||||||||
| 4. | Organizer of the study program (unit, institute, department) | Faculty of Electrical Engineering and Information Technologies | |||||||||||
| 5. | Degree (first, second, third cycle) | Second cycle | |||||||||||
| 6. | Academic year/semester | I/1 | 7. | Number of ECTS credits | 6.00 | ||||||||
| 8. | Lecturer | Dr Goran Jakimovski | |||||||||||
| 9. | Course Prerequisites | ||||||||||||
| 10. | Course Goals (acquired competencies):
Ackquiring knowlegde in Data Warehousing and defining framework for purpose-built data. Using the model to evaluate system and identify errors. |
||||||||||||
| 11. | Course Syllabus:
Working with data warehouses. How to store data. Defining business logic for data acquisition and data manipulation. Using technologies that focus on statistics and business for business improving. Warehouses and data manipulation of existing business systems and proposing new systems based on statistical data. Integrating purpose-built databases with business inteligence. |
||||||||||||
| 12. | Learning methods:
lectures with presentations, homework and project assignment |
||||||||||||
| 13. | Total number of course hours | 180 | |||||||||||
| 14. | Distribution of course hours | 3 + 3 | |||||||||||
| 15. | Forms of teaching | 15.1 | Lectures-theoretical teaching | 45 hours | |||||||||
| 15.2 | Exercises (laboratory, practice classes), seminars, teamwork | 45 hours | |||||||||||
| 16. | Other course activities | 16.1 | Projects, seminar papers | 30 hours | |||||||||
| 16.2 | Individual tasks | 30 hours | |||||||||||
| 16.3 | Homework and self-learning | 30 hours | |||||||||||
| 17. | Grading | ||||||||||||
| 17.1 | Exams | 0 points | |||||||||||
| 17.2 | Seminar work/project (presentation: written and oral) | 50 points | |||||||||||
| 17.3. | Activity and participation | 0 points | |||||||||||
| 17.4. | Final exam | 50 points | |||||||||||
| 18. | Grading criteria (points) | up to 50 points | 5 (five) (F) | ||||||||||
| from 51 to 60 points | 6 (six) (E) | ||||||||||||
| from 61 to 70 points | 7 (seven) (D) | ||||||||||||
| from 71 to 80 points | 8 (eight) (C) | ||||||||||||
| from 81 to 90 points | 9 (nine) (B) | ||||||||||||
| from 91 to 100 points | 10 (ten) (A) | ||||||||||||
| 19. | Conditions for acquiring teacher’s signature and for taking final exam | 60% success of all curriculum activities | |||||||||||
| 20. | Forms of assessment | Project assignment and final exam. | |||||||||||
| 21. | Language | Macedonian and English | |||||||||||
| 22. | Method of monitoring of teaching quality | Self-evaluation | |||||||||||
| 23. | Literature | ||||||||||||
| 23.1. | Required Literature | ||||||||||||
| No. | Author | Title | Publisher | Year | |||||||||
| 1. | Ralph, K.,Margy, R., Warren, T., Joy, M., Bob, B. | “The Data Warehouse Lifecycle Toolkit” | Wiley | 2008 | |||||||||
| 2. | Robert S., Joseph R., Rick G. | "Oracle Data Warehousing and Business Intelligence Solutions" | Wiley | 2007 | |||||||||
| 3. | Ralph, K., Margy, R. | “The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling" | Wiley | 2013 | |||||||||
