|
Course Name (English)
|
BUSINESS ANALYTICS AND FINANCIAL MODELLING
|
| Course Code |
FIN534 |
| Course Description |
This course provides and introduction to the field of business analytics, which has been defined as the extensive use of data i.e. statistical and quantitative analysis, descriptive and predictive and prescriptive models. The use of Excel and Tableau as an analytics tool to support business analytics is discussed. Moreover, the application of selected data mining techniques to business decision making situations is also illustrated. Financial modeling is the art of building a model using excel to depict financial statements and scenario analysis. It builds a structure that integrates various statements and schedules to enable decision-making. Students actively participate in the delivery of this course through case, problem-based learning and project presentations. |
| Transferable Skills |
Demonstrate ability to gather, analyse and critically evaluate information for decisions making and recommendations. |
| Teaching Methodologies |
Lectures, Lab Work, Case Study, Simulation Activity |
| CLO |
| CLO1 |
Apply the theories, concept and applications of business analytics in supporting managerial decisions. (PLO6, C3) |
| CLO2 |
Display skills in using Tableau software and Microsoft Excel in data visualization and analysis. (PLO2, P2) |
| CLO3 |
Demonstrate managerial skills in data-driven business and finance environment. (PLO8, A3) |
|
| Pre-Requisite Courses |
No course recommendations |
| Reading List | | Recommended Text | - James R. Evans 2017, Business Analytics: Methods, Models, and Decisions., 2nd Edition. Ed., 16, Pearson College Division [ISBN: 0321997824]
|
|---|
| Reference Book Resources | - Simon Benninga,Benjamin Czaczkes 2014, Financial Modeling, 14 Ed., 18, MIT Press [ISBN: 9780262027281]
- Wayne Winston 2016, Microsoft Excel Data Analysis and Business Modeling, 5th Ed., Microsoft Press [ISBN: 9781509304219]
- Paul Pignataro 2013, Financial Modeling and Valuation, 1st Ed., John Wiley & Sons [ISBN: 9781118558768]
- Eric Soubeiga 2013, Mastering Financial Modeling: A Professional’s Guide to Building Financial Models in Excel, 1st Ed., McGraw Hill Professional [ISBN: 9780071808507]
- Eugene F. Brigham,Michael C. Ehrhardt 2016, Financial Management: Theory & Practice, 15th Ed., Cengage Learning [ISBN: 9781305632295]
- Chandan Sengupta 2009, Financial Analysis and Modeling Using Excel and VBA, 2nd Ed., John Wiley & Sons [ISBN: 9780470275603]
|
|---|
|
|---|
| Article/Paper List | This Course does not have any article/paper resources |
|---|
| Other References | This Course does not have any other resources |
|---|
|
