Happy to share this Streamlit app that analyzes a NPL portfolio having as input an excel file
This app is an example of how any excel file can be transformed to a web app providing a more sophisticated view and analysis of the data, that can be used in corporate environment in conference meetings, calls etc.
The raw data used as input for the app can be found in the Appendix tab.
App Features/Functionalities included:
Password protection (password is mentioned in the main page just to show the functionality)
Excel summary report download with pivot tables and graphs
Interactive graphs like treemaps, funnel based on user input i.e., top 10/20/30 clients etc.
Similar to Xlookup/Vlookup functionalities in the Data Extraction tab.
I would appreciate the community’s feedback, and any comments, suggestions, or revisions!
App link: