155-0357/02 – Information Support for Managers (IPM)

Gurantor departmentDepartment of Applied InformaticsCredits4
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
Year1Semesterwinter
Study languageCzech
Year of introduction2019/2020Year of cancellation
Intended for the facultiesEKFIntended for study typesMaster, Follow-up Master
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 and Examination 0+3

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

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:

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

Recommended literature:

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

Credit: - test: data analysis in Excel. - project in Power BI. Exam: - oral - questions from the given topics in LMS Moodle.

E-learning

Other requirements

There are not additional requirements for students.

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 and Examination Credit and Examination 100 (100) 51
        Credit Credit 45  25
        Examination Examination 55  15 3
Mandatory attendence participation: Credit: - attendance at the seminars is not required, - processing of project according to the required structure and its defense, - test, - obtaining at least 23 points out of 45. Exam: - oral - questions from the given topics in LMS Moodle.

Show history

Conditions for subject completion and attendance at the exercises within ISP: Credit: - attendance at the seminars is not required, - processing of project according to the required structure and its defense, - test, - obtaining at least 23 points out of 45. Exam: - oral - questions from the given topics in LMS Moodle.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2024/2025 (N0413A050014) Economics and Management (S03) Economics and Law in Business P Czech Ostrava 1 Choice-compulsory type B study plan
2024/2025 (N0414A050001) Marketing and Business P Czech Ostrava 1 Choice-compulsory type B study plan
2023/2024 (N0414A050001) Marketing and Business P Czech Ostrava 1 Choice-compulsory type B study plan
2022/2023 (N0414A050001) Marketing and Business P Czech Ostrava 1 Choice-compulsory type B study plan
2021/2022 (N0414A050001) Marketing and Business P Czech Ostrava 1 Choice-compulsory type B study plan
2021/2022 (N0413A050014) Economics and Management (S03) Economics and Law in Business P Czech Ostrava Choice-compulsory type B study plan
2020/2021 (N0414A050001) Marketing and Business P Czech Ostrava 1 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
2020/2021 Winter