Practical sql coding and report assessment

Assignment Help PL-SQL Programming

Reference no: EM133865373 , Length: word count:1000

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.
Submit your query script file (.sql) with all your queries using the SQL link within the assessment time limit of 2 hours, i.e. In class.

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
Part 2: Creating a SELECT Query

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.

Reference no: EM133865373

Questions Cloud

Write the linear programming model including the objective : Write the linear programming model, including the objective function, constraints, and decision variables, in mathematical notation.

Make purchases for products or services : Think about retailers from which you make purchases for products or services. Choose the product or service and then select two retailers

Decision-making software makes decisions for supervisors : Decision-making software makes decisions for supervisors. leads users through the steps of the formal decision-making process.

Managing emotions : Goals: To make the student focus and pay attention during the lesson, Ability to follow instructions, Managing emotions.

Practical sql coding and report assessment : 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

How does the rise of gen z and millennial travelers impact : How does the rise of Gen Z and millennial travelers impact the product development strategies of tourism businesses?

Develop narrative timeline : Develop a narrative timeline in which you discuss five formative leadership experiences that have had an impact on your life.

What are possible causes of a low potassium level : What are possible causes of a low potassium level? What action should the nurse take in relation to the serum potassium level?

Example we will add the lan interface : Add an Interface to snort for monitoring. In this example we will add the LAN interface and as the homework you have to configure WAN interface

User Account

All Pages