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

The dashboard was created by creating pivot charts for all the required criteria and making a separate worksheet to view the data in a clear and attractive manner. Pie chart was used for gender ratio, column charts were used for car and house ownership, and bar charts were used for income, education, housing type, family status, and occupation type to make the data more visible. Gridlines were removed and shadow borders were added to make the dashboard attractive and easy to look at, and data labels were added.

To create the data summaries, the applicant data was copied into separate sheets to easily sort and filter the data and apply functions. Summary1 is for female client's income and loan amounts, Summary2 is for male, and Summary3 is for flag columns. The DCOUNT and DCOUNTA values are at the bottom of the data table in bold.

The VBA code is saved in the workbook. The pdf code was written to save in my computer's documents folder.

https://drive.google.com/drive/folders/19mmEAL-8wtTE2V0UFbRQwXL5_GJAhERx?usp=drive_link