Capstone_Project_Case_Study

The Credit Card System database is an independent system developed for managing activities such as registering new customers and approving or canceling requests, etc., using the architecture. A credit card is issued to users to enact the payment system. It allows the cardholder to access financial services in exchange for the holder's promise to pay for them later. Below are three files that contain the customer’s transaction information and inventories in the credit card information.

• CDW_SAPP_CUSTOMER.JSON: This file has the existing customer details.
• CDW_SAPP_CREDITCARD.JSON: This file contains all credit card transaction information.
• CDW_SAPP_BRANCH.JSON: Each branch’s information and details are recorded in this file.

Read the JSON files using PySpark and Created DataFrames:

Loaded Them Into MySQL Database:

Here is a view of The Table on The MySQL Database:

Next we needed to make a Console

Here is a view of the Transactions Menu:

Here is a view of the Customers Menu:

Next we created some graphs/visualizations:

Find and plot which transaction type has a high rate of transactions.

Find and plot which state has a high number of customers.

Find and plot the sum of all transactions for the top 10 customers, and which customer has the highest transaction amount.

Now we connect to data from an onine Loan API to get more information on the banks transactions Used Get requests and pyspark to create a data frame

Used pyspark and sql connector jdbc to write to MySQL Database

Here is a view from the MySQL Database

Here are some Visualizations and Insights From The Data

Find and plot the percentage of applications approved for self-employed applicants.

Find the percentage of rejection for married male applicants.

Find and plot the top three months with the largest transaction data.

Find and plot which branch processed the highest total dollar value of healthcare transactions.