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

https://drive.google.com/file/d/16OTa5UcjYm2CBwPMHVtaNzZ7W33IN6eX/view?usp=sharing

1. For finding Data Summary of All Female Client’s for Income and Loan Amount , We can use unique, sort and filter functions.                             UNIQUE(array,[by_col],[exactly_once])                   SORT(array,[sort_index],[sort_order],[by_col])        FILTER(array,Include,[If_empty])
2. Finding Data Summary of All male Client’s for Income and Loan Amount , we use list functions.                                                                    DSUM(database,field,criteria)                                  DAVERAGE(database,field,criteria)
3. For finding Data Summary for all Flag Columns , we use DCOUNT Function.                                       DCOUNT(database,field,criteria)