Course detail

Business Intelligence

FP-EbiPAcad. year: 2023/2024

The subject deals with basic principles and approach to solution BI and the possibility of their using in managing of the company. The MS SQL Server 2005, 2008 and its integrated functions are used for the practical part of the subject

Language of instruction

English

Number of ECTS credits

5

Mode of study

Not applicable.

Entry knowledge

The requirements for students are accentuate to level of knowledge database systems, data warehouse and the basic of programming language.

Rules for evaluation and completion of the course

Prerequisites:
Student during the semester must obtain at least 50% of the possible maximum, that is 20 points out of 40. If could be detected plagiarism or unauthorized collaboration on projects, or at mid-term test, credit will be granted with consideration of disciplinary proceedings.
Mid-term test - writing, (correct answers could be by selecting one of several sentence answers or a combination thereof), and developing practical task by task. There is no trial. (20 points)
Elaboration the project - a project by entering the appropriate documentation. The project proposition is introduced to students in the second lecture. (20 points)

Test conditions:
Final exam - written test form (correct answers could be by selecting one of several sentence answers or a combination thereof) and an oral examination. (60 points for the written part of the exam; for the successful completion of the exam must be written exam developed to be evaluated by at least 30 points, otherwise the test is scored 0 points with the evaluation of F.)
The checking results of individual tasks. In case of excused absence in practical lessons the teacher can give compensatory condition.

Attendance at lectures is not compulsory. Seminars with computer support is required, attendance is controled. One absence from seminars could be apologized by teacher. Student will replace this lack of elaboration especially given homework.

Exercise with computer support are focused on teaching integration, analysis and prediction capabilities and tools of MS SQL Server. During the semester students write semester test for a maximum of 20 points. For this semester there is no test trial. If a student has a well-documented and teacher excused absence in seminars, where is written midterm exam, he/she can attend on an alternative date.

In the second lecture is given to students separate project for a maximum of 20 points. Student must obtain at least 10 points to recognize this project. The project student submits the credit week.
Students who have an individual learning plan, ie. they do not go into sečminars, have to prepare and submit a special stand-alone project for the credit. For this particular project can get 30 points.

The course ends with a written exam for a maximum of 60 points. Participation in the test is mandatory.

Aims

The goal of the subject is to teach students manage the projects, development and applications of Business Inteligence (BI), implementation of tasks BI and gain practical skill with analytics parts of BI.
Students obtain knowledge about general principles on which the BI tasks are based, about the approach in their solution and using in the managing of the company gnd gain practical skill with analytics parts of BI.

Study aids

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Kříž J.: Business Intelligence, Scriptum FP VUT v Brně
Lacko L.. Business Intelligence v SQL Serveru 2005, Brno, Computer Press, 2006, 387s. ISBN 80-251-1110-5
Novotný, O., Pour, J., Slánský D.: Business Intelligence, Jak využít bohatství ve vašich datech. Praha: Grada 2005, 256s. ISBN 80-247-1094-3

Recommended reading

Brust J.A., Forte S.: Mistrovství v programování SQL Serveru 2005. Tvorba databázových aplikací a řešení pro BI. Brno, Computer Press, 2007, 833s. ISBN 978-80-251-1607-4

Classification of course in study plans

  • Programme MGR-EBF Master's 1 year of study, summer semester, compulsory-optional

Type of course unit

 

Lecture

26 hod., optionally

Teacher / Lecturer

Syllabus

- The basics principals and progression BI
- Approach to solution BI
- Strategy of development, planning projects and solving BI
- Simulation and implementations process BI
- Data transformation (process ETL, proposal of integration services, data warehouse
- OLAP analysis (multidimensional database, tables of facts and dimensions)
- Creation and working with OLAP cube
- Data mining
- Clients applications
- Applications fields BI in company
- Trends in BI

Computer-assisted exercise

13 hod., compulsory

Teacher / Lecturer

Syllabus

The content of the practical lessons is practice topics from lectures and work up tasks.