Course: Financial Lab

« Back
Course title Financial Lab
Course code MUFU/1FILE
Organizational form of instruction Seminary
Level of course Master
Year of study 2
Semester Winter
Number of ECTS credits 5
Language of instruction English
Status of course Compulsory, Compulsory-optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Jemberu Etsub Tekola, Ph.D.
  • Dehning Bruce, assoc. prof. Ph.D.
Course content
Introduction to Alteryx and Data Analytics Industry Analysis With Data Analytics Strategic Analysis With Data Analytics Customer Analysis With Data Analytics Introduction to Relational Databases Data Analytics for Internal Audit Data Analytics for Inventory Analysis Data Analytics for Tax Analytics Forecasting With Data Analytics

Learning activities and teaching methods
Lecturing, Dialogic (Discussion, conversation, brainstorming), Simple experiments, Practice exercises, Teamwork, Translation analysis, Analysis of a presentation
  • Home preparation for classes - 33 hours per semester
  • Term paper - 78 hours per semester
  • Participation in classes - 39 hours per semester
prerequisite
Knowledge
- Basic knowledge of Financial Accounting. - Understanding introductory Finance terms.
- Basic knowledge of Financial Accounting. - Understanding introductory Finance terms.
learning outcomes
- identify business applications where data mining concepts and tools can be used to answer accounting questions
- identify business applications where data mining concepts and tools can be used to answer accounting questions
- describe data structures, sources, and methods for assessing data quality
- describe data structures, sources, and methods for assessing data quality
- explain data mining classification and prediction models in plain English
- explain data mining classification and prediction models in plain English
- define the applications of data analytics in financial accounting, managerial accounting, auditing, and taxation
- define the applications of data analytics in financial accounting, managerial accounting, auditing, and taxation
- understand how to evaluate analytical models using mathematical and logical techniques
- understand how to evaluate analytical models using mathematical and logical techniques
- describe how to translate data into meaningful business information
- describe how to translate data into meaningful business information
- identify the principles behind competitive advantage analysis using financial data
- identify the principles behind competitive advantage analysis using financial data
Skills
- collect, extract, clean, and transform data for analysis using Alteryx
- collect, extract, clean, and transform data for analysis using Alteryx
- link data in organized and meaningful ways to form relational databases
- link data in organized and meaningful ways to form relational databases
- analyze financial performance through techniques like ROA decomposition
- analyze financial performance through techniques like ROA decomposition
- create forecasting models to predict business objectives
- create forecasting models to predict business objectives
- identify potential fraud or errors through data analysis and comparison of expected versus actual results
- identify potential fraud or errors through data analysis and comparison of expected versus actual results
- communicate key findings from data analysis in a clear and professional manner
- communicate key findings from data analysis in a clear and professional manner
- apply data analytics techniques to solve problems in financial accounting, managerial accounting, auditing, and taxation
- apply data analytics techniques to solve problems in financial accounting, managerial accounting, auditing, and taxation
teaching methods
Knowledge
Activating (Simulation, games, dramatization)
Activating (Simulation, games, dramatization)
Exercises on PC
Exercises on PC
Individual work of students
Individual work of students
Practice exercises
Practice exercises
Text analysis
Text analysis
Skills
Activating (Simulation, games, dramatization)
Activating (Simulation, games, dramatization)
Exercises on PC
Exercises on PC
Individual work of students
Individual work of students
Practice exercises
Practice exercises
Text analysis
Text analysis
assessment methods
Knowledge
Analysis of the student's performance
Analysis of the student's performance
Analysis of works made by the student (Technical products)
Analysis of works made by the student (Technical products)
Grade (Using a grade system)
Grade (Using a grade system)
Recommended literature
  • Baruti, R. Learning Alteryx: A beginner's guide to using Alteryx for self-service analytics and business intelligence. Packt Publishing, 2017. ISBN 978-1788392655.
  • Bierman, H., Smidt, S. Financial Management for Decision Making. Washingto, 2003. ISBN 1-58798-212-9.
  • Burkhow, J. Alteryx Designer: The Definitive Guide: Simplify and Automate Your Analytics. O'Reilly Media, 2023. ISBN 978-1098107529.
  • Dehning, B., Stratopoulos, T., and Mohapatra, P. Accounting Analytics With Alteryx. 2025.
  • Green, T. Alteryx for Accounting, Tax and Finance Professionals. 2021. ISBN 979-8578651236.
  • Houghton, P. Data Engineering with Alteryx: Helping data engineers apply DataOps practices with Alteryx. Packt Publishing, 2022. ISBN 978-1803236483.
  • Rohilla Shalizi, C. Advanced Data Analysis from an Elementary Point of View. 2025.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester