Skip to main content
Skip header
Close

Searching

Business Data Processing

Type of study Bachelor
Language of instruction English
Code 157-0555/01
Abbreviation ZPDAEng
Course title Business Data Processing
Credits 4
Coordinating department Department of Systems Engineering and Informatics
Course coordinator Ing. Vítězslav Novák, Ph.D.

Subject syllabus

Lectures:
1) Addressing in Excel.
2) Excel Statistical Functions.
3) Excel Other Functions.
4) Formatting in Excel.
5) Charts in Excel.
6) Lists in Excel.
7) Structured Tables in Excel.
8) Pivot Tables and Charts.
9) Power Pivot as the Data Model Manager in Excel.
10) Power Query as the Data Import Tool.
11) Data Visualization with Power BI.
12) Introduction to the DAX language.
13) Using Relationships in Power BI.

E-learning

Students have all presentations, assignments and exercises data in LMS Moodle.

Literature

WINSTON, Wayne. Microsoft Excel 2019 Data Analysis and Business Modeling. 6th edition. San Francisco, CA: Microsoft Press, 2019. ISBN 978-1509305889.
ALEXANDER, Michael, Dick KUSLEIKA and John WALKENBACH. Excel 2019 Bible. Indianapolis, IN: Wiley, 2019. ISBN 978-1119514787 .
DECKLER, Greg and Bret POWELL. Microsoft Power BI Cookbook: Gain expertise in Power BI with over 90 hands-on recipes, tips, and use cases. Birmingham, IN: Packt Publishing, 2021. ISBN 978-1801813044 .

Advised literature

FERRARI, Alberto and Marco RUSSO. Analyzing Data with Microsoft Power BI and Power Pivot for Excel. Redmond, Washington: Microsoft Press, 2017. ISBN 978-1-5093-0276-5.
RUSSO, Marco and Alberto FERRARI. The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel. Redmond, Washington: Microsoft Press, 2019. ISBN 978-1509306978 .


back to search page