Course detail

Business Intelligence

ÚSI-2FDBIAcad. year: 2018/2019

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

Czech

Number of ECTS credits

2

Mode of study

Not applicable.

Guarantor

Ing. Jiří Kříž, Ph.D.

Department

Institute of Forensic Engineering (ÚSI)

Learning outcomes of the course unit

Students will obtain knowledge of 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.

Prerequisites

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

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Teaching is carried out through lectures and seminars. Lectures consist of interpretations of basic principles, methodology of given discipline, problems and their exemplary solutions. Seminars particularly support practical mastery of subject matter presented in lectures or assigned for individual study with the active participation of students.

Assesment methods and criteria linked to learning outcomes

To get the credit requires fulfilling of these following conditions:
Active participation on practical lessons and checking of the individual tasks in three in advance announced terms.

Course curriculum

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

Work placements

Not applicable.

Aims

The goal of the subject is to teach students how to manage the projects and applications BI, implementation of tasks BI and gain practical skill with analytics parts of BI.

Specification of controlled education, way of implementation and compensation for absences

The results check of individual tasks. In case of excused absence in practical lessons the teacher can give compensatory condition.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

LACKO, L. Business Intelligence v SQL Serveru 2005, Computer Press 2006, ISBN 80-251-1110-5
NOVOTNÝ, O., POUR, J., SLÁNSKÝ, D. Business Intelligence, Grada 2004, ISBN 80-247-1094-3
SMEJKAL, V. RAIS, K. Řízení rizik ve firmách a jiných organizacích, Grada 2006, ISBN 80-247-1667-4

Recommended reading

DOSTÁL, P., RAIS, K., SOJKA, Z. Pokročilé metody manažerského rozhodování, Grada 2005, ISBN 80-247-1338-1
STANEK, W.R. Microsoft SQL Server 2005, Computer Press 2006, ISBN 80-251-1211-X

Classification of course in study plans

  • Programme MRzI Master's

    branch RFI , 2 year of study, summer semester, compulsory-optional

Type of course unit

 

Lecture

26 hod., optionally

Teacher / Lecturer

Ing. Jiří Kříž, Ph.D.

Exercise

13 hod., compulsory

Teacher / Lecturer

Ing. Jiří Kříž, Ph.D.