Course: Methods and Tools of Business Intelligence

« Back
Course title Methods and Tools of Business Intelligence
Course code USII/FMNB
Organizational form of instruction Seminar
Level of course Master
Year of study 2
Semester Winter
Number of ECTS credits 5
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Kašparová Miloslava, Ing. Ph.D.
  • Petr Pavel, doc. Ing. Ph.D.
Course content
Basic concepts and principles of working with data files. Basic data processing in spreadsheet MS Excel (eg use of functions, data filtering, creation of pivot tables, data visualization). Classification of data. Data analysis in corresponding software (eg IBM SPSS Statistics, MS Excel). Evaluation of analysis results and their graphical representation (visualization of results).

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Work with text (with textbook, with book), Methods of individual activities, Laboratory work
  • Contact teaching - 39 hours per semester
  • Data/material collection - 20 hours per semester
  • Home preparation for classes - 15 hours per semester
  • Independent critical reading - 10 hours per semester
  • Term paper - 66 hours per semester
Learning outcomes
The aim of the course is to consolidate the knowledge and extend the skills of data collection, analysis and processing, design models and their verification by using the tools of Data Mining and Business Intelligence.
Students will consolidate their knowledge and extend practical skills in the field of data collection, their analysis and processing, model design and verification and interpretation of conclusions. They will learn how to effectively use Data Mining tools in this area. They will learn to work in solving tasks in work teams, which will extend their competencies in the field of team work.
Prerequisites
Basic knowledge of systems theory II, Data Mining II and Business Intelligence.

Assessment methods and criteria
Written examination, Systematic monitoring, Self project defence

Assignment: successful elaboration of given tasks (provided in Stag).
Recommended literature
  • Brož, M. Microsoft Excel pro manažery a ekonomy. Computer Press. ISBN 80-251-1307-8.
  • HENDL, J. Přehled statistických metod zpracování dat. Analýza a metaanalýza dat. Praha: Portál, 2004.
  • Petr, P. Data Mining 1. Pardubice: Univerzita Pardubice, 2006.
  • Petr, P. Metody Data Miningu: část II. Pardubice: Univerzita Pardubice, 2014.
  • Petr, P. Metody Data Miningu: část I. Pardubice: Univerzita Pardubice, 2014.
  • Řehák, J., Brom, O. SPSS: praktická analýza dat. Brno: Computer Press., 2015.
  • Řezanková, Hana. Analýza dat z dotazníkových šetření. Praha. 2017.


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