Information Support for Managers

Type of study	Follow-up MasterMaster
Language of instruction	Czech
Code	155-0357/02
Abbreviation	IPM
Course title	Information Support for Managers
Credits	4
Coordinating department	Department of Applied Informatics
Course coordinator	Ing. Vítězslav Novák, Ph.D.

Subject syllabus

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

Literature

WINSTON, Wayne. Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365). San Francisco, Microsoft Press, 2021. .
ALEXANDER, Michael and KUSLEIKA, Dick. Microsoft Excel 365 Bible. Indianapolis, John Wiley & Sons, 2022. .
DECKLER, Greg and POWELL, Brett. Mastering Microsoft Power BI - Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence. Birmingham, Packt Publishing, 2022. ISBN 978-1801811484.

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 Second Edition. Redmond, Washington: Microsoft Press, 2019. .
DECKLER, Greg. Learn Power BI - Second Edition: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence. Birmingham, Packt Publishing, 2022. .

back to search page