155-1355/01 – Business data processing (ZPDA)

Gurantor departmentDepartment of Applied InformaticsCredits3
Subject guarantorIng. Vítězslav Novák, Ph.D.Subject version guarantorIng. Vítězslav Novák, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory type B
Year2Semesterwinter
Study languageCzech
Year of introduction2018/2019Year of cancellation
Intended for the facultiesEKFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
NOV21 Ing. Vítězslav Novák, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit 1+2

Subject aims expressed by acquired skills and competences

The aim of the course is to acquaint students with the basics of business intelligence and information support of teamwork using the Microsoft Office 365 office suite. At the end of the course students should be able to obtain information from more data using tools such as Microsoft Excel, Power Query, Power Pivot or Power BI.

Teaching methods

Lectures
Tutorials

Summary

The aim of the course is to acquaint students with the basics of business intelligence and information support of teamwork using the Microsoft Office 365 office suite. At the end of the course students should be able to obtain information from more data using tools such as Microsoft Excel, Power Query, Power Pivot or Power BI.

Compulsory literature:

WINSTON, Wayne. Microsoft Excel 2019 Data Analysis and Business Modeling. 6th edition. San Francisco, CA: Microsoft Press, 2019. ISBN 978-1509305889. 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.

Recommended literature:

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

Way of continuous check of knowledge in the course of semester

Zápočet: - test: analýza dat v Excelu, - projekt v Power BI.

E-learning

Credit: - test: data analysis in Excel. - project in Power BI.

Other requirements

No other requirements.

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: 2019/2020 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Credit Credit 85  45 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 yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2024/2025 (B0414A050001) Marketing (S02) Marketing and business P Czech Šumperk 2 Choice-compulsory type B study plan
2024/2025 (B0414A050001) Marketing (S02) Marketing and business P Czech Ostrava 2 Choice-compulsory type B study plan
2023/2024 (B0411A050001) Accounting and Taxes P Czech Ostrava 2 Choice-compulsory type B study plan
2023/2024 (B0411A050001) Accounting and Taxes P Czech Valašské Meziříčí 2 Choice-compulsory type B study plan
2022/2023 (B0411A050001) Accounting and Taxes P Czech Ostrava 2 Choice-compulsory type B study plan
2022/2023 (B0411A050001) Accounting and Taxes P Czech Valašské Meziříčí 2 Choice-compulsory type B study plan
2021/2022 (B0411A050001) Accounting and Taxes P Czech Valašské Meziříčí 2 Choice-compulsory type B study plan
2021/2022 (B0411A050001) Accounting and Taxes P Czech Ostrava 2 Choice-compulsory type B study plan
2020/2021 (B0411A050001) Accounting and Taxes P Czech Ostrava 2 Choice-compulsory type B study plan
2020/2021 (B0411A050001) Accounting and Taxes P Czech Valašské Meziříčí 2 Choice-compulsory type B study plan
2019/2020 (B0411A050001) Accounting and Taxes P Czech Ostrava 2 Choice-compulsory type B study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2023/2024 Winter
2022/2023 Winter
2021/2022 Winter
2020/2021 Winter