How many customers defaulted on their loan obligations

Assignment Help PL-SQL Programming

Reference no: EM133619369

Data Acquisition and Management

Exercise - Practical SQL Coding

Your Task

You are required to:

Complete each of the SQL queries, both provided and self-constructed.

Take a screenshot of each of the queries and results - copy and paste these into your report.

In your Report, explain and summarise the business insights found from executing the SQL queries and the data visualisations.

Background

The SQL Server contains data on Peer-to-Peer Lending. Connection details will be provided on the day of the assessment.

Assessment Instructions

Section #1: Server Connection and Simple SQL Queries

Part 1: Connection to SQL Server on the Cloud
Follow the instructions and Connect to the Yugabyte SQL Cloud Server.

Part 2: Simple SELECT Query
Create a SELECT statement that selects the first 10 rows for all columns of data.
Take a screenshot of the query and its result and paste that in your report.

Section #2: SQL for Business Insights

Part 1: Loan and Funded Amounts
Execute the SQL script provided for loan amounts. Interpret the results of the query as comment in your query script.
Modify the SQL statement to show the number customers where the funded amount is:
Equal to $10,000 dollars
Less than $10,000 dollars
Greater than $10,000 dollars

Take screenshots of the above queries, its result and paste same in your report for interpretation.

Part 2: Loan Terms
Create an SQL statement that counts the number of the loans based on terms. Take a screenshot of your SQL statement and the corresponding results and paste same in your report.
How many terms (count of loans) are of 36 months? How many are of 60 months? Take screenshots of the query and its result and paste that in your report for interpretation.

Part 3: Interest Rate
Create an SQL statement that answers the following business questions:
What is the average interest rate?
What is the highest interest rate?
What is the lowest interest rate?

Take screenshots of the query and its result and paste that in your report for interpretation.

Part 4: Loan Status
Create an SQL statement that:
Counts the number of loans for each unique loan status.
For each of the unique statuses found above, create an SQL statement that displays the first 100 rows of data.

Take screenshots of the query and its result and paste that in your report for interpretation.

Part 5: Loan Grades
Create and SQL statement that answers the following business questions:
Display each Loan Grade and the count of the number of loans related to it.
Display each loan sub-grade and the count of the number of loans related to it.

Take screenshots of the query and its result and paste that in your report for interpretation.

Part 6: Loan Defaults/Delinquencies
Create an SQL statement that answers the following questions:
How many customers defaulted on their loan obligations?
Take screenshots of the query and its result and paste that in your report for interpretation.

Section #3: SQL and Data Visualization for Business Insights

Part 1: Data Acquisition and Data Visualisations
Create a SELECT statement that returns all rows and columns of data.
Export and save the results of the query as CSV file.
Import the CSV file in either PowerBI or Tableau.
Select the following variables for visualisations:
ID, Member ID, Loan Amount, Funded Amount, Term, Interest Rate, Term, Instalment, Grade, Sub-Grade, Employee Length, Home Ownership, Annual Income, Verification Status, Issue Date, Loan Status, Purpose, Address State, DTI, Earliest Credit Line, Outstanding Principal, Total Payment, Recoveries, Collections, Last Payment Date, Last Payment Amount, and Application Type.
From the data selected, create 3 kinds of unique visualisations, to discover more business insights, and interpret the results. Carefully consider the columns that are used for each kind of visualization.

Additionally, can you identify the kinds of customers that default on their loans?

Reference no: EM133619369

Questions Cloud

Comfortable with hierarchical organization : How would you go about encouraging an organization led by management that is traditional and very comfortable with hierarchical organization

Agile project management and highsmith framework : Select three to five characteristics of Scrum that you feel exemplify the foundations of agile project management and Highsmith's framework.

Display each loan grade and the count of the number of loans : Create an SQL statement that counts the number of the loans based on terms. Take a screenshot of your SQL statement and the corresponding results and paste same

What are their thoughts on accepting others as they are : Edu 602- Analyze the practice of Inclusion by reading and analyzing the case study He's Just Goofy Guy. What are their thoughts on accepting others as they are?

How many customers defaulted on their loan obligations : DATA4200 Data Acquisition and Management, Kaplan Business School - Evaluate ethical data acquisition and best practice about project initiation

Incorporate personal opinions and perspectives : Describe why this theory is (or is not) an appropriate theory for understanding leaders. Incorporate personal opinions and perspectives

How you may use the clinical behavioral spectrum : SOWK 505- How you may use the Clinical Behavioral Spectrum when working with children and adolescents experiencing mental health concerns.

Original concept that jeff bezos had for amazon : You are introduced to the original concept that Jeff Bezos had for Amazon - to create a distributor with zero inventory, zero facilities, and zero overhead.

Explain why you agree-disagree with statement made in video : CHS 495V- Explain why you agree/disagree with a statement made in the video. Include the quote and the role of the quoted person (teacher, parent, director, etc

User Account

All Pages