Loan Applicant Data Analysis and Reporting Dashboard
- Excel project for data analyst role at IJS Bank Limited
- Analyzed and reported on loan applicant data for the current quarter
- Created a comprehensive dashboard in MS Excel
- Features included gender ratio of applicants, car owner/non-owner ratio, house owner/non-owner ratio, client income type, client's level of education, client's housing type, client's family status, and client's occupation type
- Separate worksheets for data summaries of female and male clients' income and loan amount
- Used different functions for data analysis, including new functions and list functions
- Conducted data summary for flag columns using all variants of DCOUNT function
- Developed a macro for data formatting to automate conditional formatting and freezing panes
- Implemented VBA code to convert selected data into PDF format
- Utilized VBA code for spell-checking in the workbook
- Project showcases expertise in Excel, data analysis, dashboard creation, and VBA programming
- Provides valuable insights for informed decision-making in loan applicant management.