MPH_CONT Controllership

Faculty of Economics and Administration
Autumn 2022
Extent and Intensity
0/3/0. 5 credit(s). Type of Completion: k (colloquium).
Teacher(s)
Ing. Ladislav Šiška, Ph.D. (lecturer)
Ing. Petr Mikuš, Ph.D. (seminar tutor)
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, except Mon 12. 9., except Mon 31. 10., 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 MS PowerQuery, MS PowerPivot, MS Power BI).
Learning outcomes
At the end of this course, the student will be able to:
  • define controllership and usual content of the controller' work in enterprises;
  • understand financial management principles applied in particular corporation;
  • analyze the variances between planned (= budgeted, standard) and actual results of business operations;
  • summarise and interpret significant varinaces in a report for the relevant manager;
  • use advanced user functions (pivot tables, automatic filters) of the spreadsheet;
  • extract, transform and load data (ETL) with MS PowerQuery to data model in MS PowerPivot;
  • change data model in PowerPivot, date tables, types and directions of relations between tables;
  • use DAX to define custom columns and measures;
  • ask a database server for data data using SELECT clause of SQL language;
  • use MS Power BI Desktop (including standard visuals, bookmarks, DAX calculations) to create own reports;
  • combine data from different areas of business economics, management and business informatics in own reports;
  • present and support with data his/her conclusions about efectivness of the specific intra-company department.
    • 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 incl. SQL database sources, 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
    • 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
    • BOURGEOIS, David T. and ET AL. Information Systems for Business and Beyond. Open Textbooks, 2019. URL info
      recommended literature
    • FRANKLIN, Mitchell, Patty GRAYBEAL and Dixon COOPER. Principles of Accounting, Volume 2: Managerial Accounting. Houston (Texas): Rice University, OpenStax, 2019. ISBN 978-1-947172-60-9. URL info
    • DRURY, Colin. Management and cost accounting. 10th edition. Hampshire: Cengage, 2018, xvii, 842. ISBN 9781473748873. info
    Teaching methods
    Lectures; demonstration how to calculate the 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 example calculations (2) presentation and defence of report containing conclusions from student's analysis of efectivness of the specific intra-company department. Minimum success rate 60%.
    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 2020, Autumn 2021, Autumn 2023, Autumn 2024.
    • Enrolment Statistics (Autumn 2022, recent)
    • Permalink: https://is.muni.cz/course/econ/autumn2022/MPH_CONT