Creating sql queries relating to loan statuses

Assignment Help Database Management System

Reference no: EM133755121

Data Acquisition and Management

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

Questions Cloud

Under what conditions would you prefer one over the other : PRM 337 The University of Arizona Global Campus- Under what conditions would you prefer one over the other? Which strategy are you using in your project?

Nursing process-create and post teaching plan : Using the nursing process, create and post a teaching plan with one short-term goal and one long-term goal for the diabetic client,

Upholding ethical standards to their client population : These are expectations the nurse is supposed to carry out while providing safety and upholding ethical standards to their client population.

Visualization could analyse customer demographics : Visualization could analyse customer demographics to identify those most prone to default on their loans. Take screenshots of each of the visualisations

Creating sql queries relating to loan statuses : Creating SQL Queries relating to Loan Statuses and Creating SQL Queries relating to Loan Defaults/Delinquencies - Take screenshots of the query

Drug addiction is challenging but achievable goal : Examples of how to use information using Parenthetical citations to indicate sources for text Coping with drug addiction is a challenging but achievable goal.

Create tables for employees- managers and customers : IT 423 Suny Old Westbury- Create tables for Employees, Manager/Employee, Managers, and Customers. Include the appropriate attributes in the tables.

Facilitate the integration of evidence : The main responsibility of a healthcare leader in evidence-based healthcare is to guide and facilitate the integration of evidence

Server connection and simple sql queries : Manager in evaluating and approving loan applications more effectively. For instance, one visualization could analyse customer demographics

User Account

All Pages