CKH_CONT Controllership

Faculty of Economics and Administration
Autumn 2022
Extent and Intensity
0/0/0. 6 credit(s). Type of Completion: zk (examination).
Teacher(s)
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
Wed 19. 10. 8:00–11:40 S315, 13:00–16:40 S315, Wed 23. 11. 8:00–11:40 S315, 13:00–16:40 S315, Thu 12. 1. 14:15–16:00 S315
Prerequisites (in Czech)
(TYP_STUDIA(C) && OBOR(EMAOB))
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 manufacturing and merchandising 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;
  • 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).
  • 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
    • 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
    • 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
      recommended literature
    • 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
      not specified
    • HORVÁTH & PARTNERS MANAGEMENT CONSULTANTS. The Controlling Concept: Cornerstone of Performance Management. München (Germany): Verlag Franz Vahlen GmbH, 2020, 276 pp. ISBN 978-981-12-1864-4. Available from: https://dx.doi.org/10.1142/11778. URL 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 (40 points) (2) presentation of reports from practical project and discussion of the solution (60 points). Minimum success rate 60 points.
    Language of instruction
    Czech
    Further comments (probably available only in Czech)
    The course is taught annually.
    Information on the extent and intensity of the course: tutorial 16 hodin.
    Credit evaluation note: Studentům oboru PEM bude navýšení +3 kredity.
    The course is also listed under the following terms Autumn 2020, Autumn 2024.
    • Enrolment Statistics (Autumn 2022, recent)
    • Permalink: https://is.muni.cz/course/econ/autumn2022/CKH_CONT