Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
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
Answer:- Answer in the given link file.(https://drive.google.com/file/d/1ZsofnB77NDRQ-P0SDCT7TpA9G_VzES9q/view?usp=share_link)
A separate Worksheet is 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 the DCOUNT function.
Answer:- Answer in the given link file.(https://drive.google.com/file/d/1ZsofnB77NDRQ-P0SDCT7TpA9G_VzES9q/view?usp=share_link)
Other Deliverables
- Create a Macro for Data Formatting (Conditional Formatting, Freezing Panes) of the workbook as the same will be applied to the data of next quarter
- Create VBA Code to convert selected data into pdf from applicant data
- Check Spelling mistakes in the workbook using VBA Code
Answer:- Answer in the given link file.(https://drive.google.com/file/d/1ZsofnB77NDRQ-P0SDCT7TpA9G_VzES9q/view?usp=share_link)
(https://drive.google.com/file/d/1MM1XtONQ12ES-yz0k-VyyBs2e9xn_zQM/view?usp=share_link)