Sql and data visualization for business insights

Assignment Help Other Subject

Reference no: EM133815949

Data Acquisition and Management

Assessment - Practical SQL Coding and Report

Your 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
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

Part 2: Creating SQL Queries relating to Loan Terms
Part 3: Creating SQL Queries relating to Interest Rates Hire Homework Experts Now!
Create an SQL statement that answers the following business questions: Part 4: Creating SQL Queries relating to Loan Statuses (2 Marks) 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
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: EM133815949

Questions Cloud

Describe your thoughts on role health care professional play : Briefly summarize the presented issue. Describe your thoughts on the role health care professionals should play in resolving the ethical issue.

Feels sudden need to urinate through the day : Appears stated age; reports that over the last 2 months has been waking at night to urinate 5-6 times, feels a sudden need to urinate through the day

How can you capitalize on your strengths and improve : Consider the strengths and weaknesses of your writing. How can you capitalize on your strengths and improve on your weaknesses in future essays?

Feeling stressed due to financial difficulties : Ms. S.J. is a 58-year-old female who has voluntarily sought help at the clinic because she has been feeling stressed due to financial difficulties.

Sql and data visualization for business insights : Create a SELECT statement that returns all rows and columns of data. Export and save the results of the query as CSV file

Which occasionally radiates to his lower abdomen : Client presents with intermittent, intense pain in his right flank area, which occasionally radiates to his lower abdomen.

Patient admitted to telemetry unit : An 80-year-old-male patient admitted to the telemetry unit nurses notes 1930 received 80-year-old type 2 diabetes treated with metformin and glipizide

Describes the pain as stabbing : Client complains of sharp, intermittent, severe pain in his right flank that radiates towards the groin. Client describes the pain as stabbing 10/10 intensity

Patient sustained multiple abrasions on extremities-trunk : A 24-year-old male was admitted due to motor-vehicular accident. The patient sustained multiple abrasions on the extremities and trunk.

User Account

All Pages