Course detail

Data Processing and Visualisation

FP-zvdPAcad. year: 2026/2027

The course "Data Processing and Visualization" includes an introduction to data processing and visualization, where students will learn about definitions, importance, tools, and technologies, as well as the basics of statistics and data analysis. It then focuses on data structures and formats, data preprocessing, basic and advanced visualization techniques, interactive visualizations, time series visualization, and big data visualization. Students will also learn about the ethics and interpretation of data, analyze case studies, and become familiar with trends and the future of data processing, including new technologies, big data, and cloud databases.

Language of instruction

Czech

Number of ECTS credits

4

Mode of study

Not applicable.

Entry knowledge

The following prerequisites are expected:
Basic knowledge of statistics and probability
Basic knowledge of working with spreadsheet software (e.g., Excel)
Basic knowledge of database systems and fundamentals of SQL

Rules for evaluation and completion of the course

Conditions for Graded Credit: The student must obtain at least 50% of the points during the semester, which is 50 points out of 100. Plagiarism or unauthorized collaboration on projects or tests will result in the denial of credit and may lead to disciplinary proceedings.
Midterm Test: Completion of a practical task according to the assignment (40 points). The minimum number of points required is 20.
Project: One project according to the assignment with the appropriate documentation (60 points). The minimum number of points required is 30.
The assignment is introduced in the third lecture. The evaluation is in accordance with the ECTS grading scale.

Course Completion for Students with Individual Study PlansCredit Completion of a project according to the assignment with the appropriate documentation. The assignment is presented in the third lecture.
A minimum of 50 points out of 100 is required. 

Aims

The aim of the course "Data Processing and Visualization" is to provide students with the theoretical and practical knowledge necessary for data processing and visualization. Students will learn to use various tools and technologies for data analysis and visualization, which will enable them to develop skills in interpreting and presenting data analysis results. An important part of the course is also familiarizing students with ethical issues related to data processing. The course will prepare students to work with large data sets and modern technologies in the field of data analytics.

Study aids

Study supports are displayed in e-learning.

Prerequisites and corequisites

Not applicable.

Basic literature

Randolph, G., & Johnson, B. (2020). Microsoft Power BI Quick Start Guide: Build dashboards and visualizations to make your data come to life. 2nd ed. Birmingham: Packt Publishing. ISBN 978-1789138221 (EN)
Russo, M., & Ferrari, A. (2020). The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI. 2nd ed. Redmond: Microsoft Press. ISBN 978-1509306978. (EN)

Recommended reading

Misner, S., & Lester, R. (2019). Introducing Microsoft SQL Server 2019. Redmond: Microsoft Press. ISBN 978-1838826215. (EN)
Seidl, J., & Seidl, M. (2021). Mastering Microsoft Power BI: Expert techniques for effective data analytics and business intelligence. Birmingham: Packt Publishing. ISBN 978-1788297233. (EN)

Classification of course in study plans

  • Programme BAK-EAM Bachelor's

    specialization BAK-EAM-UAD , 2 year of study, summer semester, compulsory
    specialization BAK-EAM-EP , 2 year of study, summer semester, compulsory

Type of course unit

 

Lecture

13 hod., optionally

Teacher / Lecturer

Syllabus

1. Introduction to Data Processing and Visualization
Definition and Importance
Overview of Tools and Technologies
Basics of Statistics and Data Analysis (Descriptive and Inferential Statistics)
2. Data Structures and Formats
Structured and Unstructured Data
Data Formats
Data Preprocessing (Cleaning, Transformation, and Normalization)
3. Basic Visualization Techniques
Basic Charts (Bar, Pie, Line)
Advanced Visualizations (Heatmaps, Scatter Plots)
Tools for Data Visualization (Tableau, Power BI, Matplotlib)
4. Interactive Visualizations
Creating Interactive Dashboards
Using Interactive Elements
Visualization of Geographical Data (Map Visualizations, GIS)
5. Time Series Visualization
Time Series Analysis
Visualization Techniques for Time Series
Visualization of Big Data (Challenges and Solutions, Tools)
6. Ethics and Data Interpretation
Ethical Issues in Data Processing
Interpretation and Presentation of Results
Case Studies (Real Examples, Discussion and Analysis)
7. Trends and Future in Data Processing
New Technologies and Approaches
Big Data and Analytics
Cloud Databases

Exercise

26 hod., compulsory

Teacher / Lecturer

Syllabus

1. Introductory Exercise
Introduction to Tools and Environment
Basic Data Operations
2. Working with Data Files
Import and Export of Data
Manipulation of Data Frames
3. Data Cleaning and Preprocessing
Identification and Removal of Errors
Normalization and Transformation of Data
4. Basic Visualizations
Creating Basic Charts
Adjusting and Customizing Charts
5. Advanced Visualizations
Creating Advanced Charts
Using Advanced Visualization Techniques
6. Interactive Dashboards
Creating Interactive Dashboards
Working with Interactive Elements
7. Geographical Data Visualization
Working with Map Visualizations
Using GIS Tools
8. Time Series Visualization
Analysis and Visualization of Time Series
Using Appropriate Visualization Techniques
9. Big Data Visualization
Working with Large Data Sets
Using Tools for Big Data Visualization
10. Case Studies
Analysis of Real Data Sets
Creating Visualizations for Case Studies
11. Project Work
Design and Implementation of Own Project
12. Project Work
Design and Implementation of Own Project
13. Presentation and Interpretation of Results

Self-study

35 hod., optionally

Teacher / Lecturer

Individual preparation for an ending of the course

25 hod., optionally

Teacher / Lecturer