Creating a data reporting for Supply Chain Management companies

PROJECT 2

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

Separate Worksheet Required for

• Data Summary of All Female Client’s for Income and Loan Amount using New Functions (hint: use unique,sort,filter functions) if These functions are not supporting in your software please give a theoritical answer.
• Data Summary of All male Client’s for Income and Loan Amount using list Functions (hint:use dsum,daverage,..

ans: first we need to select only female clients using filter function  with a condition "f"

=fiter(range,range="f") from below data

after that we are making a summary out of it

Total female clients using COUNTA function

Total annual income of female clients using SUM function

Average Annual salary of all Female clients using AVERAGE function

Total credit by Female Client's  using SUM function

Average of annual credit by Female client's using AVERAGE FUNCTION FROM ABOVE DATA

 SAME FINDINGS FOR MALE ALSO

link:

https://drive.google.com/file/d/1e6FOl_RpANl5zDW52ljV47Go7iStUhr0/view?usp=share_link