Alert-O-Monitor

“Alert-O-Monitor” is a one-stop solution for managing end-to-end flow of Early Warning Signals. We are not only focusing on “Alert Generation”, but we are also doing “Alert Monitoring”, “Alert Resolution” as well as “Alert Prediction” giving a complete 360-degree comprehensive solution which NONE of the Banks have implemented till now.

Data Engineering

1. Create Microsoft Lakehouse named AOM_Lakehouse.
2. Under the Data Engineering folder, we have Raw Files sub-folder which has all the raw-data files and these files can be uploaded into the lakehouse files and create tables on top of it.
3. Under the Data Engineering folder, we have Lookup Files sub-folder which has all the loop-up files and these files can be uploaded into the lakehouse files and create tables on top of it.
4. Once the Tables are created, Pick up all the notebooks from the Data Engineering folder.
5. Run all the notebooks(note: main notebook needs to be run at the end).

Data Science

1. Under the Data Science folder, two notebooks named loan_prediction_new and product_recommendations can be run.
2. For the voice analytics notebook, we have a pre-requisite to create a storage account key and openAI credentials are required.
3. Place the audio files present in the Audio Files in the azure storage account gen2 and run the notebook named voice_analytics.

Data Modeling

1. Create a new semantic model on top of the lakehouse.
2. Create the relationships as shown in below.

Data Analysis

1. We create a powerBI report on the lakehouse that we have created.
2. Under the Data Analysis folder, we have the powerbi report uploaded use it and re-point to the lakehouse that is created. 3.This is how the power bi report looks as shown below: