Course detail

Data Analysis

FP-daPAcad. year: 2026/2027

This course offers a hands-on introduction to the world of data analysis in a managerial context. Students will gain essential knowledge of key concepts and modern tools such as Excel, Power BI, and R, learning how to leverage data for informed decision-making. The course covers a broad range of topics—from data visualisation and predictive modelling to ethical and security aspects of working with data. Emphasis is placed on real-world applications, critical thinking, and the ability to interpret data in a business environment.

Language of instruction

English

Number of ECTS credits

5

Mode of study

Not applicable.

Entry knowledge

A basic knowledge of economics, computer science, and programming is expected, including familiarity with algorithms, data structures, and fundamental mathematical and statistical concepts.

Rules for evaluation and completion of the course

Credit Requirements:
* Midterm Test: Completion of a practical assignment based on the given instructions (40 points). The minimum required score is 20 points.
* Project: One project based on the assignment with appropriate documentation (60 points). The minimum required score is 30 points. (The assignment will be introduced during the third lecture.)
* Plagiarism or unauthorised collaboration on projects or tests will result in denial of credit and may lead to disciplinary proceedings.
* Students must earn at least 50 out of 100 points during the semester.
Exam Requirements:
* Completion of a practical example and oral examination.
* No points from the credit are transferred to the exam.
* Exam grading follows the ECTS classification system.
Course Completion for Students with an Individual Study Plan (ISP):
* Credit: Completion of a project based on the assignment with appropriate documentation. (The assignment will be introduced during the third lecture and made available via e-learning. Minimum score: 50 out of 100 points.)
* Exam: Oral examination. Grading follows the ECTS classification system.
* For ISP students, the conditions are identical, except for any mandatory attendance requirements.
* Exam and credit deadlines are arranged individually following the approved ISP.

Aims

The course aims to equip students with the skills necessary to apply methods and tools for data analysis in real managerial situations. Students will learn to collect, clean, and analyse data, identify patterns and trends, create predictive models, and apply machine learning. Emphasis is placed on practical skills and the application of theoretical knowledge to real-world problems, which includes working on a final project.

Study aids

Study supports are available in e-learning.

Prerequisites and corequisites

Not applicable.

Basic literature

ALEXANDER, Michael, 2022. Microsoft Excel Power Pivot & Power Query: for dummies. 2nd ed. Hoboken, New Jersey: John Wiley & Sons. ISBN 978-1-119-84449-5. (EN)
DECKLER, Greg and POWELL, Brett, 2022. Mastering Microsoft Power BI: Expert techniques to create interactive insights for effective data analytics and business intelligence. 2nd ed. Birmingham: Packt. ISBN 978-1-80181-148-4. (EN)
FERRARI, Alberto and RUSSO, Marco, 2020. The Definitive Guide to DAX: Business Intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel. 2nd ed. Microsoft Press. ISBN 978-1-5093-0697-8.  (EN)

Recommended reading

SHARDA, Ramesh; DELEN, Dursun a TURBAN, Efraim, 2019. Business Intelligence, Analytics and Data Science: A Managerial Perspective. 4th ed. UK: Pearson. ISBN: 978-9353067021. (EN)
SHARDA, Ramesh; DELEN, Dursun a TURBAN, Efraim, 2021. Analytics, data science, & artificial intelligence: Systems for Decision Support. 11th ed. Harlow: Pearson. ISBN 978-1-292-34155-2. (EN)

Classification of course in study plans

  • Programme BAK-MIn Bachelor's 3 year of study, winter semester, compulsory

Type of course unit

 

Lecture

13 hours, optionally

Teacher / Lecturer

Syllabus

1. Fundamentals of Managerial Data Analysis
(Introduction to the course and its objectives, the importance of data analysis in managerial practice, key concepts, overview of tools such as Excel, R, Python, data access and its role in decision-making)
2. Statistical and Analytical Foundations
(Descriptive statistics, probability distributions, basic statistical tests, interpretation of results, working with confidence intervals and p-values)
3. Data Preparation and Management
(Data sources and acquisition, data cleaning and transformation, handling missing values, data types and formats, basic principles of data quality)
4. Exploratory and Visual Data Analysis
(Exploratory Data Analysis – EDA, data visualization using charts and dashboards, identifying trends, correlation vs. causation, storytelling with data)
5. Advanced Modeling and Prediction
(Introduction to predictive modeling, linear and logistic regression, classification models, basics of machine learning, supervised vs. unsupervised learning, business applications)
6. Decision-Making, Ethics, and Practical Applications
(Data-driven decision making, KPIs and performance metrics, optimization and simulation models, time series analysis, text and sentiment analysis, data ethics and security)

Exercise

26 hours, compulsory

Teacher / Lecturer

Syllabus

1. Introduction to Managerial Data Analysis (Overview of the course and objectives, Basic concepts and the importance of data analysis for managers, Introduction to data analysis tools (e.g., Excel, R, Python))
2. Statistical Foundations for Data Analysis (Descriptive statistics, Probability and distributions, Basic statistical tests)
3. Data Collection and Preparation for Analysis (Data sources and acquisition, Data cleaning and transformation, Handling missing values)
4. Working with Big Data (Introduction to Big Data, Tools and technologies for working with Big Data (e.g., Hadoop, Spark), Basic operations and functions)
5. Exploratory Data Analysis (EDA) (Data visualisation for EDA, Identifying patterns and trends, Correlation and causality)
6. Predictive Modelling (Introduction to predictive modelling, Regression analysis, Classification models)
7. Machine Learning for Managers (Basic concepts and techniques of machine learning, Supervised vs. unsupervised learning, Applications of machine learning in business)
8. Optimisation and Decision Models (Linear programming, Simulation models, Applications of optimisation techniques)
9. Time Series Analysis (Introduction to time series, Smoothing and decomposition, Time series forecasting)
10. Sentiment Analysis and Text Analytics (Introduction to text analytics, Sentiment analysis techniques, Applications of text analytics in business)
11. Data-Driven Decision Making (Data-driven decision-making process, KPIs and performance metrics, Dashboards for managers)
12. Data Ethics and Security (Ethical aspects of data analysis, Personal data protection, Security measures)
13. Final Project and Presentation (Working on the final project, Project presentations in class, Feedback and evaluation)

Professional Knowledge:
Students will understand the role of data in the decision-making process.
Professional Skills:
Students will learn to use tools and technologies for data transformation and analysis.
Professional Competence:
Students will be able to comprehend and interpret data.

Self-study

65 hours, optionally

Teacher / Lecturer

Individual preparation for an ending of the course

26 hours, optionally

Teacher / Lecturer