Óbudai Egyetem - Keleti Károly Gazdasági Kar
Intézet: Vállalkozásmenedzsment Intézet (1084 Budapest, Tavaszmezõ u. 15-17.) Kreditérték: 3
Tagozat: Nappali Nyelv: English Félév: 2019/20/1
Szakok: Technical Management BSc;
Tantárgyfelelős oktató: Dr. habil. Velencei Jolán Oktatók: Prof. Dr. habil. Tick Andrea;
Heti/Féléves óraszámok: Heti Előadás: 1 Tantermi gyakorlat: 0 Labor: 1 Konzultáció: 0
Félévzárás módja (követelmény): félévközi jegy
Oktatási cél: The course is an introduction to Management Information Systems. During the course students get an insight into the role of management in designing,
developing and using information systems at companies. Furthermore the students may be able to use a kind of MIS software.
At the end of the course students will be able to
• define what a Management Information System is,
• characterize Information Systems,
• explain the role, functions and architecture of a Management Information System,
• list different kind of Management Information Systems,
• build decision making tools for middle management applying dashboards and business intelligence.
Félévközi követelmények
(feladat, zh. dolgozat, esszé, stb):
Students are required to attend all classes. (Active participations are required during the lessons).
Home work (essay) and written exam.
Lecture is a form of tuition where either the whole spectrum of a specific subject or part of it is presented simultaneously to all students
attending the relevant course unit, (characteristically, this means all students or a group of students in the same year). Attendance at lectures is
an integral part of acquisition, albeit no administrative measures can be taken for students to actually attend them. On the other hand, assessment
of student performance shall encompass knowledge based on lecture material.
Practical course is a form of tuition where the aim of a course unit is to consolidate the skills aspect of acquisition. As for some course units,
lectures and practical courses have a complementary role to play in the process of tuition.
Absence from course units whose attendance is compulsory is acceptable up to 20 per cent of contact hours in those course units. Absence from over
fifty percent of contact hours shall lead to that unit having to be redone to fulfil course unit requirements. Absence from over 20 percent but less
than 50 percent of contact hours in a course unit shall lead to an obligation to make up for contact hours missed, the conditions of which shall be
specified in the departmental Course Requirements Guide. STUDENTS CAN MISS 2 SEMINARS AT MOST!
The subsequent obtaining of an end-of-semester mark/mark for student participation and subsequent assessment following the receipt of a ’fail’ mark
is confined to two assessment days during the examination period. An unsuccessful retake shall entail the student’s obligation to do that course
unit again.
Oktatási hét
1. Introduction to Management Information Systems, MIS structure, functions, economical aspects. Configuration, default, interfaces.
2. Manager-friendly informatics, Expert systems, System and database administration, authentication, authorization (login)
3. Introduction to Dashboard systems
4. Business reports and KPI
5. OLAP and OLTP Systems, multidimensional models, Data feeds (support and stages)
6. Basic Database actions and operations
7. Deep and expert knowledge, data mining, advanced database operation
8. Dashboard and data visualization (basic mashapps)
9. Dashboard and data visualization (complex mashapps)
10. Big Data’s world, interactive reports
11. Reports sharing, communication in and out of the corporate
12. Data analysis, data filters
13. Students’ presentations: Reports made by the students. Written Exam.
14. Students’ presentations: Reports made by the students. Written Exam (Make up test).
Az értékelés, a lebonyolítás,
a pótlás módja,
a jegy kialakításának szempontjai:
Preconditions of signature are the attendance at the seminars, valid test and submitted home assignment.
Students are required to have a valid test. No turn up on the scheduled test is considered an invalid test and the student is not entitled to have a re-sit.
In the test students are entitled to use handwritten notes on one A4-sized paper. No photocopies, photos or notebooks can be used.
No cellphones, smartphones or any other smart device capable of taking pictures can be brought into the room during test writing.
Should the student use any unauthorized help during test writing, his/her mark is “NO SIGNATURE” regardless of his/her results achieved so far.
Absence from test writing due to illness or other official occupancy can be certified once. Should this be the case, the student is entitled to have a make-up test.
Students must submit the assignment announced during the course.
Students will be assessed on the test written in the test week and the assignment submitted.
Grade in this course is based on total points/percentages of the test, and student’s activity, creativity and preparation (i.e. the instructor also values the active/inactive participation in classes or the level of the homework).
Each element will be assessed on a scale of 1 to 100% where the assessment bands are the following:
Percentage (%) Assessment
0 - <50 fail
51 - <62 pass
63 - <74 fair/satisfactory
75 - <85 good
86 - 100 excellent/distinction
Aspects of the final grade are the following:
- business dashboard, making and presentation of business report
- written exam
- participation and attendance during the course (regarding the TVSZ (Study Rules and Regulations))
A félévzárás módja
(írásbeli, szóbeli, teszt, stb.):
Substitution (make up test) during the first 10 weekdays of the exam period.
Kötelező irodalom: 1. KC Laudon, JP Laudon, Management Information Systems, Managing the Digital Firm, Global Edition, 13/E, Pearson, 2014
2. http://www.bi-dw.info/excel/tutorials.htm
3. http://www.microsoftvirtualacademy.com/training-courses/excel-2013-power-bi-fundamentals
4. https://support.office.microsoft.com/en-us/article/Tutorial-Import-Data-into-Excel-2013-and-Create-a-Data-Model-4b4e5ab4-60ee-465e-8195-
5. https://support.office.microsoft.com/en-us/article/Power-View-Explore-visualize-and-present-your-data-98268d31-97e2-42aa-a52b-a68cf460472e?

