Skip to main content
Skip header
Close

Searching

Business Data Processing

Business Data Processing
157-0555/01
angličtina

Summary

The aim of the course is to familiarize students with the possibilities of Microsoft Excel spreadsheet for data analysis. The show will be applicable to the basic fuctions and advanced tools such as structured tables, pivot tables, Power Query tool for data transformations and Power Pivot add-in for managing data models. The Power BI tool for data visualization and report creation will also be presented.

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
Language of instruction angličtina
Code 157-0555
Abbreviation ZPDAEng
Course title Business Data Processing
Coordinating department Department of Systems Engineering and Informatics
Course coordinator Ing. Vítězslav Novák, Ph.D.