Report using Power Query, Macro and VBA for Supply Chain Management companies

As a Business Analyst for IJS Bank Limited, I analyzed loan applicant data to create a dashboard report in MS Excel. The report includes charts, tables, and graphs that provide insights into the loan applicant's demographics, creditworthiness, and financial capacity. It also highlights key performance indicators and provides recommendations for loan approval, interest rates, and loan terms. The final deliverable is a user-friendly and easy-to-navigate dashboard report that summarizes the key insights and recommendations.

Project Link ↓