Operations reporting (data visualisation):
- Decide KPIs to measure for consumer banking/commercial banking/wealth management/back office operations
- Connect to external database/files
- Configure relational database
- Construct basic charts
- Filter data
- Load dashboard into PowerBI cloud
Data mining (web scraping):
- Basic web scraping
- Organise output into tables/JSON files
- Load file and clean data
- Load script into AWS Lambda/GCP Cloud Functions for periodic scraping
- Data storage and extraction
Data mining (optical character recognition):
- Basics of OCR technology
- Install and run Tesseract
- Pre-process image to improve OCR results
- Store results for future extraction
- Predictive analytics:
- Definition of Customer Lifetime Value, decide which algorithm to use
- Pre-process data
- Model selection: Classification, Generalised Linear Model (GLM)
- Interpret results
- Load script into AWS Lambda/GCP Cloud Functions for continuous updates
Interactive agents:
- Define scope: customer service/product enquiry etc.
- Create conversation flow
- Input list of intents and entities
- Link chatbot to BigQuery
- Measure response accuracy rate