Creating and analyzing sql queries relating to loan

Assignment Help PL-SQL Programming

Reference no: EM133864615

Assessment - Practical SQL Coding and Report

Task

You are required to:
Complete each of the SQL queries, both provided and self-constructed.
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
Follow the instructions to create the lending club table and populate it with data from a dataset that would be available to you on the day of the assessment.

Section #1: Server Connection and Simple SQL Queries

Part 1: Updating the table to add a column
Details will be provided in class.

Part 2: Creating a SELECT Query
Details will be provided in class.

Section #2: SQL for Business Insights

Create an SQL statement that answers the following business questions:

Part 1: Creating and analyzing SQL Queries relating to Loan and Funded Amounts

Part 2: Creating SQL Queries relating to Loan Terms

Part 3: Creating SQL Queries relating to Interest Rates

Part 4: Creating SQL Queries relating to Loan Statuses

Part 5: Creating SQL Queries relating to Loan Grades

Part 6: Creating SQL Queries relating to Loan Defaults/Delinquencies

Section #3: SQL and Data Visualization for Business Insights 1000 words
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 public.
Using the above CSV file, carefully examine the columns that offer potential for creating at least three distinct visualizations.
These visualizations should aim to uncover valuable business insights to assist the manager in evaluating and approving loan applications more effectively. For instance, one visualization could analyse customer demographics to identify those most prone to default on their loans.

Take screenshots of each of the visualisations and paste that in your report for interpretation.

Reference no: EM133864615

Questions Cloud

Explain ethical principle in health care team like autonomy : Explain in detail ethical principle in health care team like- autonomy, Beneficence, Nonmaleficence, Justice, Fidelity, Disclosure, Paternalism.

How beryl could meet ethical requirements of collecting : Give at least 4 examples of how Beryl could meet the legal and ethical requirements of collecting, using and storing Mary and Frederick's information.

Relationship between human needs and human rights : What are the legal and ethical considerations regarding dignity of risk when supporting an older person or person with disability?

?identify pediatric patients show greater drug sensitivity : ?Identify why pediatric patients show greater drug sensitivity; and at what ages this sensitivity is the most pronounced.

Creating and analyzing sql queries relating to loan : DATA4200 Data Acquisition and Management, Kaplan Business School Create a SELECT statement that returns all rows and columns of data.

Which theory impacts organizational change the most : Which theory impacts organizational change the most?

What are clinical quality measures used for : Describe the general structure of the five clinical quality measures you identified and explain how they are reported.

Identify a patient care situation : Identify a patient care situation and describe how nursing care, or approaches to decision-making, differ between the BSN-prepared nurse.

Case study - addressing low user adoption of a new software : Prepare a simplified research report, including a short literature summary and a basic research proposal. The goal is to practice academic writing, analyse

User Account

All Pages