Přístupnostní navigace
E-application
Search Search Close
Course detail
FIT-DS_2Acad. year: 2024/2025
Basic terms: relational and multidimensional database model, operational database, data warehouse, data mart, building and running of a data warehouse, modelling a data warehouse - multidimensional model, data cube, OLAP analysis, data mining.
Language of instruction
Number of ECTS credits
Mode of study
Guarantor
Department
Entry knowledge
Rules for evaluation and completion of the course
Aims
Study aids
Prerequisites and corequisites
Basic literature
Recommended literature
Classification of course in study plans
Lecture
Teacher / Lecturer
Syllabus
1. Basic terms of data warehousing. Relationship of data warehouses and operational databases.2. Architecture of a data warehouse. Modelling of data warehouses.3. ETL process during creating data warehouse.4. OLAP tachnics and OLAP operations over a data cube.5. A case study about using of data warehouses.6. Introduction to the design of data warehouses.7. Introduction to data mining in data warehouses.
Computer-assisted exercise
1. Repetition of relational databases and SQL.2. Data warehousing and OLAP usage analysis in Microsoft tools.3. Use MS Excel for OLAP analysis.4. Individual project to create a data warehouse.5. Use of methods data mining tools in an environment of Microsoft.6. Individual project on data mining.