157-0322/02 – Business Intelligence (BI)

Gurantor departmentDepartment of Systems EngineeringCredits4
Subject guarantorIng. Radek Němec, Ph.D.Subject version guarantordoc. Ing. Milena Tvrdíková, CSc.
Study levelundergraduate or graduateRequirementCompulsory
Year2Semestersummer
Study languageCzech
Year of introduction2009/2010Year of cancellation2012/2013
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

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

Other requirements

************************************

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: 2009/2010 Winter semester, validity until: 2012/2013 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Exercises evaluation and Examination Credit and Examination 100  51
        Exercises evaluation Credit  
        Examination Examination   3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2012/2013 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics (00) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2011/2012 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics (00) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2010/2011 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics (00) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2009/2010 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics (00) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2009/2010 (N6209) Systems Engineering and Informatics (6209T025) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction

Předmět neobsahuje žádné hodnocení.