Course detail

Business Intelligence

ÚSI-2FDBIAcad. year: 2011/2012

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 subjekt

Language of instruction

Czech

Number of ECTS credits

3

Mode of study

Not applicable.

Guarantor

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

Department

Institute of Forensic Engineering (ÚSI)

Learning outcomes of the course unit

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.

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 methods depend on the type of course unit as specified in the article 7 of BUT Rules for Studies and Examinations.

Assesment methods and criteria linked to learning outcomes

To get the credit is require fulfilling of these following conditions:
1. Active participation on practical lessons and checking of the individual tasks in three advanced 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 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 checking results 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

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

Recommended reading

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

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 hours, optionally

Teacher / Lecturer

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

Exercise

13 hours, compulsory

Teacher / Lecturer

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