Homework answers / question archive / Which customer's account saw the biggest percentage change between last month and this month? *last month balance = (this month balance - paid in) + paid out = 289-XXX-XXX-116 189-XXX-XXX-199 338-XXX-XXX-074 338-XXX-XXX-019 421-XXX-XXX-288 Primo Bank Ltd: Account Database (Extract taken from Buderim branch data) $0 ID Account type 289-XXX-XXX-117 Premium saver - joint 289-XXX-XXX-117 Gold current - joint 289-XXX-XXX-116 Standard current 189-XXX-XXX-199 Platinum credit card 189-XXX-XXX-211 Gold current 189-XXX-XXX-211 Standard credit card 338-XXX-XXX-116 Standard current - joint 338-XXX-XXX-116 Saver - joint 338-XXX-XXX-074 Standard credit card 338-XXX-XXX-019 Standard current 421-XXX-XXX-288 Student current Name Paid out J Thakrar / S Thakrar J Thakrar / S Thakrar $3,238

Which customer's account saw the biggest percentage change between last month and this month? *last month balance = (this month balance - paid in) + paid out = 289-XXX-XXX-116 189-XXX-XXX-199 338-XXX-XXX-074 338-XXX-XXX-019 421-XXX-XXX-288 Primo Bank Ltd: Account Database (Extract taken from Buderim branch data) $0 ID Account type 289-XXX-XXX-117 Premium saver - joint 289-XXX-XXX-117 Gold current - joint 289-XXX-XXX-116 Standard current 189-XXX-XXX-199 Platinum credit card 189-XXX-XXX-211 Gold current 189-XXX-XXX-211 Standard credit card 338-XXX-XXX-116 Standard current - joint 338-XXX-XXX-116 Saver - joint 338-XXX-XXX-074 Standard credit card 338-XXX-XXX-019 Standard current 421-XXX-XXX-288 Student current Name Paid out J Thakrar / S Thakrar J Thakrar / S Thakrar $3,238

Business

Share With

Which customer's account saw the biggest percentage change between last month and this month? *last month balance = (this month balance - paid in) + paid out = 289-XXX-XXX-116 189-XXX-XXX-199 338-XXX-XXX-074 338-XXX-XXX-019 421-XXX-XXX-288 Primo Bank Ltd: Account Database (Extract taken from Buderim branch data) $0 ID Account type 289-XXX-XXX-117 Premium saver - joint 289-XXX-XXX-117 Gold current - joint 289-XXX-XXX-116 Standard current 189-XXX-XXX-199 Platinum credit card 189-XXX-XXX-211 Gold current 189-XXX-XXX-211 Standard credit card 338-XXX-XXX-116 Standard current - joint 338-XXX-XXX-116 Saver - joint 338-XXX-XXX-074 Standard credit card 338-XXX-XXX-019 Standard current 421-XXX-XXX-288 Student current Name Paid out J Thakrar / S Thakrar J Thakrar / S Thakrar $3,238.12 N McBrydie $144.00 A Brock $299.82 E Rush $5,629.12 E Rush $2,877.12 H Radford / V Young $1,988.13 H Radford/V Young $0.00 L Palfreyman $189.45 M Gordon $1,890.74 S Bright $654.15 Paid in Balance $450.00 $20,237.18 $3,217.28 $1,278.20 $180 $245.34 $259 ($400.00) $7,889.54 $28,982.11 $2,877.12 $0.00 $1,800.12 ($597.12) $100 $500 $75.28 ($5,600.78) $2,000.35 $1,500.76 $686.12 $189.34 Overdraft limit $0 $3,000 $200 n/a $3,500 n/a $100 $0 n/a $200 0 Primo Account Types Held and Average Balances Primo Bank Ltd: Number of account types held 811,998 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 210,000 167,112 0 112,658 28,003 42,997 Gold current Platinum Premium saver credit card Saver Standard credit card Standard current 27,098 Student current Account Type Gold current Premium saver Saver Standard current Student current Average Balance ($) 2,688 23,005 5,000 575 101 Data Guidelines In line with the new guidelines surrounding data presentation and storage, below is a useful summary for you of the areas. Most team members believe that we are not in breach of any of the below. 1. 2. 3. Customer data can only be stored for up to six months Customer names should not be presented in extracted data tables It should be possible to link all transactions to the customer making them Customers' gender and ethnicity should not be stored without prior consent 4. Customer Transactions (Extract taken 9th June 2018) ID* last logged in latest transaction recent transactions 289-XXX-XXX-117 04/06/18:1816 $450 credit 15/05/18 $450 credit 15/04/18 $450 credit 15/03/18 $450 credit 15/02/18 289-XXX-XXX-116 07/06/18:0905 $4.57 debit 1/6/18 $12.87 debit 4/6/18 $2.40 debit 3/6/18 $11.23 debit 1/6/18 189-XXX-XXX-199 03/01/18:2304 $190.00 credit 5/6/18 $45.00 debit 5/6/18 $32.99 debit 4/6/18 $5.00 debit 3/6/18 289-XXX-XXX-116 05/06/16:1139 $74.80 debit 4/6/18 $880.12 debit 5/6/18 $37.45 debit 3/6/18 $2877.12 credit 2/6/18 338-XXX-XXX-116 12/12/17:0725 $100.00 credit 6/6/18 $109.27 debit 5/6/18 $2.78 debit 5/6/18 $98.76 debit 4/6/18 338-XXX-XXX-074 28/05/18:0905 $245.00 debit 1/6/18 $85.00 debit 29/5/18 $1007.00 debit 29/5/18 $2000.00 credit 28/5/18 189-XXX-XXX-199 07/06/18:1234 $1,890.74 credit 6/6/18 $32.99 debit 6/6/18 $82.00 debit 5/6/18 $44.00 debit 4/6/18 421-XXX-XXX-288 03/06/15:2305 $150.00 credit 6/6/18 $11.99 debit 6/6/18 $1.87 debit 6/6/18 $7.88 debit 6/6/18 *If a customer has multiple accounts, only data from one account is currently displayed in this view. The account with the most recent transaction is displayed.