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.
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 .
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 .
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 .