Skip to main content
Skip header

Business Intelligence

Type of study Follow-up Master
Language of instruction Czech
Code 157-0377/01
Abbreviation BI
Course title Business Intelligence
Credits 5
Coordinating department Department of Systems Engineering and Informatics
Course coordinator doc. Dr. Ing. Miroslav Hudec

Subject syllabus

1. Introduction to the Business Intelligence principles.

2. The essence of the management system and support based through the Business Intelligence components.

3. Basic principles of dimensional modeling and design techniques of the Business Intelligence datawarehouses.

4. Business Intelligence system architecture - basic components and layers of data warehouse architecture components and basic aspects of collecting, storing and processing data, basic types of data warehouse storage.

5. Principles of data pump design and implementation, meaning and use of metadata in ETL and ELT processes, important aspects of data quality solutions.

6. Basic types and application aspects of BI system output interface software tools, principles of OLAP techniques.

7. Principles of SQL and MDX languages when querying data in data warehouses, visualization of query results and reporting services.

8. Basic principles of data mining (data mining) and the relationship to Business Intelligence.

9. The basic essence of Competitive Intelligence and work with data sources from the Big Data category, the essence of the process of unstructured data analysis incl. in connection with Competitive Intelligence, relation to the principles of OLAP and management reporting.

10. Strategic and tactical aspects of the planning and implementation of the Business Intelligence system, the life cycle of the system, the importance of cloud computing and EAI solutions when planning the implementation of the system, the possibility of using the principles of agile-oriented project management methodologies.

E-learning

Students have all relevant presentations from lectures and instructions in LMS Moodle

Literature

VAISMAN Alejandro a ZIMÁNYI Esteban. Data Warehouse Systems. Berlin Heidelberg: Springer, 2022. ISBN 978-3-662-65166-7 .
SKYRIUS, Rymvidas. Business Intelligence: A Comprehensive Approach to Information Needs, Technologies and Culture. Cham: Springer, 2022. ISBN: 978-3-030-67034-4 .
KIMBALL, Ralph a Margy ROSS. The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3. vyd. New York: Wiley, 2013. ISBN 978-1-118-53080-1 .

Advised literature

INMON, William H. a NESAVICH Anthony. Tapping into unstructured data: integrating unstructured data and textual analytics into business intelligence. Upper Saddle River: Prentice Hall, 2007. ISBN 978-0-13-236029-6.
GROSSMANN Wilfried a RINDERLE-MA Stefanie. Fundamentals of Business Intelligence. Berlin Heidelberg: Springer, 2015. ISBN 978-3-662-46530-1 .
MANCAS, Christian. Conceptual Data Modeling and Database Design. Oakville: Apple Academic Press, 2016. ASIN:B07V1QQDPT.