| Course Unit Code | 157-0322/03 |
|---|
| Number of ECTS Credits Allocated | 5 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | Second Cycle |
|---|
| Year of Study * | First Year |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | There are no prerequisites or co-requisites for this course unit |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| NEM191 | Ing. Radek Němec, Ph.D. |
| HUD0118 | doc. Dr. Ing. Miroslav Hudec |
| Summary |
|---|
|
| Learning Outcomes of the Course Unit |
|---|
| aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa |
| Course Contents |
|---|
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. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
| aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa |
NĚMEC, Radek (2014). Principy projektování a implementace systémů Business Intelligence. Ostrava: SOET EkF VŠB-TUO. ISBN 978-80-248-3452-8.
POUR, Jan, Miloš MARYŠKA a Ota NOVOTNÝ (2012). Business Intelligence v podnikové praxi. Praha, Professional Publishing. ISBN 978-80-7431-065-2.
HOLUBOVÁ, Irena, Jiří KOSEK, Karel MINAŘÍK a David NOVÁK (2015). Big Data a NoSQL databáze. Praha, Grada. ISBN 978-80-247-5466-6.
|
| Recommended Reading: |
|---|
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
|
KIMBALL, Ralph a Margy ROSS (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3. vyd. New York: Wiley. ISBN 978-1-118-53080-1.
LACKO, Luboslav (2003). Datové sklady, OLAP a dolování dat. Praha: Computer Press. ISBN 80-7226-969-0.
INMON, William H. a Anthony NESAVICH (2007). Tapping into unstructured data: integrating unstructured data and textual analytics into business intelligence. Upper Saddle River, Prentice Hall. ISBN 978-0-13-236029-6.
|
| Planned learning activities and teaching methods |
|---|
| Lectures, Individual consultations, Tutorials, Project work |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Credit and Examination | Credit and Examination | 100 (100) | 51 |
| Credit | Credit | 35 | 35 |
| Examination | Examination | 65 | 16 |