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

The "Attachment" is shown below:

https://drive.google.com/drive/folders/154c_LnObLtnENSKvLH912T8NEKOafMr5

Most of the part is done in Excel except for the VBA and a few other functions like unique which can be theoretically written here.

To create Pivot Table first Select the necessary data from the data source and then click on Insert-->Pivot Table

• 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
• Client’s Occupation Type
• All those are created in the drive

The separate worksheet is done for the following:

Separate Worksheet Required for

• Data Summary of All Female Clients for Income and Loan Amount using New Functions (hint: use unique,sort,filter functions) if These functions are not supported in your software please give a theoretical answer.
• Data Summary of All male Client’s for Income and Loan Amount using list Functions (hint:use dsum,daverage,..)
• Data Summary for all Flag Columns like (FLAG_DOCUMENT_2, FLAG_DOCUMENT_3 etc.) using all variants of DCOUNT function.

All done and calculated in the second part of the file

Hence the Vba code is done in the sheet

unique function: finds unique values in a range or array. It can work with any data type, including text, numbers, dates, and times.
=UNIQUE(array,[by_col],[exactly_once])