Course details

Business Intelligence

IBbiP FP IBbiP Acad. year 2025/2026 Winter semester 5 credits

Current academic year

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.

Guarantor

Language of instruction

English

Completion

Credit+Examination

Time span

  • 13 hrs lectures
  • 13 hrs exercises

Department

Learning objectives

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).

Prerequisite knowledge and skills

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

Study literature

  • 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.
  • 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.
  • 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.

Fundamental literature

  • SHARDA, R., D. DELEN and E. TURBAN. Business Intelligence, Analytics and Data Science: A Managerial Perspective. 4th ed. UK: Pearson, 2019. ISBN: 978-9353067021.
  • 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.

Study supports

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

Syllabus of lectures

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

Syllabus of exercises

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.

Progress assessment

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.

Course inclusion in study plans

  • Programme BIT, 3rd year of study, Elective
  • Programme BIT (in English), 3rd year of study, Elective
Back to top