Course: Business Inteligence

« Back
Course title Business Inteligence
Course code KMI/OBI
Organizational form of instruction Lecture + Lesson
Level of course Master
Year of study not specified
Semester Summer
Number of ECTS credits 5
Language of instruction English
Status of course unspecified
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Beránek Ladislav, doc. Ing. CSc.
Course content
Thematic units : 1. Basic principles of Business Intelligence (BI) 2. The application of BI in business management, effects and critical success factors of BI , planning and analysis of BI, BI tasks management 3. Principles of development in BI, links to other applications 4. Description of basic technologies OLAP (On Line Analytical Processing), demonstration of the principles on examples 5. Design and modeling - principles of dimensional modeling 6. Data quality, data quality management, solving of problem of granularity of data, solving of relationships of observed indicators 7. Principles of implementation of BI, data pumps, principles of ETL 8. Database environment, data warehouse environment MS SQL Server 9. MS SQL Server - environment for data warehouses - the principles, architecture, components, basic management 10. Solving applications, basic principles of MS Analysis Services, partial functions and options 11. Solution BI client applications, OLAP cubes 12. Interrogation means to multidimensional databases 13. Data Mining - Data Mining, description of the basic principles and application options

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Demonstration
Learning outcomes
The aim of the subject is to show the basic principles and procedures of business intelligence, to give an idea of the use of business intelligence in management and business. Application of these methods and principles will be demonstrated in a database server environment, such as in MS SQL Server. Creating data warehouses and data markets will be shown. The student should be able to design and implement business intelligence solutions for real-time deployment.
Students should be able to perform basic design and implementation of business intelligence solutions for deployment in real-world conditions.
Prerequisites
Knowledge of basic principles of databases in the scope of Database Systems I.

Assessment methods and criteria
Combined exam, Seminar work

Working up several homeworks, creating a project application.
Recommended literature
  • F. Provost, T. Fawcett. Data Science for Business: What you need to know about data mining and data-analytic thinking. O'Reilly Media, 2013. ISBN 978-1449361327.
  • HEATON, J. Business Intelligence Cookbook: a Project Lifecycle Approach. 2012.
  • LARSON, B. Delivering Business Intelligence with Microsoft SQL Server X.. 2011.
  • N. Jukic, S. Vrbsky, S. Nestorov. Database Systems: Introduction to Databases and Data Warehouses. Prentice Hall, 2013. ISBN 978-0132575676.
  • P. LeBlanc et al. Applied Microsoft Business Intelligence. Wiley, 2015. ISBN 978-1118961773.
  • R. Rad. Microsoft SQL Server 2014 Business Intelligence Development Beginners Guide. Packt Publishing, 2014. ISBN 978-1849688888.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester