The project's goal is to collect the data from the bank database, clean the data, explore the required data with respect to company requirements, and then analyze the good loans, bad loans, bank amount funded, bank profit, bank loss, etc and create a dashboard using Tableau with respect to KPIs.
Step 1: Collect the necessary details about the Bank loan analysis report by the client.
Step 2: (Explore Process) Fletch the data from the client Database to "MS SQL Server".
Step 3: (Transform Process) Analyze, Clean, and extract the required data according to "Key Performance Indicators (KPIs)".
Step 4: Deal with the null, missing, and error data to project requirements using "MS SQL Server or Excel".
Step 5: (Load Process) Load the clean and transform data into a "Tableau".
Step 6: Create a Dashboard according to the requirement in "Tableau".
-> Better decision-making with respect to bad loans & good loans
-> Category-wise analysis like type, purpose, grade, and verification status.
