Bank-Loan-Analysis-using-Excel

Project Overview:

Analyzing vast amounts of bank loan application data can be like navigating an uncharted territory. Just as sifting through mountains of unorganized data requires significant effort, traditional loan analysis necessitates meticulous cleaning and interpretation. This project proposes a data visualization solution using Excel to act as a compass for loan officers. By leveraging clear visualizations, loan officers can gain a deeper understanding of applicant information, identify trends, and make data-driven decisions to optimize loan approval processes.

Data Source:

Initially the Data set available in "Finanacial_loan.csv" format, which is used for the analysis of "Bank_Loan_Analysis.xlsx" file, which contains the details of the Loans.

Tools:

• Excel

Steps I have done in this Project:

• Data loading and inspection.
• Handling missing values and empty rows.
• Data cleaning and formatting.
• Converting the data into a table.
• Modifying into a Pivot tables.
• Usage of FUNCTIONS in the process.
• Creating dashboards through the Visuals.
• Preparation of Report Documentation.

If you want to see the Problem statement.

Click the link https: https://docs.google.com/document/d/1xZakVeqO5ToiDf4Zp9l4j-aClgeDdKaS/edit?usp=drive_link&ouid=114333817142387546359&rtpof=true&sd=true

If you want to know the more details of the Analysis. Check out the Documentation Manual.

Click the link https://drive.google.com/file/d/1p_VFBPtB29kNHP1BoKrULaRxAULhcbg5/view?usp=drive_link

Screenshots of Report Pages:

Summary Dashboard

Overciew Dashboard

Detailed View