Course detail

Methods for Solving Managerial Tasks

FP-MRMUAcad. year: 2022/2023

Students will primarily acquire knowledge and skills enabling effective analysis and transformation of source data into information usable in managerial decision-making, including subsequent interpretation (presentation) of results. At the same time, practical skills are developed using MS Office applications (with the main focus on MS Excel) for solving practical tasks and case studies.

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

Ing. Jan Luhan, Ph.D., MSc

Department

Institute of Informatics (ÚI)

Learning outcomes of the course unit

Students will acquire knowledge and skills to support managerial decision-making using common office applications and effective work with data.

Prerequisites

Not applicable.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Teaching takes place in the form of lectures, which have the character of explaining the discipline, content, terms, structure, methods and practical examples.
The exercises are focused on the development of practical skills in connection with the lectured topics.

Assesment methods and criteria linked to learning outcomes

To get a Unit-course credit, you need to get at least 50% of the points divided between Activity (10 points), Tests (15 points), and Semester project including its defence (25 points).

The exam consists of a practical and an oral part, while the resulting classification of the subject is according to the ECTS scale.

Completion of the course for students with an individual study plan:
Development and defence of a Semester project for Unit-course credit;
Standard exam (practical and oral part).

Course curriculum

01. System Approach for Solving Managerial Tasks (system and its modelling, analysis and simulation).
02. Use of Models in Managerial Practice (tabular, non-tabular and graphic models, engineering tables in MS Excel).
03. Use of MS Excel to Solve Managerial Tasks
04. Working with Data in MS Excel (Common tools and PowerPivot add-on)
05. Data Analysis in PowerPivot for MS Excel
06. DAX and Its Use
07. Working with Data in MS Power BI
08. Data analysis in MS Power BI
09. Advanced work with MS Power BI (own visualization, R language, ...)
10. - 12. Selected Optimization and Analysis Tasks (Case studies + involvement of experts from practice)
13. Interpretation of Outputs for Managers

Work placements

Not applicable.

Aims

To acquaint the listeners with the possibilities and tools that can be used in managerial decision-making with a focus on increasing the efficiency of the entire process based on effective work with data.

Specification of controlled education, way of implementation and compensation for absences

Attendance is controlled in predetermined terms related to the project's implementation or tests. Attendance in lectures and exercises is not obligatory but recommended. Students prove their activity by completing tasks for which they earn points for assessment.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

SÝKOROVÁ, K., J. BARILLA A P. SIMR. Microsoft Excel 2016: Podrobná uživatelská příručka. 1.vyd. Brno: Computer Press, 2016. 456 s. ISBN 978-80-251-4838-9.
BEZVODA, V. A M. BROŽ. Microsoft Excel 2007 pro manažery a ekonomy. 5. vyd. Brno: Computer Press, 2012. 440 s. ISBN 978-80-251-2116-0.
ŽITNIAK, J. Microsoft Office 2016: Podrobná uživatelská příručka. 1. vyd. Brno: Computer Press, 2017. 528 s. ISBN 978-80-251-4891-4.

Recommended reading

RALSTON, B. PowerPivot for Business Intelligence Using Excel and Sharepoint Berkeley: Apress, 2011. 299 p. ISBN 978-1-4302-3380-0.
WINSTON, W. L. Microsoft Excel 2013: Data Analysis and Business Modeling. 1st ed. California: O’Reilly Media, Inc., 2014. 889 p. ISBN 978-0-7356-6913-0.
MYŠÁK, M. Kontingenční tabulky a grafy: Výukový průvodce. 1. vyd. Brno: Computer Press, 2013. 224 s. 978-80-251-4113-7.
RUSSO, M. and A. FERRARI. The Definitive Guide to DAX: Business Intelligence with Microsoft Excel, SQL Server Analysis Services and Power BI. Washington: Microsoft Press, 2015. 1182 p. ISBN 978-0-7356-9835-2.
RUSSO, M. and A. FERRARI. Analyzing Data with Microsoft Power BI and Power Pivot for Excel. Washington: Microsoft Press, 2017. 250 p. ISBN 978-1-5093-0276-5.

eLearning

eLearning: currently opened course

Classification of course in study plans

  • Programme BAK-MIn Bachelor's, 2. year of study, summer semester, compulsory

Type of course unit

 

Lecture

13 hours, optionally

Teacher / Lecturer

Ing. Jan Luhan, Ph.D., MSc

Syllabus

  1. System Approach for Solving Managerial Tasks
  2. Use of MS Excel to Solve Managerial Tasks
  3. Effective Work with Data in MS Excel
  4. Use of MS Power BI to Solve Managerial Tasks
  5. Selected Optimization and Analysis tasks
  6. Interpretation of Outputs for Managers

Exercise

26 hours, compulsory

Teacher / Lecturer

Ing. Jan Luhan, Ph.D., MSc

Syllabus

01. System Approach for Solving Managerial Tasks (system and its modelling, analysis and simulation).
02. Use of Models in Managerial Practice (tabular, non-tabular and graphic models, engineering tables in MS Excel).
03. Use of MS Excel to Solve Managerial Tasks
04. Working with Data in MS Excel (Common tools and PowerPivot add-on)
05. Data Analysis in PowerPivot for MS Excel
06. DAX and Its Use
07. Working with Data in MS Power BI
08. Data analysis in MS Power BI
09. Advanced work with MS Power BI (own visualization, R language, ...)
10. - 12. Selected Optimization and Analysis Tasks (Case studies + involvement of experts from practice)
13. Interpretation of Outputs for Managers

eLearning

eLearning: currently opened course