Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

Interactive dashboard created containing all the specified data in charts with appropriate slicers. All the pivot tables used to create the dashboard are hidden. Please unhide the sheets to see them. Only the dashboard, Applicant data, Data Summary are visible.

Data Summary of All Female Client’s for Income and Loan Amount using New Functions could not be included in the workbook as new functions are not available to me. So here is a theoritical explanation.

• All for the data is converted to a table called "Applicant_data".
• Filter fucnction is used to filter the data for female clients the formula is given below.
  •  Formula to filter for income amount =FILTER(Applicant_data[AMT_INCOME_TOTAL],Applicant_data[CODE_GENDER] = "F","Data not found")
  •  Formula to filter for loan amount =FILTER(Applicant_data[AMT_CREDIT],Applicant_data[CODE_GENDER] = "F","Data not found")
• Sum and average formulas can be applied on the filtered data to get the sum and average.

All the Macros related to the project are in applicant data worksheet

Excel workbook containing all the date is linked below through google drivers 

https://drive.google.com/file/d/1CrwtoYtwUCd2ozbWhl1NKN5Gd1HcnolM/view?usp=sharing