157-0369/01 – Systems of BI (SBI)

Gurantor departmentDepartment of Systems EngineeringCredits5
Subject guarantordoc. Ing. Milena Tvrdíková, CSc.Subject version guarantordoc. Ing. Milena Tvrdíková, CSc.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semesterwinter
Study languageCzech
Year of introduction2012/2013Year of cancellation2013/2014
Intended for the facultiesEKFIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
NEM191 Ing. Radek Němec, Ph.D.
TVR30 doc. Ing. Milena Tvrdíková, CSc.
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

The aim of the subject is to introduce students to the Business Intelligence (BI) field and its role in current enterprise and institutional management systems

Teaching methods

Lectures
Tutorials
Project work

Summary

Compulsory literature:

INMON, William H. Building the data warehouse, 4. vyd. New York: Wiley, 2005. ISBN 978-0764599446. KIMBALL, Ralph and Margy ROSS. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 3. vyd. New York: Wiley, 2013. ISBN 978-1-118-53080-1.

Recommended literature:

LABERGE, Robert. The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights. New York: McGraw-Hill, 2011. ISBN 978-0071745321. ROB, Peter, Carlos CORONEL and Keeley CROCKETT. Database systems: Design, Implementation & Management. London: Cengage Learning, 2008. ISBN 978-1-84480-732-1.

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

- 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: 2012/2013 Winter semester, validity until: 2013/2014 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 45  23
        Examination Examination 55  28
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2013/2014 (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 (00) System Engineering and Informatics P Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner