157-0377/01 – Business Intelligence (BI)
| Gurantor department | Department of Systems Engineering and Informatics | Credits | 5 |
| Subject guarantor | doc. Dr. Ing. Miroslav Hudec | Subject version guarantor | doc. Dr. Ing. Miroslav Hudec |
| Study level | undergraduate or graduate | Requirement | Compulsory |
| Year | 1 | Semester | winter |
| | Study language | Czech |
| Year of introduction | 2020/2021 | Year of cancellation | |
| Intended for the faculties | EKF | Intended for study types | Follow-up Master |
Subject aims expressed by acquired skills and competences
The main goal is to introduce the main concepts related to developing business intelligence systems. These systems play a significant role in decision making support also by the support of competitive intelligence.
Teaching methods
Lectures
Tutorials
Summary
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.
Compulsory literature:
Recommended literature:
Additional study materials
Way of continuous check of knowledge in the course of semester
Credit:
- processing of projects according to the required structure and submission in the LMS.
- obtaining at least 23 points out of 45.
Exam:
- questions from the given topics
- obtaining at least 28 points out of 55.
E-learning
Students have all relevant presentations from lectures and instructions in LMS Moodle
Other requirements
Active participation at the seminars (at least 60 %).
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
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.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction