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

Unit 5: Data Modelling - Assignment 2 & 3 (Learning Aim B & C) (All Criterias Met). VERIFIED 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. Nature of the problem: The nature of the problem is that number of challenges that the user has previously been faced and this would be the currency change issue that resulted with inaccuracy with both pounds and euros.