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
- 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])
- 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)
- For finding Data Summary for all Flag Columns , we use DCOUNT Function. DCOUNT(database,field,criteria)