Institute: Vállalkozásmenedzsment Intézet (1084 Budapest, Tavaszmezõ u. 15-17.) Credit: 3
Type of classes: Nappali Language: English Semester: 2019/20/1
 
Level: Technical Management BSc;
 
Responsible Teacher: Dr. habil. Tick Andrea Teacher(s): Dr. habil. Tick Andrea;
Consultations (total/week): Heti Lectures: 0 Practice lectures: 0 Labs: 2 Consultations: 0
 
Type of Exam: félévközi jegy
 
Aim of the subject: The course is an introduction to Business IT Applications. 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. Students gen an insight
in different Business IT Applications supporting decisions and data analytics and online appearance of the company
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 kinds of Business IT Applications,
• build decision making tools for middle management applying dashboards and business intelligence.
• build a website for a company
• apply different Business IT Applications for business processes
practice data mining techniques
Requirements during the semester
(homeworks, essays,
excercises, teamworks,
presentations,
part and final
oral/written exam etc.):
Students are required to attend all classes. (Active participations are required during the lessons).
Home work (essay) and written exam.
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.
 
Week of
semester
Topics of lectures/practices
1. Introduction to Business IT Applications, focusing on Management Information Systems, decision making and data analytics
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, Reports sharing, communication in and out of the corporate
11. Data analysis, data filters
12. Online appearance of a business enterprise or a start up
13. Students´ presentations: Reports made by the students. Written Exam.
14. Students´ presentations: Reports made by the students. Written Exam (Make up test).
 
Type of evaluation,
repetition, calculation
of grade, etc.
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:
5 (excellent): 86 – 100 %
4 (good): 75 – 85 %
3 (satisfactory): 63 – 74 %
2 (pass): 51 – 62 %
1 (fail): 50 or less %
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))
Type of evaluation,
repetition, calculation
of grade, etc.
Substitution (make up test) during the first 10 weekdays of the exam period.
 
Compulsory literature: 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-
09ebba060bf0?CorrelationId=cb85a656-b5ee-4c0b-aa24-fb938b068038&ui=en-US&rs=en-US&ad=US
5. 5. https://support.office.microsoft.com/en-us/article/Power-View-Explore-visualize-and-present-your-data-98268d31-97e2-42aa-a52b-
a68cf460472e?CorrelationId=16aa8731-343f-4426-8358-9dd17c6e68f5&ui=en-US&rs=en-US&ad=US
Suggested literature: 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/
3. gyogyfurdo_forgalmi_adatok/forgalmi_adatok_2017gyogyf.html
a. http://www.neak.gov.hu/felso_menu/szakmai_oldalak/publikus_forgalmi_adatok/
4. gyogyszer_forgalmi_adatok
a. 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
b. https://msdn.microsoft.com/en-us/library/gg413497(v=sql.110).aspx
c. https://powerpivotpro.com/what-is-power-pivot/
5. https://en.wikipedia.org/wiki/Dashboard_(business);
6. http://excel-bazis.hu/tutorial/dashboard-alapvetes;
7. http://officeguru.blog.hu/tags/DASHBOARD;
8. https://www.youtube.com/watch?v=odmZm9JF2aw;
9. https://chandoo.org/wp/2010/01/04/sales-dashboards/
10. https://goo.gl/hBU8t9
11. https://goo.gl/rYXiKY
12. https://goo.gl/oVunVK
13. https://goo.gl/Zdn4f1
14. https://goo.gl/c6gH1C
15. https://goo.gl/FbWE9f
 
Other literature: 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/