Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
DRIVE LINK : https://drive.google.com/drive/folders/1PqFsbel8oNChtLSFs3t-5srKmuPXLkQo
(For your Reference I will Attach the Screenshot also)
1.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
2.Separate Worksheet Required for
- Data Summary of All Female Client’s for Income and Loan Amount using New Functions
- Data Summary of All Male Client’s 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.
3.Other Deliverables
- Create a Macro for Data Formatting (Conditional Formatting, Freezing Panes) of workbook as 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
