155-0555/01 – Business Data Processing (ZPDAEng)

Gurantor department	Department of Applied Informatics	Credits	4
Subject guarantor	Ing. Vítězslav Novák, Ph.D.	Subject version guarantor	Ing. Vítězslav Novák, Ph.D.
Study level	undergraduate or graduate	Requirement	Compulsory
Year	1	Semester	winter
		Study language	English
Year of introduction	2018/2019	Year of cancellation
Intended for the faculties	EKF	Intended for study types	Bachelor

Instruction secured by
Login	Name	Tuitor	Teacher giving lectures
NOV21	Ing. Vítězslav Novák, Ph.D.

Extent of instruction for forms of study
Form of study	Way of compl.	Extent
Full-time	Graded credit	1+2

Subject aims expressed by acquired skills and competences

To be able to process larger amounts of data using Microsoft Excel tools such as subtotals, pivot tables or PowerPivot add-in. To be able to process data from other applications. To be able to visualize data in Power BI.

Teaching methods

Lectures
Tutorials

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.

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

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

Way of continuous check of knowledge in the course of semester

Classified credit: - test: data analysis in Excel. - project in Power BI.

E-learning

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

Other requirements

Knowledge of the basics of Excel, such as working with workbooks, worksheets, cells, using formulas and basic functions.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

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 data model manager in Excel. 10) Power Query as a data import tool. 11) Data visualization with Power BI. 12) Introduction to the DAX language. 13) Using relationships in Power BI.

Conditions for subject completion

Full-time form (validity from: 2023/2024 Winter semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. počet pokusů
Graded credit	Graded credit	100	51	3

Mandatory attendence participation: Credit: - attendance at the seminars is not required, - successfully completed test, - processing of project according to the required structure and submission in LMS Moodle.

Show history

Conditions for subject completion and attendance at the exercises within ISP: Credit: - attendance at the seminars is not required, - successfully completed test, - processing of project according to the required structure and submission in LMS Moodle.

Show history

Occurrence in study plans

Academic year	Programme	Branch/spec.	Spec.	Zaměření	Form	Study language	Tut. centre	Year	W	S	Type of duty
2024/2025	(B0412EKF015) Financial and Accounting Advisory				P	English	Ostrava	1			Compulsory	study plan

Occurrence in special blocks

Block name	Academic year	Form of study	Study language	Year	W	S	Type of block	Block owner

Assessment of instruction

Předmět neobsahuje žádné hodnocení.