Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

The project focuses on analyzing loan applicant data for IJS Bank Limited using MS Excel tools such as PowerQuery, Macro VBA, List Functions, and Data Validation. The goal is to create an interactive dashboard that provides insights into various client demographics and attributes. Key areas of analysis include gender ratio, car ownership, house ownership, client income type, education level, housing type, family status, and occupation type.

The report will utilize pivot charts to visualize the data, along with slicers for dynamic filtering. Macro VBA will automate repetitive tasks like updating data and refreshing the dashboard. The final dashboard will be visually appealing and informative, enabling the branch manager to make data-driven decisions based on the loan applicants' profiles.

https://drive.google.com/drive/folders/1xzwOil6ViTEAgjWPjUbTSgSKGcghRNVj?usp=drive_link

Thank You

Mohan Sahu