Information Support for Managers
| Type of study | MasterFollow-up Master |
|---|---|
| Language of instruction | Czech |
| Code | 157-0394/01 |
| Abbreviation | IPM |
| Course title | Information Support for Managers |
| Credits | 4 |
| Coordinating department | Department of Systems Engineering and Informatics |
| Course coordinator | Ing. Vítězslav Novák, Ph.D. |
Subject syllabus
1) Introduction to the topic, basic orientation in data, introduction to basic tools.
2) Data cleaning and preparation using Power Query.
3) Basic data analysis using Excel Pivot Tables.
4) Creating data models in Excel using Power Pivot.
5) Creating a managerial dashboard in Excel.
6) Introduction to Power BI.
7) Data visualization in Power BI.
8) Data models and calendar tables in Power BI.
9) Introduction to the Data Analysis Expressions (DAX) language.
10) Creating a managerial dashboard in Power BI.
11) Prediction, forecasting, and scenarios in Excel.
12) AI in data analysis.
2) Data cleaning and preparation using Power Query.
3) Basic data analysis using Excel Pivot Tables.
4) Creating data models in Excel using Power Pivot.
5) Creating a managerial dashboard in Excel.
6) Introduction to Power BI.
7) Data visualization in Power BI.
8) Data models and calendar tables in Power BI.
9) Introduction to the Data Analysis Expressions (DAX) language.
10) Creating a managerial dashboard in Power BI.
11) Prediction, forecasting, and scenarios in Excel.
12) AI in data analysis.
E-learning
Students have all presentations, assignments and exercises data in LMS Moodle.
Literature
WINSTON, Wayne. Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365). San Francisco, Microsoft Press, 2021. ISBN 978-0137613663 .
ALEXANDER, Michael and KUSLEIKA, Dick. Microsoft Excel 365 Bible. Indianapolis, John Wiley & Sons, 2022. ISBN 978-1119835103 .
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.
ALEXANDER, Michael and KUSLEIKA, Dick. Microsoft Excel 365 Bible. Indianapolis, John Wiley & Sons, 2022. ISBN 978-1119835103 .
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.
Doporučená literatura
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. ISBN 978-1509306978 .
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. ISBN 978-1801811958 .
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. ISBN 978-1509306978 .
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. ISBN 978-1801811958 .