BKH_COBI Controlling and Business Intelligence

Faculty of Economics and Administration
Autumn 2023
Extent and Intensity
0/0/0. 6 credit(s). Type of Completion: k (colloquium).
Teacher(s)
Ing. Ladislav Šiška, Ph.D. (lecturer)
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
Fri 13. 10. 16:00–19:50 VT204, Sat 21. 10. 8:00–11:50 VT204, Sat 25. 11. 8:00–11:50 VT204
Prerequisites (in Czech)
BKH_MAUC Managerial Accounting && FORMA ( K )
Course Enrolment Limitations
The course is also offered to the students of the fields other than those 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 link knowledge of managerial accounting (=controllership) to the skill to apply IT tools supporting business intelligence (MS Excel, PowerPivot, 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. Controllership in theory and practice and its relation to managerial accounting
    • 2. Company-wide performance analysis, relationship of performance to financial position and cash flow
    • 3. Internal performance management, decomposition of the company into centers incl. their typology, evaluation of their contribution to corporate performance
    • 4. Planning and budgeting
    • 5. Standard costing and variance analysis (incl. analysis of contribution margins).
    • 6. Reporting. Dimensional data modeling (STAR scheme) applied in reportin. ETL processes
    • 7. IT tools for data analysis in MS Excel (PowerQuery and PowerPivot)
    • 8. Self-service business intelligence - principles, technologies, advantages of BI solutions against MS Excel
    • 9. Power BI - importing data and creating a simple data model
    • 10. Power BI - visualization of data from the data model into a report, bookmarks and setting of interactions among visuals.
    • 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
    • ATKINSON, Anthony A., Robert S. KAPLAN, Ella Mae MATSUMURA and S. Mark YOUNG. Management accounting : information for decision-making and strategy execution. 7th ed. Boston: Pearson, 2020. ISBN 978-1-61853-351-7. info
    • ATKINSON, Anthony A. Management accounting : information for decision-making and strategy execution. 6th ed. Boston: Pearson, 2012, 550 s. ISBN 9780273769989. info
    • 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
    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.
    Information on the extent and intensity of the course: tutorial 12 hodin.
    Information on course enrolment limitations: Minimální počet pro otevření předmětu je 10 zapsaných studentů. / The minimum number of enrolled students to open the course is 10.
    • Enrolment Statistics (recent)
    • Permalink: https://is.muni.cz/course/econ/autumn2023/BKH_COBI