Course detail

Business Intelligence

FP-IBbiPAcad. year: 2023/2024

The subject provides an overview of the principles and approaches to Business Intelligence (BI) solutions and the possibilities of their use in business management. It thus creates prerequisites for performing the function of analysts and consultants of applications designed to support decision-making in the company. The MS SQL Server and MS Power BI environments are used for the practical part of the course.

Language of instruction

English

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

Ing. Jiří Kříž, Ph.D.

Department

Institute of Informatics (ÚI)

Offered to foreign students

Of all faculties

Entry knowledge

The requirements for the student are set at the basic level of knowledge of database systems, data warehouses and programming techniques.

Rules for evaluation and completion of the course

The evaluation of the subject consists of two main parts - the preparation of the semester project focused on the field of Business Intelligence, and its subsequent defence and a written exam with an alternative option of an oral examination.

Completing the semester project in the prescribed form (according to the specification in e-learning) is also a condition for obtaining credit.

The evaluation corresponds to the point classification according to ECTS, while the maximum number of points - 100 - is divided between the sub-parts as follows:

  • Semester project: 60 points (40 points for project processing and 20 points for defence of the project)
  • Written exam: 40 points.

A pass rate of at least 50% is required for both parts.
In case of an insufficient number of points or the need for a better assessment, an oral examination is possible.

Participation is mandatory in pre-defined terms (specified within the e-learning) related to the review of the processing of the semester project and the completion of partial tasks. Replacement is possible only after agreement with the teacher.

Completion of the course for students with an individual study plan:
Terms of credit: Elaboration of the project according to the assignment and its submission with the prescribed documentation according to the instructions in e-learning.
Exam conditions: Project defence and oral examination.

Aims

The goal of the subject is to familiarize students with the basic principles of Business Intelligence (BI), the current development of BI, the position in the IS/ICT architecture, the implementation of BI tasks and the acquisition of practical skills with the analytical parts of BI.
Students will gain knowledge and be able to design and realistically implement a complete BI solution (multidimensional analysis, data pumps, multidimensional cubes and data mining up to the preparation of client applications).

Study aids

The study supports of the subject are concentrated in the subject's e-learning.

Prerequisites and corequisites

Not applicable.

Basic literature

DECKLER, G. and B. POWELL. Mastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence. 2nd ed. Pact Publishing, 2022. 712 p. ISBN: 978-1-80181-148-4. DECKLER, G. and B. POWELL. Mastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence. 2nd ed. Pact Publishing, 2022. 712 p. ISBN: 978-1-80181-148-4. (EN)
SHARDA, R., D. DELEN and E. TURBAN. Business Intelligence, Analytics and Data Science: A Managerial Perspective. 4th ed. UK: Pearson, 2019. ISBN: 978-9353067021. (EN)

Recommended reading

EDENFIELD, O. and E. CORCORAN. Microsoft Power BI Data Analyst Certification Guide: A comprehensive guide to becoming a confident and certified Power BI professional. Pact Publishing, 2022. 398 p. ISBN: 978-1803238562. (EN)
RUSSO, M. and A. FERRARI. The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel. 2nd ed. Microsoft Press, 2019. 768 p. ISBN: 978-1509306978. (EN)
SHARDA, R., D. DELEN and E. TURBAN. Analytics, Data Science, & Artificial Intelligence: Systems for Decision Support. 11th ed. Pearson, 2019. 832 p. ISBN: 978-0135192016. (EN)

Elearning

eLearning: currently opened course

Classification of course in study plans

  • Programme MGR-IBM Master's 2 year of study, winter semester, compulsory

  • Programme MGR-Z Master's

    branch MGR-Z , 1 year of study, winter semester, elective

Type of course unit

 

Lecture

13 hod., optionally

Teacher / Lecturer

Ing. Jan Luhan, Ph.D., MSc

Syllabus

Business Intelligence, Analytics and Data Science
Descriptive Analytics
Predictive Analytics
Prescriptive Analytics
Big Data Concepts and Tools
Current and Future Trends In BI

Exercise

13 hod., compulsory

Teacher / Lecturer

Ing. Jan Luhan, Ph.D., MSc

Syllabus

The seminars focus on the development of competencies for the practical implementation of BI solutions for a specific entity with a practical output in the form of a specific semester project.

Elearning

eLearning: currently opened course