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

1. Utilizing PowerQuery: The project involves using PowerQuery, a powerful data transformation and analysis tool in Excel, to import, clean, and transform loan applicant data from various sources. PowerQuery allows for efficient data preparation and enhances the accuracy and reliability of the analysis.

2. Implementing Macro VBA: The project requires the development of a macro using Visual Basic for Applications (VBA) to automate data formatting tasks. This includes applying conditional formatting to highlight specific criteria, such as loan defaults or high-risk applicants. The macro will also freeze panes for easier data navigation and analysis.

3. Leveraging List Functions: Excel's list functions, such as SUM, AVERAGE, and COUNT, will be employed to calculate various metrics and key insights from the loan applicant data. These functions enable quick and accurate calculations, providing valuable statistics for decision-making and evaluation.

4. Applying Data Validation Functions: Data validation functions in Excel will be used to set criteria and rules for input data. This ensures data integrity and consistency, preventing errors and inconsistencies in the loan applicant dataset. Validating inputs against specific requirements helps maintain data quality and reliability.

5. Creating a Dashboard-style Report: The project aims to present the loan applicant data analysis in a visually appealing dashboard format. The dashboard will incorporate charts, graphs, and tables to present key insights, trends, and metrics. This comprehensive report will provide a clear overview of the loan applicants' performance, facilitating informed decision-making for supply chain management companies.

https://drive.google.com/file/d/1otRd1fUsAuhjDXvXQsJlAHGuk5vRLPxh/view?usp=share_link