[GVMBI1KTNC] Business Intelligence I.
|Institute:||Vállalkozásmenedzsment Intézet (1084 Budapest, Tavaszmezõ u. 15-17.)||Credit:||2|
|Type of classes:||Nappali||Language:||English||Semester:||2018/19/2|
|Level:||ERASMUS; Gazdálkodási és menedzsment BSc alapszak; Gazdaságinformatikus BSc alapszak; Kereskedelmi és marketing BSc alapszak; Műszaki menedzser BSc alapszak;|
|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 introductory course to the Business Intelligence systems, its concept and functions are discussed. The course discusses the role
and essence of decision making systems including Business Intelligence in the life of Corporate Management.
At the end of the course students will be able
• to collect data from different sources
• to clean and transfer data to business intelligence systems
• to build data warehouse
• to process, analyse data and gain information for corporate management using Business Intelligence
|Requirements during the semester
part and final
oral/written exam etc.):
Students are required to attend all classes. (Active participations are required during the lessons).
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.
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
Home assignment and a written test.
|Topics of lectures/practices|
|1.||The concept of Business Intelligence, its function and role in corporate management – role of data visualisation spreadsheet management|
|2.||The components of Business Intelligence architecture – advanced Pivot tables in spreadsheet management|
|3.||The Information systems and Business Intelligence – advanced Pivot tables and charts in spreadsheet management|
|4.||The architectures of Business Intelligence – simple dashboard building|
|5.||The information system as decision supporting (DSS) and executive information (MIS, EIS) service –– role of datavisualisation in BI, data visualisation software services|
Data sources, data structures and massive data in BI
Data structures and data models in BI – BI I. data gathering, data cleaning using Power Query
|7.||How to manipulate data to gain the most information for management? – BI II. building a data warehouse in Power Pivot|
|8.||The role of BI in ERP - BI III. use of Power Pivot|
|9.||General business intelligence in corporate management – BI IV. Complex Dashboard from datawarehouse|
|10.||Corporate specific Business Intelligence in corporate management – BI V. - Complex Dashboard from datawarehouse|
|11.||Management Information system architectures – BI VI. – Dynamic datavisualisation, use of Power View|
|12.||Technological forces and consequences in the development of Business intelligence – BI VII. – Dynamic data visualisation, use of Power Pivot|
|14.||Students’ presentations: Reports made by the students of the home assignment.|
|Type of evaluation,
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, or recording can be brought into the room during test writing.
The use any unauthorized help during test writing is severely punished.
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 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:
• BI solutions, making and presentation of home assignment - BI solution
• one written test
• participation and attendance during the course (regarding the TVSZ (Study Rules and Regulations))
|Type of evaluation,
of grade, etc.
|Substitution (make up test) during the first 10 weekdays of the exam period.|
|Compulsory literature:||notes and links in Moodle LMS|