Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
I have a project as a Business analyst in IJS BANK LIMITED. We must submit a report on Load Applicant Clients for the current quarter. I have to analyse load applicant data and present appropriate reports on share data. The information should be demonstrated using the dashboard in M.S. Excel.
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
LINK-: https://drive.google.com/file/d/1wJB-2jQNcida3p3ds7ghVxqxC0OWnaNE/view
Another work is required as follows-:
- 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.
And Create a Macro for data formatting and create a pdf and spelling checker using VBA code.
- Create a Macro for Data Formatting (Conditional Formatting, Freezing Panes) of the workbook as the same will be applied to the data for next quarter.
- Create VBA Code to convert selected data into pdf from applicant data.
- Check Spelling mistakes in the workbook using VBA Code.
LINK for Data Summary and VBA Code -: https://drive.google.com/file/d/1XpKioBp2Ey8cnrwr8iwywtjoLSZyvhMP/view?usp=docs_web
This finalizes the whole content regarding the final project of Excel.
LINK for Project -: https://drive.google.com/drive/u/0/folders/1avbN5KnThbtMHNlXDAaS5FzbQR1uIstn?lfhs=2