PROGRAM CONTENTS
Primers
- Foundation of Financial Modelling
- NCFM Pro Data Analytics & BI
- NCFM Pro Enterprise Risk Management (ERM)
- Certificate in Advanced Excel
- Credit Risk Management
Module 1: Foundations of Financial Analytics
- Financial data ecosystems
- KPIs across industries
- Analytical thinking in finance
- Data-driven decision frameworks
Module 2: Fundamentals of Statistics
- Descriptive Analysis
- Inferential Analysis
- Application of Linear & Logistic Regression in Finance
- Automation with Python for Reports
Module 3: Data Analytics & Visualization
- Data cleaning & transformation
- EDA for financial datasets
- Dashboarding using Power BI
- Visualization
- Hands-on: Build a Power BI dashboard
Module 4: Financial Modeling
- 3-statement integrated modeling
- Forecasting technique
- Scenario & sensitivity analysis
- Hands-on: Analysing the firm's performance from financial statement analysis
Module 5: Advanced Financial & Portfolio Analytics
- Introduction to fixed Income Analytics
- Estimation of Duration, Convexity
- Valuation of Forward, Futures, Swaps
- Black-Scholes Option Pricing Model
- Time series forecasting
- ARIMA, ARCH, GARCH, LSTM, Exponential smoothing for stock price forecasting
- Monte Carlo simulations
- Portfolio Optimization
- Portfolio Rebalancing
- Portfolio risk-return analytics
- Valuation analytics
- News Analytics
- Text Mining, Word Cloud
- Sentiment Analysis
Module 6: Risk Analytics
- Market risk Analytics
- Credit Risk (PD, LGD, EAD Models)
- Liquidity Risk
- Operational Risk
- Risk governance frameworks
- Regulatory capital (Based overview)
- Risk reporting & supervision
- Introduction to Enterprise Risk Management (ERM)
- Hands-on: Credit risk scoring model, VaR simulation, stress testing dashboard
Module 7: AI Applications & Tools for Financial Analysts
- AI tools used in Forecasting, Credit Modelling, Fraud detection
- NPL for financial Reports
- Additional Tools: Python basics, Power BI AI Visuals, Excel AI
- Prompt engineering
- Hands-on: Predictive financial models - AI-Driven insights generation
Module 8: AML for finance
- Core AML Frameworks
- Fraud detection patterns
- Intermediary risks
- Analytics in AML
- Rule-based vs AI-based monitoring
- Red flag indicators
- Case management systems
- Case Study: Real-world AML failure and penalties