Ajánlott irodalom: 1. Contoso project: https://goo.gl/5eponX,
a. https://www.microsoft.com/en-us/download/confirmation.aspx?id=18279
b. https://msdn.microsoft.com/en-us/library/gg413497(v=sql.110).aspx
c. https://goo.gl/RkyWWn
d. https://msdn.microsoft.com/en-us/library/gg399129(v=sql.110).aspx
e. https://msdn.microsoft.com/en-us/library/gg399135(v=sql.110).aspx
f. https://msdn.microsoft.com/en-us/library/gg399133(v=sql.110).aspx
g. https://msdn.microsoft.com/en-us/library/hh272060(v=sql.110).aspx
2. OEP:
a. http://www.oep.hu
b. http://www.neak.gov.hu/felso_menu/szakmai_oldalak/publikus_forgalmi_adatok/
c. http://www.neak.gov.hu/felso_menu/szakmai_oldalak/publikus_forgalmi_adatok/
d. https://support.office.com/hu-hu/article/els%C5%91-l%C3%A9p%C3%A9sek-a-power-pivot-in-microsoft-excel-fdfcf944-7876-424a-8437-1a6c1043a80b
e. https://msdn.microsoft.com/en-us/library/gg413497(v=sql.110).aspx
f. https://powerpivotpro.com/what-is-power-pivot/
3. https://en.wikipedia.org/wiki/Dashboard_(business);
4. http://excel-bazis.hu/tutorial/dashboard-alapvetes;
5. http://officeguru.blog.hu/tags/DASHBOARD;
6. https://www.youtube.com/watch?v=odmZm9JF2aw;
7. https://chandoo.org/wp/2010/01/04/sales-dashboards/
8. https://goo.gl/hBU8t9
9. https://goo.gl/rYXiKY
10. https://goo.gl/oVunVK
11. https://goo.gl/Zdn4f1
12. https://goo.gl/c6gH1C
13. https://goo.gl/FbWE9f

Egyéb segédletek: Further readings and supplementary material will be given out during the course in the Moodle LMS system
1. https://support.office.com/en-us/article/power-pivot-powerful-data-analysis-and-data-modeling-in-excel-a9c2c6e2-cc49-4976-a7d7-40896795d045
2. https://support.office.com/en-us/article/start-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8
3. https://support.office.com/en-us/article/Get-started-with-Power-Map-88a28df6-8258-40aa-b5cc-577873fb0f4a
4. https://support.office.com/en-us/article/power-view-explore-visualize-and-present-your-data-98268d31-97e2-42aa-a52b-a68cf460472e
5. https://www.data.gov/
6. https://data.worldbank.org/
7. http://www.fao.org/faostat/en/#home
8. https://www.gapminder.org/data/
9. https://data.europa.eu/