157-0322/03 – Business Intelligence (BI)

Gurantor departmentDepartment of System EngineeringCredits5
Subject guarantorIng. Radek Němec, Ph.D.Subject version guarantorIng. Radek Němec, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semesterwinter
Study languageCzech
Year of introduction2012/2013Year of cancellation
Intended for the facultiesEKFIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
HUD0118 doc. Dr. Ing. Miroslav Hudec
NEM191 Ing. Radek Němec, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2

Subject aims expressed by acquired skills and competences

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

Teaching methods

Lectures
Individual consultations
Tutorials
Project work

Summary

Compulsory literature:

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

Recommended literature:

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

- Login to the Edison system and the LMS Moodle - Creation of the student project team and the announcement of the team structure to the teacher - Creation and defence of the seminary work (design and implementation of the BI system's database) - Verification of the participation on the seminary work creation during the exam (besides the theoretical knowledge)

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. BI tools, their structure, reasons to use them. Basic terms in the BI field, importance of BI for the company management. 2. Managerial applications Executive Information Systems (EIS), position of EIS in company's information system. EIS characteristics and its multidimensionality, multidimensionality in economic problems. 3. Data storage applications – data warehouses (DW), independent data marts, virtual DW, operational data store (ODS), data staging area (DSA). Principles of multidimensionality in data warehouses. Data mining. 4. Applications for gathering, transformation, cleaning and loading data – ETL (extraction, transformation, loading). Data quality, data profiling and data cleansing. Data pumps. Metadata. Master Data Management. 5. Components of a BI system in frame of its architecture, integration of the BI into enterprise information system. Integration nature of EIS and systems for application integration (EAI). 6. Business analytics – OLAP tools and ways of data manipulation in OLAP applications. Visualisation in the BI system. Data mining – techniques, tasks and tools, the role of mathematical models in the BI. 7. Categories of BI tools. Software tools for creation and administration of data warehouses and data marts. The offer of tools on the market. Selection criteria. 8. Basic typology of BI building approaches and development methodologies. Project team, roles in the BI project. BI and management of IT. Centralisation of planning and management of BI projects through BI competency center (BICC). 9. Lifecycle of the BI system: úvodní studie, strategie BI, „Plán trasy“ (roadmap), analýza požadavků, modelování a návrh datového skladu a datových pump. Implementace, provoz a řízení systému. 10. Parametry pro řízení systému BI. Kritické faktory úspěchu a ekonomika BI systému. Aktuální trendy v oblasti BI.

Conditions for subject completion

Full-time form (validity from: 2014/2015 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 35  35
        Examination Examination 65  16
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (N6209) Systems Engineering and Informatics (6209T017) Informatics in Economics P Czech Ostrava 1 Compulsory study plan
2018/2019 (N6209) Systems Engineering and Informatics (6209T017) Informatics in Economics P Czech Ostrava 1 Compulsory study plan
2017/2018 (N6209) Systems Engineering and Informatics (6209T017) Informatics in Economics P Czech Ostrava 1 Compulsory study plan
2016/2017 (N6209) Systems Engineering and Informatics (6209T017) Informatics in Economics P Czech Ostrava 1 Compulsory study plan
2015/2016 (N6209) Systems Engineering and Informatics (6209T017) Informatics in Economics P Czech Ostrava 1 Compulsory study plan
2015/2016 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics P Czech Ostrava 1 Compulsory study plan
2014/2015 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics P Czech Ostrava 1 Compulsory study plan
2013/2014 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2013/2014 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics (00) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2013/2014 (N6209) Systems Engineering and Informatics (1802T001) Applied Informatics P Czech Ostrava 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
Subject block without study plan - EKF - P - cs 2016/2017 Full-time Czech Optional EKF - Faculty of Economics stu. block