Unit 5: Data Modelling - Assignment 2 & 3 (Learning Aim B & C) (All Criterias Met)

Data Modelling – Assignment 2 Introduction: In this assignment, I have recently been chosen to join a new company as a trainee data analyst. Firstly, I will be willing to produce an efficient spreadsheet model which can predict the potential impact of exchange rate fluctuations on the company profit margins. From this, I will create designs for a data model so that each of the client requirements are met successfully which will include worksheet structure diagrams and being able to provide a test plan. Then, I will be reviewing the design with other clients to identify and inform improvements. Furthermore, I will be explaining my justification to how the requirements are fully fulfilled and then providing a well- detailed and reasoned evaluation of the optimised data model against client requirements that already exist.