Course detail

Business Intelligence

FP-IbiPAcad. 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 subject

Language of instruction

Czech

Number of ECTS credits

6

Mode of study

Not applicable.

Guarantor

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

Department

Institute of Informatics (ÚI)

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

Not applicable.

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, Jak využít bohatství ve vašich datech. Praha: Grada 2005, 256s. ISBN 80-247-1094-3 (CS)
Lacko L.. Business Intelligence v SQL Serveru 2005, Brno, Computer Press, 2006, 387s. ISBN 80-251-1110-5 (CS)
Kříž J.: Business Intelligence, Scriptum FP VUT v Brně (CS)

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 (CS)

Classification of course in study plans

  • Programme MGR-SI Master's

    branch MGR-IM , 2. year of study, summer semester, compulsory

Type of course unit

 

Lecture

26 hours, optionally

Teacher / Lecturer

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

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

Exercise

26 hours, compulsory

Teacher / Lecturer

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

Syllabus

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