Course Information Undergraduate prospectus

Financial Business Intelligence

Course summary

Course code: COMP1238
Level: 6
Credits: 30
School: Business Faculty
Department: Accounting and Finance
Course Coordinator(s): Frederico Farinas-Almeida

Specification

Aims

This course aims to develop a student’s financial modelling and analysis abilities which are important skills necessary for supporting financial decision-making. Using a variety of analysis and modelling applications, tools and techniques, this course provides students with both a greater insight into current financial applications and methods, and highly marketable skills.

Learning outcomes

On successful completion of this course a student will be able to:

1. Apply their financial knowledge and computing skills to practical modelling situations using the principles of spreadsheet model building.

2. Display enhanced spreadsheet skills and well-developed modelling and programming skills.

3. Critically analyse and interpret a typical financial business problem and create an appropriate integrated solution using VBA and Microsoft Office applications.

4. Apply theoretical budgeting knowledge to develop forecasts, standard and complex reports and budgeting analyses using IFP software or advanced Excel modelling with VBA.

5. Analyse a “big data” case study problem and develop a Qlikview business intelligence software solution.

6. Consolidate, interpret and communicate analytical findings to non-financial readers accurately and effectively.


Indicative content

• Principles methodologies for modelling practice.
• Develop enhanced spreadsheet skills through a series of case study problems.
• Apply modelling methodologies and VBA programming skills to complex business analysis and financial problems using Excel and other Microsoft Office applications.
• Develop the skills to solve similar problems as above using medium to large business analysis software, such as IFP.
• Develop the skills and knowledge to create a business intelligence solution using software, such as Qlikview.
• Critically analyse the advantages and disadvantages of the three main types of software used and identify situations when one is better than the other.
• Consolidate, interpret and communicate analytical findings to non-financial readers accurately and effectively using business reports.

Teaching and learning activity

This course will be delivered through 2 hour weekly computer lab sessions using a case study approach to develop the skills and understanding of the learning outcomes.

To facilitate and support independent learning, students will be provided with weekly exercises to test and apply methods taught in-class to other case study problems. An online set of reference materials and reading list is also provided to cover general background and more specialist and topical material drawn from the industry experts, specialist forums, prescribed textbooks/handbooks and also commentaries issued by practitioners.

Assessment

User model – Financial Appraisal - 30% weighting, 40% pass mark, learning outcomes 1-3 & 6. Outline Details - Model and 1500 word report.
Corporate model -Budgeting - 30% weighting, 40% pass mark, learning outcomes 3-4. Outline Details - Model.

Consultancy model – Qlikview - 40% weighting, 40% pass mark, learning outcomes 5-6. Outline Details - Model and 30 minute Demo/presentation.