Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
In part-1
- The solutions for the given question are in ABOUT APPLICANT DATA AND IN SHEET-1
- And pivot charts are not supporting in my excel because of the huge data... so I have provided the pie chart..
In part-2
1)
- New Functions are not supporting in my software..so, I am answering in theoritical way.
- For all females clients the total income is 31588428942 .
- For all females clients the total loan amount given is 1.20004E+11
2)
- solution is in SHEET-2
3)
- Solution is in APPLICANT DATA (DT COL)
In part-3
1)
- solution is in SHEET-3
2)
- Solution is in SHEET-4
3)
- Solution is in SHEET-4 Itse