Execute the sql script provided for loan amounts

Assignment Help PL-SQL Programming

Reference no: EM133617491

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?

Note: Use dbeaver server in place of Yugabyte SQL Cloud Server

Reference no: EM133617491

Questions Cloud

Potential to contribute to diversity within pharmacy school : How does this experience demonstrate your potential to contribute to diversity within pharmacy school?

Define what the ecq means to you : Define what the ECQ means to you. Provide examples of any personal experience you've had with theparticular ECQ. Present ideas on how you could develop the ECQ.

Analyze the malpractice case for the standard : Analyze the malpractice case for the standard of care provided to the victim.

Nurse practitioner has completed medication : A nurse practitioner has completed a medication, reconciliation of a patient who has been admitted following a motor vehicle accident among the many drugs

Execute the sql script provided for loan amounts : Execute the SQL script provided for loan amounts. Interpret the results of the query as comment in your query script - Create an SQL statement that counts

Rural population to demonstrate respect for client autonomy : What actions could you provide for a patient from rural population to demonstrate respect for client autonomy?

What difference between systems analyst and business analyst : What is the difference between a Systems Analyst and a Business Analyst when dealing with systems analysis and design?

Why would the reimbursement rate decrease for hospital : Why would the reimbursement rate decrease for this hospital? What should the hospital do determine why the infection rates are high?

Pain instead of pharmaceutical drugs : Acupuncture, breathing exercises, and yoga should be prescribed to treat PTSD and pain instead of pharmaceutical drugs.

User Account

All Pages