Data Analysis using Excel

In this project, I applied my SQL expertise to extract pertinent data from the database, focusing on critical lending metrics as outlined in the problem statement. Utilizing Excel, I crafted an interactive dashboard featuring IF statements to differentiate loans as 'Good' or 'Bad,' streamlining extensive data analysis. Moreover, I harnessed the power of pivot tables to address specific business inquiries identified in the problem statement, enriching the dashboard's functionality and delivering actionable insights for strategic decision-making.

• View Project