155-1327/01 – Data Analysis in MS Excel (ADE)

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	3	Semester	winter
		Study language	Czech
Year of introduction	2020/2021	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

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.

Teaching methods

Lectures
Experimental work in labs
Project work

Summary

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 a John WALKENBACH. Excel 2019 Bible. Indianapolis, IN: Wiley, [2019]. ISBN 9781119514787.

Recommended literature:

FERRARI, Alberto a 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 a Alberto FERRARI. The Definitive Guide to DAX: Business Intelligence with Microsoft Excel, SQL Server Analysis Services and Power BI. Redmond, Washington: Microsoft Press, 2015. ISBN 978-0-7356-9835-2.

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

Active participation in exercises. Elaboration and defense of project with respect to the required structure. Inserting this project into the LMS Moodle and obtaining a simple majority of the number of points.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

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

Conditions for subject completion

Full-time form (validity from: 2020/2021 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

Valid from	Valid until	Mandatory attendence participation
Sep 21, 2022 11:30:41 AM	Sep 21, 2022 11:40:20 AM	Credit: - active participation in exercises, - successfully completed test, - processing of project according to the required structure and submission in LMS Moodle.
Oct 4, 2019 11:32:59 AM	Sep 21, 2022 11:30:41 AM	Credit: - active participation in exercises, - processing of project according to the required structure and submission in LMS Moodle.

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

Valid from	Valid until	Conditions for subject completion and attendance at the exercises within ISP
Sep 21, 2022 11:30:41 AM	Sep 21, 2022 11:40:20 AM	Credit: - successfully completed test, - processing of project according to the required structure and submission in LMS Moodle.

Occurrence in study plans

Academic year	Programme	Form	Study language	Tut. centre	Year	Type of duty
2024/2025	(B0311A050015) Informatics in Economy	P	Czech	Ostrava	3	Compulsory	study plan
2023/2024	(B0311A050015) Informatics in Economy	P	Czech	Ostrava	3	Compulsory	study plan
2022/2023	(B0311A050015) Informatics in Economy	P	Czech	Ostrava	3	Compulsory	study plan
2021/2022	(B0311A050015) Informatics in Economy	P	Czech	Ostrava	3	Compulsory	study plan
2020/2021	(B0311A050015) Informatics in Economy	P	Czech	Ostrava	3	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

2023/2024 Winter

2022/2023 Winter