Evaluating and approving loan applications

Assignment Help Database Management System

Reference no: EM133755111

Assessment - Practical SQL Coding and Report

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
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
Part 1: Creating and analyzing SQL Queries relating to Loan and Funded Amounts
Take screenshots of the above queries, its result and paste same in your report for interpretation.

Part 2: Creating SQL Queries relating to Loan Terms
Take screenshots of the query and its result and paste that in your report for interpretation.

Part 3: Creating SQL Queries relating to Interest Rates
Create an SQL statement that answers the following business questions:
Take screenshots of the query and its result and paste that in your report for interpretation.

Part 4: Creating SQL Queries relating to Loan Statuses
Take screenshots of the query and its result and paste that in your report for interpretation.

Part 5: Creating SQL Queries relating to Loan Grades
Take screenshots of the query and its result and paste that in your report for interpretation.

Part 6: Creating SQL Queries relating to Loan Defaults/Delinquencies
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.

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: EM133755111

Questions Cloud

Registered nurses authority in florida : An example of a primary difference between a registered nurse's authority in Florida and that of a practical nurse's authority

Write a speech analysis informative speech and persuasive : Write a speech analysis, informative speech and persuasive. One page each they should be very interesting for the audience to listen and they should be engaging

What do you think about these grants : What do you think about these grants? it encourages nurses in clinical settings to apply evidence-based to practice and evaluate the effects on patient outcomes

What role do you think denver plays in this novel : Because of the title of the novel, the character of Beloved tends to grab and hold our attention, but what role do you think Denver plays in this novel?

Evaluating and approving loan applications : Visualizations should aim to uncover valuable business insights to assist the manager in evaluating and approving loan applications more effectively

Blood glucose monitoring for woman with gestational diabetes : Blood glucose monitoring for a woman with gestational diabetes should be done: Blood glucose monitoring for a woman with gestational diabetes

Explain the organizations current position in the market : Briefly describe the sport organization that you have selected for your pitch deck. Explain the organization's current position in the market.

Client was treated with sex hormones during pregnancy : A client was treated with sex hormones during pregnancy. Which teratogenic effects might the nurse observe in the newborn if the client gave birth to a girl?

Explain how your sport organization can help the prospective : Explain how your sports organization can help the prospective partner achieve its business objectives.

User Account

All Pages