Skip to main content
Skip header

Business data processing

* Exchange students do not have to consider this information when selecting suitable courses for an exchange stay.

Course Unit Code155-1355/01
Number of ECTS Credits Allocated3 ECTS credits
Type of Course Unit *Choice-compulsory type B
Level of Course Unit *First Cycle
Year of Study *Second Year
Semester when the Course Unit is deliveredWinter Semester
Mode of DeliveryFace-to-face
Language of InstructionCzech
Prerequisites and Co-Requisites Course succeeds to compulsory courses of previous semester
Name of Lecturer(s)Personal IDName
NOV21Ing. Vítězslav Novák, Ph.D.
Summary
The aim of the course is to acquaint students with the basics of business intelligence and information support of teamwork using the Microsoft Office 365 office suite. At the end of the course students should be able to obtain information from more data using tools such as Microsoft Excel, Power Query, Power Pivot or Power BI.
Learning Outcomes of the Course Unit
The aim of the course is to acquaint students with the basics of business intelligence and information support of teamwork using the Microsoft Office 365 office suite. At the end of the course students should be able to obtain information from more data using tools such as Microsoft Excel, Power Query, Power Pivot or Power BI.
Course Contents
1. Excel – repeating the necessary basics
2. Excel – work with lists
3. Excel – data analysis using formulas
4. Excel – data analysis using structured tables
5. Excel – data analysis using pivot tables and charts
6. Excel – data analysis using the Power Pivot add-on and the DAX language
7. Excel – data import and transformation using Power Query
8. Power BI – the philosophy of the tool
9. Power BI – creating reports in Power BI Desktop
10. Power BI – DAX language in Power BI
11. Power BI - relationships
12. Power BI – Power Query in Power BI
Recommended or Required Reading
Required Reading:
WINSTON, Wayne. Microsoft Excel 2019 Data Analysis and Business Modeling. 6th edition. San Francisco, CA: Microsoft Press, 2019. ISBN 978-1509305889.
FERRARI, Alberto a Marco RUSSO. Analyzing Data with Microsoft Power BI and Power Pivot for Excel. Redmond, Washington: Microsoft Press, 2017. ISBN 978-1-5093-0276-5.
FERRARI, Alberto a Marco RUSSO. Analyzing Data with Microsoft Power BI and Power Pivot for Excel. Redmond: Microsoft Press, 2017. ISBN 978-1-5093-0276-5.
LAURENČÍK, Marek. Excel 2019: Práce s databázemi a kontingenčními tabulkami. Praha: Grada, 2020. ISBN 978-80-271-1668-3.
MYŠÁK, Milan. Kontingenční tabulky a grafy: výukový průvodce. Brno: Computer Press, 2013. ISBN 978-80-251-4113-7.
Recommended Reading:
RUSSO, Marco a Alberto FERRARI. The Definitive Guide to DAX: Business Intelligence with Microsoft Excel, SQL Server Analysis Services and Power BI. Redmond, Washington: Microsoft Press, 2015. ISBN 978-0-7356-9835-2.
ALEXANDER, Michael, Dick KUSLEIKA a John WALKENBACH. Excel 2019 Bible. Indianapolis, IN: Wiley, [2019]. ISBN 9781119514787.
LAURENČÍK, Marek. Excel - pokročilé nástroje: funkce, makra, databáze, kontingenční tabulky, prezentace, příklady. Praha: Grada, 2016. ISBN 978-80.
NAVARRŮ, Miroslav. Excel 2019: podrobný průvodce uživatele. Praha: Grada, 2019. ISBN 978-80-247-2026-5.
RUSSO, Marco a Alberto FERRARI. The Definitive Guide to DAX: Business Intelligence with Microsoft Excel, SQL Server Analysis Services and Power BI. Redmond: Microsoft Press, 2015. ISBN 978-0-7356-9835-2.
Planned learning activities and teaching methods
Lectures, Tutorials
Assesment methods and criteria
Task TitleTask TypeMaximum Number of Points
(Act. for Subtasks)
Minimum Number of Points for Task Passing
CreditCredit85 45