Comprehensive Financial Data Analysis with Excel ,SQL, DAX and Power BI
In my recent project, I analyzed financial data consisting of over 38,000 records related to loans, aiming to uncover valuable insights to improve decision-making. I utilized SQL for data cleaning and preparation, while Power BI was used to design a dynamic, three-page dashboard:
Summary: Provides an overall view of loan performance.
Overview: Features advanced visual analysis of loan distributions and categories.
Details: Offers in-depth insights into each loan for further understanding.
Such tools empower financial teams to enhance lending strategies and drive efficiency.