Every business in the industry is generating loads of financial data. It is important to derive insights out of them to inform and optimize decision making. This course combines statistical tools with machine learning tools and algorithms, to equip the participants with the requisite skill set in analyzing data to achieve better financial results. Practical use-cases, such as financial performance analysis, forecasting, anomaly detection, loss and default modeling, will be discussed.
What You Will Learn
Upon completion of this course, the learners are expected to:
- recommend initiatives that would increase profitability, reduce cost, or optimize capital based on analytics and modeling done on finance and risk data; and
- perform financial and risk analysis using statistical, modeling, optimization, and simulation techniques in Excel.
You will need a computer or laptop with Microsoft Excel installed. Computer or laptop requirements are:
- For Windows: Core i3 or better, 4GB RAM or better, MS Excel 2007 or better
- For MacBook: ideally MS Excel 2013 or newer should be installed (some functions require this version on the Mac). If the version of MS Excel is 2011, download and install StatPlus.
Subject Matter Expert
Week 1: Relevance and Application of Analytics in Finance and Risk Management
5 Videos | 3 Activities
- Welcome to the course!
- Relevance of Analytics in Finance
- Relevance of Analytics in Risk Management
- Use-Cases of Analytics in Finance
- Use-Cases of Analytics in Management
- Exercise: Cloze Text and Matching Type
- Exercise: Use-Cases of Analytics
- Quiz: Analytics in Finance and Risk Management
Week 2: Analyzing Drivers and Influencers of Financial Performance Using Correlation Analysis
6 Videos | 3 Activities
- What is Correlation Analysis?
- What are the assumptions and limitations of Correlation Analysis?
- What are the benefits of using Correlation Analysis?
- Installing “Data Analysis” in Excel
- Calculating Correlation Coefficient in Excel
- Interpreting the Correlation Coefficient
- Decoding Correlation Analysis: Whack-a-Mole
- Exercise: True or False
- Exit Assessment: Correlation Analysis
Week 3: Forecasting Financial Performance using Regression Analysis
3 Videos | 3 Activities
- Application of Regression Analysis in Forecasting Business Metrics
- Data Diagnostic for Simple Linear Regression
- Interpreting the Results of Simple Linear Regression
- Mind Check: Anagram
- Exercise: Match-Up
- Exit Assessment: Regression Analysis
Week 4: Forecasting Financial Performance Use Time Series Analysis
5 Videos | 3 Activities
- What is Time Series Analysis?
- What are the applications of the Time Series Analysis in business and finance?
- Time Series Analysis using Excel
- Understanding the Forecast Output
- Using Time Series Forecast Results
- Exercise: Word Completion
- Mind Check: Anagram and Match-Up
- Exit Assessment: Time Series Analysis
Week 5: Forecasting Financial Performance Using Time Series Analysis
4 Videos | 2 Activities
- What are Anomalous Transactions?
- How Anomalous Transactions Impact the Business
- Detecting Anomalous Transactions
- Anomaly Detection Using Interquartile Range
- Decoding Anomalous Transaction: Flowing Grid
- Mind Check: Whack-a-Mole
- Exit Assessment: Anomalous Transaction
Week 6: Final Exam
1 Video | 2 Activities
- Key Takeaways
- Final Exam: Analytics Application in Finance and Risk Management