Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
Project Google Drive Link:- https://drive.google.com/file/d/1D2oq0fClru0kN5BplMZ93lw-8UWPg5QH/view
Features of Dashboard
- 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
Separate Worksheet Required for
- Data Summary of All Female Clients for Income and Loan Amount Using New Functions
- Data Summary of All Male Clients for Income and Loan Amount using List Functions
- Data Summary for all Flag Columns like (FLAG_DOCUMENT_2, FLAG_DOCUMENT_3 etc.) using all variants of DCOUNT function.
