BPM_ZVPD Enterprise data processing and visualisation

Faculty of Economics and Administration
Autumn 2024
Extent and Intensity
0/2/0. 4 credit(s). Type of Completion: zk (examination).
Taught in person.
Teacher(s)
Ing. Pavel Lasák (lecturer)
Ing. Pavel Lasák (seminar tutor)
Guaranteed by
Ing. Pavel Lasák
Division of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Contact Person: Lenka Hráčková
Supplier department: Division of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Prerequisites
Basic work with a PC, know how to search and download files from the internet. Computer with Windows and Power BI, Excel
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The student is able to process business data, understand them and then visualize them appropriately for presentation to both superiors and subordinates. Subsequent decisions are based on the processed and visualized data.
Learning outcomes
Data can load xlsx data, internet Edit the retrieved data (Power BI, Excel, Google Sheets) Visualize data (Power BI - bar chart visuals, spreadsheet, matrix, Excel Gogle spreadsheet - charts and contingency tables) Link different tables (links, sessions, functions) Present data (Power Point, Teams)
Syllabus
  • 1) Introduction to data 2) Data formats advantages, disadvantages (xlsx, csv, sql, txt, JSON, XML) 3) How to present data (visuals, graphs, interactions) 4) Storytelling with data (Visuals and problems when using different visuals, 2D vs 3D graph) 5) Practical demonstration using SW for data processing - Excel - Power Query - Excel - Power Pivot - Excel - VBA - Google Sheets - Power BI - MySQL - SELECT - JOIN 6) Data processing and visualization - manufacturing company - HR department 7) Acquisition of data - questionnaires 8) Other tools - Looker Studio - R-ko, Python - Power Platform (Power Automate, Power Apps)
Teaching methods
Practical exercises at the PC
Assessment methods
Participation in the exercise Tests (mid-semester, end of semester) Practical project
Language of instruction
Czech
Further comments (probably available only in Czech)
The course is taught annually.
The course is taught: every week.
General note: Předmět bude vyučován od akademického roku 2025/2026.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/econ/autumn2024/BPM_ZVPD