MPH_CONT Controllership

Faculty of Economics and Administration
Autumn 2020
Extent and Intensity
0/3/0. 5 credit(s). Type of Completion: k (colloquium).
Teacher(s)
Ing. Ladislav Šiška, Ph.D. (lecturer)
Ing. Ladislav Šiška, Ph.D. (seminar tutor)
Guaranteed by
Ing. Ladislav Šiška, Ph.D.
Department of Business Management – Faculty of Economics and Administration
Contact Person: Vlasta Radová
Supplier department: Department of Business Management – Faculty of Economics and Administration
Timetable of Seminar Groups
MPH_CONT/01: Mon 10:00–12:50 VT105, L. Šiška
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The aim of the course is to apply knowledge of management accounting to the cases of a fictitious companies by means of modern tools for analysing and reporting data (namely PowerQuery, PowerPivot, Power BI).
Learning outcomes
At the end of this course, the student will be able to:
  • define controlling and usual work of a controller in a company;
  • understand the rules for economic (= financial) management in particular enterprise; prepare operational business plans and budgets;
  • analyze the variances between the planned (= budgeted, standard) results and the results actually achieved by the business;
  • interpret and present significant variances in the form of a report for the relevant manager;
  • use advanced user functions (pivot tables, automatic filters) of the spreadsheet;
  • extract, transform and load data (ETL) with PowerQuery to data model in PowerPivot;
  • change data model in PowerPivot, date tables, types and directions of relations between tables;
  • use DAX for definition of own measures and for materialisation of PowerPivot tables into Excel Sheets;
  • work with MS Power BI Desktop (including knowledge of standard visuals, bookmarks, advanced DAX metrics and calculations).
  • Syllabus
    • 1. Knowledge review - enterprise performance management and its informational support through management accounting
    • 2. Knowledge review - Internal performance management, decomposition of the company into centers incl. their typology, evaluation of their contribution to corporate performance.
    • 3. Assigning costs by means of Activity Based Costing (ABC).
    • 4. Strategic planning and budgeting. Balanced Scorecard.
    • 5. Source data for financial reporting. Datasets structure in relational databases v. datawarehouse. Dimensional data modeling (STAR scheme) applied in reporting. ETL processes.
    • 6. IT tools for data analysis in MS Excel (PowerQuery and PowerPivot). Different types of sources and their combination. Data model (technologically MS SSAS Tabular at the background of PowerPivot).
    • 7. Self-service business intelligence - principles, technologies, advantages of BI solutions against MS Excel
    • 8. Basics of DAX (Data Analysis eXpressions). Its application to pivot tables and to materialisation of PowerPivot tables in Excel Sheets.
    • 9. Power BI - data import, creating data model, data visualisation in the report
    • 10. Non-financial data in managerial accounting (=controllership). Automated ETL of nonfinancials in Power BI.
    • 11.-12. Students' presentations of their projects
    Literature
      required literature
    • ESCHENBACH, Rolf and Helmut SILLER. Profesionální controlling : koncepce a nástroje. Translated by Jaroslav Rubáš. 2., přeprac. vyd. Praha: Wolters Kluwer Česká republika, 2012, xiv, 381. ISBN 9788073579180. info
    • POUR, Jan, Miloš MARYŠKA, Iva STANOVSKÁ and Zuzana ŠEDIVÁ. Self service business intelligence : jak si vytvořit vlastní analytické, plánovací a reportingové aplikace. První vydání. Praha: Grada, 2018, 350 stran. ISBN 9788027106165. URL info
    • POPESKO, Boris and Šárka PAPADAKI. Moderní metody řízení nákladů : jak dosáhnout efektivního vynakládání nákladů a jejich snížení. 2., aktualizované a rozší. Praha: Grada Publishing, 2016, 263 stran. ISBN 9788024757735. URL info
      recommended literature
    • BARNEY, Jay B. and Trish Gorman CLIFFORD. What I didn't learn in business school : how strategy works in the real world. Boston: Harvard Business Review Press, 2010, xxiii, 234. ISBN 9781422157633. info
    • DRURY, Colin. Management and cost accounting. Ninth edition. Hampshire: Cengage Learning, 2015, xix, 827. ISBN 9781480893931. info
    • ATKINSON, Anthony A. Management accounting : information for decision-making and strategy execution. 6th ed. Boston: Pearson, 2012, 550 s. ISBN 9780273769989. info
    Teaching methods
    Lectures; demonstration of calculation of common part of assignment of practical examples; instructional videos; homework and individualized tasks in MS Excel, LibreOffice Calc, Power BI Free; class discussion of the presented students' projects
    Assessment methods
    Requirements: (1) continuous activity and correct results of practical examples calculations (50 points) (2) presentation of reports from practical project and discussion of the solution (50 points). Minimum success rate 60 points.
    Language of instruction
    Czech
    Further comments (probably available only in Czech)
    The course is taught annually.
    General note: Pro studenty oboru PEM bude adekvátně navýšen rozsah výuky (2/2) a garant upřesní její obsah.
    Credit evaluation note: "Studentům končícího oboru ESF 6208T086 PEM bude navýšení +3 kredity.".
    The course is also listed under the following terms Autumn 2009, Autumn 2010, Autumn 2011, Autumn 2012, Autumn 2013, Autumn 2014, Autumn 2015, Autumn 2016, Autumn 2017, Autumn 2018, Autumn 2019, Autumn 2021, Autumn 2022, Autumn 2023, Autumn 2024.
    • Enrolment Statistics (Autumn 2020, recent)
    • Permalink: https://is.muni.cz/course/econ/autumn2020/MPH_CONT