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
Number of ECTS credits
Mode of study
Guarantor
Department
Learning outcomes of the course unit
Prerequisites
Co-requisites
Planned learning activities and teaching methods
Assesment methods and criteria linked to learning outcomes
1. Active participation on practical lessons and checking of the individual tasks in three advanced terms.
Course curriculum
- 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
Aims
Specification of controlled education, way of implementation and compensation for absences
Recommended optional programme components
Prerequisites and corequisites
Basic literature
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
STANEK, W.R. Microsoft SQL Server 2005, Computer Press 2006, ISBN 80-251-1211-X
Classification of course in study plans