Overview
As the economy moves towards more digital disruption, management are seeking innovative technologies for generating insights for decision making. The unit is designed to provide you with an understanding of how financial data of an organisation can be analysed for insights using data analytics. You are introduced to concepts, tools, software and methodologies of data science and how they are applied to the analysis of financial data. You will gain experience in analysing transaction data and financial ratios for segmentation, credit data for risk modelling, next best product offer, visualising data, and generating dashboards for performance reporting. This unit is suitable for students with minimal business, finance and information systems background.
Details
Pre-requisites or Co-requisites
Pre-requisite: ACCT28002 Accounting for Management Decision Making Co-requisite: ACCT28003 Business Analytics Techniques. Students enrolling in this unit must be undertaking the CL84 Master of Business Administration (International).
Important note: Students enrolled in a subsequent unit who failed their pre-requisite unit, should drop the subsequent unit before the census date or within 10 working days of Fail grade notification. Students who do not drop the unit in this timeframe cannot later drop the unit without academic and financial liability. See details in the Assessment Policy and Procedure (Higher Education Coursework).
Offerings For Term 2 - 2024
Attendance Requirements
All on-campus students are expected to attend scheduled classes - in some units, these classes are identified as a mandatory (pass/fail) component and attendance is compulsory. International students, on a student visa, must maintain a full time study load and meet both attendance and academic progress requirements in each study period (satisfactory attendance for International students is defined as maintaining at least an 80% attendance record).
Recommended Student Time Commitment
Each 6-credit Postgraduate unit at CQUniversity requires an overall time commitment of an average of 12.5 hours of study per week, making a total of 150 hours for the unit.
Class Timetable
Assessment Overview
Assessment Grading
This is a graded unit: your overall grade will be calculated from the marks or grades for each assessment task, based on the relative weightings shown in the table above. You must obtain an overall mark for the unit of at least 50%, or an overall grade of 'pass' in order to pass the unit. If any 'pass/fail' tasks are shown in the table above they must also be completed successfully ('pass' grade). You must also meet any minimum mark requirements specified for a particular assessment task, as detailed in the 'assessment task' section (note that in some instances, the minimum mark for a task may be greater than 50%). Consult the University's Grades and Results Policy for more details of interim results and final grades.
All University policies are available on the CQUniversity Policy site.
You may wish to view these policies:
- Grades and Results Policy
- Assessment Policy and Procedure (Higher Education Coursework)
- Review of Grade Procedure
- Student Academic Integrity Policy and Procedure
- Monitoring Academic Progress (MAP) Policy and Procedure - Domestic Students
- Monitoring Academic Progress (MAP) Policy and Procedure - International Students
- Student Refund and Credit Balance Policy and Procedure
- Student Feedback - Compliments and Complaints Policy and Procedure
- Information and Communications Technology Acceptable Use Policy and Procedure
This list is not an exhaustive list of all University policies. The full list of University policies are available on the CQUniversity Policy site.
Feedback, Recommendations and Responses
Every unit is reviewed for enhancement each year. At the most recent review, the following staff and student feedback items were identified and recommendations were made.
Feedback from Informal student feedback.
One student tried to publish their assessment in an International Journal. But the journal in assessment submitted to CQU Moodle were also detected in turnitin process by the publisher so they got high plagiarism score.
In future unit offerings, the students will be made more aware of the fact that CQU uses Turnitin and that publishers also may use this, so they need to be aware of this issue if they wish to publish their assessment results.
- Understand and distinguish alternative data analytics methods relevant to management decision making
- Apply data analytics to provide information for financial analysis, credit risk modeling and other applications using Numpy, Pandas and Matplotlib in Python
- Identify insights from financial data using machine learning approaches
- Apply visualization to reveal underlying data relationships using Tableau to inform decision making.
Alignment of Assessment Tasks to Learning Outcomes
Assessment Tasks | Learning Outcomes | |||
---|---|---|---|---|
1 | 2 | 3 | 4 | |
1 - Online Quiz(zes) - 20% | ||||
2 - Practical Assessment - 20% | ||||
3 - Project (applied) - 30% | ||||
4 - Take Home Exam - 30% |
Alignment of Graduate Attributes to Learning Outcomes
Graduate Attributes | Learning Outcomes | |||
---|---|---|---|---|
1 | 2 | 3 | 4 | |
1 - Knowledge | ||||
2 - Communication | ||||
3 - Cognitive, technical and creative skills | ||||
4 - Research | ||||
5 - Self-management | ||||
6 - Ethical and Professional Responsibility | ||||
7 - Leadership | ||||
8 - Aboriginal and Torres Strait Islander Cultures |
Textbooks
Corporate Finance
Edition: 12e (2021)
Authors: Ross Westerfield Jaffe
Mc Graw Hill
New York New York , US
Binding: eBook
IT Resources
- CQUniversity Student Email
- Internet
- Unit Website (Moodle)
- Python
- Zoom (both microphone and webcam capability)
- kaggle
All submissions for this unit must use the referencing style: American Psychological Association 7th Edition (APA 7th edition)
For further information, see the Assessment Tasks.
k.h.singh@cqu.edu.au
m.bojilov@cqu.edu.au
Module/Topic
Introduction to Financial Data Analytics
- Big Data Introduction
- What is Financial Data Analytics
- Why Financial Data Analytics
- Stages in Big Financial Data Analytics
- What is Big Financial Data Analytics Domain
- Big Financial Data Analytics Used Case
- Introduction to Python Fundamental
- Demonstration: Python Fundamental
Chapter
- Yves Hilpisch - Python for Finance_ Mastering Data-Driven Finance Book-O'Reilly (2018) Ch1 Ch2
- Yuxing Yan - Python for Finance-Packt Publishing (2017) Ch1 Ch2
- Joel Grus - Data Science from Scratch_ First Principles with Python-O'Reilly Media (2019) Ch 1
- Python Fundamental : https://github.com/jheikal/Python-for-beginner
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
Module/Topic
Financial Data Analytics using Python Fundamental
- Basic Numpy
- Basic Pandas
Chapter
- VanderPlas, Jacob T - Python data science handbook_ essential tools for working with data-O'Reilly Media (2017) Ch 2 Numpy Ch 3 Pandas
- Michael Heydt - Mastering pandas for Finance_ Master pandas, an open source Python Data Analysis Library, for financial data analysis-Packt Publishing (2015) Ch 1 Ch 2
- Python Fundamental : https://github.com/jheikal/Python-for-beginner
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
Module/Topic
Financial Data Analytics using Multi Linear Regression
FDA using Regression in Python can help finance and investment professionals as well as professionals in other businesses. Multi linear regression uses many independent variable to explain or predict the outcome of the dependent variable Y
Chapter
- VanderPlas, Jacob T - Python data science handbook_ essential tools for working with data-O'Reilly Media (2017) Ch 4
- Puneet Mathur - Machine Learning Applications Using Python_ Cases Studies from Healthcare, Retail, and Finance-Apress (2019) Ch 3
- Eryk Lewinson - Python for Finance Cookbook_ Over 50 recipes for applying modern Python libraries to quantitative finance to analyze data-Packt Publishing (2020) Ch 3
- Joel Grus - Data Science from Scratch_ First Principles with Python-O'Reilly Media (2019) Ch 14, 15
- Stephen Ross, Randolph Westerfield, Bradford D. Jordan - Fundamentals of Corporate Finance [Standard Edition]-McGraw-Hill _ Irwin (2009) Ch 13 CAPM
- Python Data Science : https://github.com/jheikal/SIF-Data_Science/tree/Big-Data/MLR
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
Module/Topic
Financial Data Analytics using Binary Logistic Regression
FDA using Logistic regression is the machine learning technique used in finance to predict the relationship between predictors (our independent variables) and a predicted variable (the dependent variable) where the dependent variable is binary (Credit default or Non Default)
Chapter
- Usman Zafar Paracha - Lite Statistics with Basic Steps in Python Programming Language (2020), Page 238
- Puneet Mathur - Machine Learning Applications Using Python_ Cases Studies from Healthcare, Retail, and Finance-Apress (2019) Ch 3
- Eryk Lewinson - Python for Finance Cookbook_ Over 50 recipes for applying modern Python libraries to quantitative finance to analyze data-Packt Publishing (2020) Ch 4
- (Chapman & Hall_CRC Data Mining and Knowledge Discovery Series) Jesus Rogel-Salazar - Advanced Data Science and Analytics With Python-Taylor & Francis L
- Stephen Ross, Randolph Westerfield, Bradford D. Jordan - Fundamentals of Corporate Finance [Standard Edition]-McGraw-Hill _ Irwin (2009) Ch 7,8Joel Grus - Data Science from Scratch_ First Principles with Python-O'Reilly Media (2019) Ch 16
- Python Data Science : https://github.com/jheikal/SIF-Data_Science/tree/Big-Data/LR
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
Module/Topic
Financial Data Analytics using Multinomial Logistic Regression
FDA using Multinomial logistic regression is used in Finance to predict categorical placement in or the probability of category membership on a dependent variable based on multiple independent variables. The independent variables can be either dichotomous (i.e., binary) or continuous (i.e., interval or ratio in scale).
Chapter
- Usman Zafar Paracha - Lite Statistics with Basic Steps in Python Programming Language (2020) Ch5
- Puneet Mathur - Machine Learning Applications Using Python_ Cases Studies from Healthcare, Retail, and Finance-Apress (2019) Ch 4
- Eryk Lewinson - Python for Finance Cookbook_ Over 50 recipes for applying modern Python libraries to quantitative finance to analyze data-Packt Publishing (2020) Ch5
- Stephen Ross, Randolph Westerfield, Bradford D. Jordan - Fundamentals of Corporate Finance [Standard Edition]-McGraw-Hill _ Irwin (2009) Ch 9,10
- (Chapman & Hall_CRC Data Mining and Knowledge Discovery Series) Jesus Rogel-Salazar - Advanced Data Science and Analytics With Python-Taylor & Francis L Ch 4
- Python Data Science : https://github.com/jheikal/SIF-Data_Science/tree/Big-Data/Multinomial%20LR
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
Module/Topic
Chapter
Events and Submissions/Topic
Module/Topic
Financial Data Analytics using Clustering
FDA using Clustering or cluster analysis in Finance is a machine learning technique, which groups the unlabelled dataset. It can be defined as "A way of grouping the data points (Financial Ratios) into different clusters, consisting of similar data points.
Chapter
- Puneet Mathur - Machine Learning Applications Using Python_ Cases Studies from Healthcare, Retail, and Finance-Apress (2019) Ch 9
- Eryk Lewinson - Python for Finance Cookbook_ Over 50 recipes for applying modern Python libraries to quantitative finance to analyze data-Packt Publishing (2020) Ch 6
- Stephen Ross, Randolph Westerfield, Bradford D. Jordan - Fundamentals of Corporate Finance [Standard Edition]-McGraw-Hill _ Irwin (2009) Ch 5.6
- Joel Grus - Data Science from Scratch_ First Principles with Python-O'Reilly Media (2019) Ch 20
- VanderPlas, Jacob T - Python data science handbook_ essential tools for working with data-O'Reilly Media (2017) Ch 4
- Python Data Science : https://github.com/jheikal/Python-for-Data-Scientist/tree/master/Clustering
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
- Assessment 2 is due by this week on Wednesday, 23 August 2023 at 6 PM AEST.
Practical Assessment 1 - Multi Linear Regression / Binary Logistic Regression / Multinomial Logistic Regression for Financial Industries Due: Week 6 Wednesday (21 Aug 2024) 6:00 pm AEST
Module/Topic
Financial Data Analytics using RFM
FDA using Recency, frequency, monetary value (RFM) is a Financial analysis tool used to identify a firm's best clients based on the nature of their spending habits.
Chapter
- Pyhton Data Science : https://github.com/jheikal/SIF-Data_Science/tree/Big-Data/RFM
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
Module/Topic
Financial Data Analytics using Market Basket Analytics
FDA using Market basket analysis is a machine learning technique used by companies to increase sales and increase product holdings by better understanding customer purchasing patterns.
Chapter
- Eryk Lewinson - Python for Finance Cookbook_ Over 50 recipes for applying modern Python libraries to quantitative finance to analyze data-Packt Publishing (2020) Ch10
- Stephen Ross, Randolph Westerfield, Bradford D. Jordan - Fundamentals of Corporate Finance [Standard Edition]-McGraw-Hill _ Irwin (2009) Ch 21,22
- Jason Scratch - Python Crash Course_ Python Machine Learning. Find out how you can use it for faster coding. Discover algorithms and strategy analysis for finance
- Python Data Science : https://github.com/jheikal/Python-for-Data-Scientist/tree/master/Market%20Basket
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
Module/Topic
Financial Data Analytics using Decision Tree
FDA using Decision Trees are a type of Supervised Machine Learning (that is you explain what the input is and what the corresponding output is in the training data) where the data is continuously split according to a certain parameter. The leaves are the decisions or the final outcomes.
Chapter
- Puneet Mathur - Machine Learning Applications Using Python_ Cases Studies from Healthcare, Retail, and Finance-Apress (2019) Ch 9
- Joel Grus - Data Science from Scratch_ First Principles with Python-O'Reilly Media (2019) Ch 17
- Stephen Ross, Randolph Westerfield, Bradford D. Jordan - Fundamentals of Corporate Finance [Standard Edition]-McGraw-Hill _ Irwin (2009) Ch 19,20
- VanderPlas, Jacob T - Python data science handbook_ essential tools for working with data-O'Reilly Media (2017) Ch 4
- Python Data Science : https://github.com/jheikal/SIF-Data_Science/tree/Big-Data/LDA
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
- Assessment 3 is due by this week on Wednesday, 13 September 2023 at 6 PM AEST.
Practical Assessment 2 - Clustering / RFM / Market Basket Analytics Model for Financial Industries Due: Week 9 Wednesday (11 Sept 2024) 10:00 pm AEST
Module/Topic
Financial Data Analytics using PCA
FDA using Principal Component Analysis (PCA) in FInance is a machine procedure that uses an orthogonal transformation that converts a set of correlated variables to a set of uncorrelated variables. PCA is the most widely used tool in exploratory data analysis and in machine learning for predictive models.
Chapter
- Puneet Mathur - Machine Learning Applications Using Python_ Cases Studies from Healthcare, Retail, and Finance-Apress (2019) Ch 9
- Eryk Lewinson - Python for Finance Cookbook_ Over 50 recipes for applying modern Python libraries to quantitative finance to analyze data-Packt Publishing (2020) Ch 8
- Stephen Ross, Randolph Westerfield, Bradford D. Jordan - Fundamentals of Corporate Finance [Standard Edition]-McGraw-Hill _ Irwin (2009) Ch 17,18
- VanderPlas, Jacob T - Python data science handbook_ essential tools for working with data-O'Reilly Media (2017) Ch 4
- Python Data Science : https://github.com/jheikal/SIF-Data_Science/tree/Big-Data/PCA
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
Module/Topic
Financial Data Analytics using Neural Network
FDA using neural network is a series of algorithms that endeavors to recognize underlying relationships in a set of data through a process that mimics the way the human brain operates. In this sense, neural networks refer to systems of neurons, either organic or artificial in nature
Chapter
- Puneet Mathur - Machine Learning Applications Using Python_ Cases Studies from Healthcare, Retail, and Finance-Apress (2019) Ch 14
- Eryk Lewinson - Python for Finance Cookbook_ Over 50 recipes for applying modern Python libraries to quantitative finance to analyze data-Packt Publishing (2020) Ch 11
- Joel Grus - Data Science from Scratch_ First Principles with Python-O'Reilly Media (2019) Ch 18
- Stephen Ross, Randolph Westerfield, Bradford D. Jordan - Fundamentals of Corporate Finance [Standard Edition]-McGraw-Hill _ Irwin (2009) Ch 23
- (Chapman & Hall_CRC Data Mining and Knowledge Discovery Series) Jesus Rogel-Salazar - Advanced Data Science and Analytics With Python-Taylor & Francis L Ch 4
- Python Data Science : https://github.com/jheikal/SIF-Data_Science/tree/Big-Data/Neural-Network
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
Module/Topic
FInancial Data Analytics using Data Visualization
Chapter
- WILLIAM GRAY - DATA SCIENCE FROM SCRATCH_ From Data Visualization To Manipulation. It Is The Easy Way! All You Need For Business Using The Basic Principles Of Python And Beyond
- Joel Grus - Data Science from Scratch_ First Principles with Python-O'Reilly Media (2019) Ch 3
Events and Submissions/Topic
- Quiz Pre-test 20 Questions (Please refer to Moodle)
- Quiz Post test 20 Questions (Please refer to Moodle)
Online Quiz Due: Week 12 Wednesday (2 Oct 2024) 12:00 pm AEST
Module/Topic
Reviewing all Chapters
Chapter
- Puneet Mathur - Machine Learning Applications Using Python_ Cases Studies from Healthcare, Retail, and Finance-Apress (2019)
- Eryk Lewinson - Python for Finance Cookbook_ Over 50 recipes for applying modern Python libraries to quantitative finance to analyze data-Packt Publishing (2020)
- Joel Grus - Data Science from Scratch_ First Principles with Python-O'Reilly Media (2019)
- Stephen Ross, Randolph Westerfield, Bradford D. Jordan - Fundamentals of Corporate Finance [Standard Edition]-McGraw-Hill _ Irwin (2009)
- Python Data Science : https://github.com/jheikal
Events and Submissions/Topic
Take-Home Exam is due by this week on Wednesday, 18 October 2023 at 3 PM AEST.
Practical assessment 3 (Final Exam) - PRINCIPLE COMPONENT ANALYSIS / DECISION TREE / NEURAL NETWORK Due: Review/Exam Week Wednesday (9 Oct 2024) 10:00 pm AEST
Module/Topic
Exam Assignment 3.
Chapter
Events and Submissions/Topic
- Coding
- Deck
- Journal
1 Online Quiz(zes)
Online Quiz(zes) encompassing of Multiple Choices.
- Pretest Score Quiz(zes) : Score will not be collected.
- Post test Quiz(zes) : Score will be collected
12
Weekly
Week 12 Wednesday (2 Oct 2024) 12:00 pm AEST
Every week and This is an individual Quiz separated by Pretest and Post test using GCR
Review/Exam Week Wednesday (9 Oct 2024)
Directly after Quiz submission
1 Question= 5 point
20 Questions = 100 point
- Understand and distinguish alternative data analytics methods relevant to management decision making
- Apply data analytics to provide information for financial analysis, credit risk modeling and other applications using Numpy, Pandas and Matplotlib in Python
- Identify insights from financial data using machine learning approaches
- Apply visualization to reveal underlying data relationships using Tableau to inform decision making.
2 Practical Assessment
The students can choose the Assignment topic from:
- CAPM
- APT
The students can choose the Assignment methods from:
- Multi Linear Regression using Python
- Binary Logistic Regression using Python
- Multinomial Logistic Regression using Python
This Assignment submission will be :
- Coding in Kaggle/Github/Jupiter Notebook
- Deck in PPT
- Journal in Word
Week 6 Wednesday (21 Aug 2024) 6:00 pm AEST
Submit your codes in Github/Kaggle, Deck and Journal to Moodle & GCR
Week 8 Wednesday (4 Sept 2024)
Feedback and Score will provided in Moodle
-
The assessment Criteria
- Coding : 30% (Scale 1-5)
- Deck : 30% (Scale 1-5)
- Journal : 40% (Scale 1-5)
- Apply data analytics to provide information for financial analysis, credit risk modeling and other applications using Numpy, Pandas and Matplotlib in Python
- Apply visualization to reveal underlying data relationships using Tableau to inform decision making.
3 Project (applied)
The students can choose the Assignment topic from:
- Clustering base on Financial Ratios
- Market Basket base on Retail Transactions
- RFM base on Bank Transactions
The students can choose the Assignment methods from:
- Clustering using Python
- RFM using Python
- Market Basket using Python
This Assignment submission will be :
- Coding in Kaggle/Github/Jupiter Notebook
- Deck in PPT
- Journal in Word
Please develop Clustering / RFM / Market Basket model for Banking Products to increase Sales and Product Holdings
Week 9 Wednesday (11 Sept 2024) 10:00 pm AEST
Submit your Github, Deck and Journal to Moodle & GCR
Exam Week Wednesday (16 Oct 2024)
Feedback and Score will be provided in Moodle
- Coding : 30% (Scale 1-5
- Deck : 30% (Scale 1-5)
- Journal : 40% (Scale 1-5)
- Identify insights from financial data using machine learning approaches
4 Take Home Exam
The students can choose the Assignment topic from:
- PCA and Clustering base on Financial Ratios
- Decision Tree base on Credit Approval
- Neural Network base on bank Transactions
The students can choose the Assignment methods from:
- Principle Component Analysis and Clustering using Python
- Decision Tree using Python
- Neural Network using Python
This Assignment submission will be :
- Coding in Kaggle/Github/Jupiter Notebook
- Deck in PPT
- Journal in Word
Review/Exam Week Wednesday (9 Oct 2024) 10:00 pm AEST
Please submit before the Due Date to Moodle & GCR
Exam Week Wednesday (16 Oct 2024)
The student will received the feedback on the certification of grades
The assessment Criteria
- Coding : 30% (Scale 1-5)
- Deck : 30% (Scale 1-5)
- Journal : 40% (Scale 1-5)
- Understand and distinguish alternative data analytics methods relevant to management decision making
- Apply data analytics to provide information for financial analysis, credit risk modeling and other applications using Numpy, Pandas and Matplotlib in Python
- Identify insights from financial data using machine learning approaches
As a CQUniversity student you are expected to act honestly in all aspects of your academic work.
Any assessable work undertaken or submitted for review or assessment must be your own work. Assessable work is any type of work you do to meet the assessment requirements in the unit, including draft work submitted for review and feedback and final work to be assessed.
When you use the ideas, words or data of others in your assessment, you must thoroughly and clearly acknowledge the source of this information by using the correct referencing style for your unit. Using others’ work without proper acknowledgement may be considered a form of intellectual dishonesty.
Participating honestly, respectfully, responsibly, and fairly in your university study ensures the CQUniversity qualification you earn will be valued as a true indication of your individual academic achievement and will continue to receive the respect and recognition it deserves.
As a student, you are responsible for reading and following CQUniversity’s policies, including the Student Academic Integrity Policy and Procedure. This policy sets out CQUniversity’s expectations of you to act with integrity, examples of academic integrity breaches to avoid, the processes used to address alleged breaches of academic integrity, and potential penalties.
What is a breach of academic integrity?
A breach of academic integrity includes but is not limited to plagiarism, self-plagiarism, collusion, cheating, contract cheating, and academic misconduct. The Student Academic Integrity Policy and Procedure defines what these terms mean and gives examples.
Why is academic integrity important?
A breach of academic integrity may result in one or more penalties, including suspension or even expulsion from the University. It can also have negative implications for student visas and future enrolment at CQUniversity or elsewhere. Students who engage in contract cheating also risk being blackmailed by contract cheating services.
Where can I get assistance?
For academic advice and guidance, the Academic Learning Centre (ALC) can support you in becoming confident in completing assessments with integrity and of high standard.