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

Project Title: Data Reporting of Loan Applicant Clients for Supply Chain Management companies using PowerQuery, Macro VBA, List Functions, and Data Validation functions in MS Excel

Description:

The objective of this project is to create a report using PowerQuery, Macro VBA, List Functions, and Data Validation functions in MS Excel for the loan applicant clients of Supply Chain Management companies. The report will be used by IJS Bank Limited to analyze loan applicant data and present an appropriate report on the shared data. The report will be demonstrated using a dashboard in MS Excel.

Features of Dashboard:

The dashboard will include the following features:

1. Gender Ratio of Applicants: This feature will display the ratio of male and female loan applicants.

2. Car Owner/Non-Owner Ratio: This feature will display the ratio of loan applicants who own a car and those who don't.

3. House Owner/Non-Owner Ratio: This feature will display the ratio of loan applicants who own a house and those who don't.

4. Client Income Type: This feature will display the types of income of the loan applicants such as salary, business, or others.

5. Client's Level of Education: This feature will display the level of education of the loan applicants such as high school, bachelor's degree, or others.

6. Client's Housing Type: This feature will display the housing type of the loan applicants such as apartment, villa, or others.

7. Client's Family Status: This feature will display the family status of the loan applicants such as married, single, or others.

8. Client's Occupation Type: This feature will display the occupation type of the loan applicants such as service, business, or others.

Tools and Technologies Used:

• MS Excel
• PowerQuery
• Macro VBA
• List Functions
• Data Validation functions

Outcome: The project will result in an interactive dashboard that will enable IJS Bank Limited to analyze loan applicant data and make informed decisions. The report will help the Manager of the Branch to understand the loan applicant demographics and their financial status. The project will demonstrate the power of PowerQuery, Macro VBA, List Functions, and Data Validation functions in creating data reports for Supply Chain Management companies.

LINK

https://drive.google.com/drive/folders/1X_U9Y3qkR8xdnQecjed9C2DX1qqGKQY9?usp=share_link