Data Management Level 3

Question 1

What was your first level 3 example?

Answer 1

Sharepoint

Question 2

What is a secure file transfer system?

Answer 2

• Method for securely sharing files between different locations or individuals.
• It uses encryption and other security measures to protect the data during transmission
  Key features include:
• Encryption
• Authentication
• Access control
• Audit trails

Question 3

Why did you advise on sharepoint? What are the pros?

Answer 3

It is a centralised location which can be accessed by authorised parties simultaneously
Pros
* Centralised collaboration
* Easy to track data
* Reduces duplication
* Secure
* Mobile access
Ensured i provided a good quality of service to my client
Was able to keep to timeframes as set out in ToE as we could track data received

Question 4

What are the cons of sharepoint?

Answer 4

Cons
* Complex to set up
* Security concerns if insufficient user training

Question 5

What else could you have used instead of sharepoint?

Answer 5

Google drive
- Less robust that SharePoint
- Limited customisation
Dropbox
- Limited collaboration features
- Can be ore expensive

Question 6

How did you ensure only authorised personnel have access to the sharepoint?

Answer 6

• Permission levels
• Granted access
• Strong passwords

Question 7

Why did you advise that it was password protected?

Answer 7

• Protect clients data
  Adhered to GDPR
• limited to its use
• kept confidential

Question 8

How did you ensure any limited access to the sharepoint?

Answer 8

I set up the data room
only i allowed access
i controlled access
only those working on the instruction and these the client requested gained access

Question 9

Did you consider other sites?

Answer 9

Yes however, this worked well for us with other clients so advised to use amongst other things

Question 10

What follow up advice did you give?

Answer 10

• Given the success we should continue to use for future quarterly valuations

Question 11

What was your second level 3 example?

Answer 11

Benchmark slides

Question 12

What was the purpose of the benchmark slides?

Answer 12

• Collate evidence in a centralised place
• Displayed clearly
• To help the wider valuations team provide high-level views on market transactions

Question 13

What was included in the slides?

Answer 13

• Occupational and investment Market updates
• Benchmark yields
• Recent transactions
• Date
• Parties
• Price
• NIY
• Beds

Question 14

What historic data did you analyse?

Answer 14

• Transaction volumes
• Supply and demand of student figures
• Transactional evidence
• Compared from the previous quarter

Question 15

Why did you use powerpoint?

Answer 15

• Best way to visually display

Question 16

How did you distribute to clients?

Answer 16

via email

Question 17

Was it safe to distribute by email?

Answer 17

• Yes only those who had opted in received the powerpoint

Question 18

What advice did you give for the benchmark slides?

Answer 18

• Helped to advise clients on market transactions

Question 19

How did it help to advise your client?

Answer 19

• They were aware on the PBSA market and current transactions
• Current BIC yields

Question 20

Did you advise on asset classes you have not regularly valued?

Answer 20

Only on transactions where I provided transaction details
I did not provide advice on assets that I was not competent on

Question 21

What advise did you give on other asset classes? Were you competent to do so?

Answer 21

Example – retail benchmarks etc
I ensured I had the sufficient skills and knowledge to advise my client on the benchmarks but nothing more

Question 22

Where was it stored?

Answer 22

• Only people in the department have access to these files
• All files are stored on my firms’ internal network which requires a double password to gain access. Each client’s file is named and dated

Question 23

What if there was an sensitive data in the slides?

Answer 23

• Not sensitive data was added to this as it was distributed externally

Question 24

Was there any confidential information in the benchmark slides?

Answer 24

no

Question 25

who were the benchmark slides shared with?

Answer 25

- paying clients who had signed up to them

Question 26

what historic data did you analyse?

Answer 26

- transactional evidence - supply and demand data - previous benchmark yields

Question 27

How frequent were the benchmark slides?

Answer 27

quarterly

Question 28

What advise did the slides help with?

Question 29

what valuation advice was provided to your high-profile client?

Question 30

how and where were the files stored?

Question 31

how were you qualified to provide advice on data management?

Answer 31

- rigorous training with compliance officer - CPD - if unsure - check with compliance officer

Question 32

How did you leverage data to improve client outcomes?