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

Introduction: Unit 5 – Learning Aim B Data Modelling – Assignment 2 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. Functions the model must perform: For the section, there are many functions that the model must perform. Generally, these functions require complex calculation that is built in the project named “Microsoft Excel”. The functions that currently exist in this project are: SUM – This function will be used to calculate the total cost between number1 and number2 by adding up these together. An example could be adding all numbers in the cells of B1 and F5 and then providing the equals sign to get the total cost of the product. AVERAGE – This function is used to average all the numbers in the cells from B1 to F5. Also, this function can also be entered as part of a formula in a cell of a worksheet. COUNT – This function is usually used to count the number of cells that contains numbers and then counts the numbers within the list of arguments. Additionally, this function will get the number of entries in a number field that includes range of array of numbers. An example of this could be entering the following formula to count the numbers in the range. COUNTIF – This function is generally used to count how many numbers in cells B1 to F5 are higher than 50. Also, it will also be used to count how many 70s are in the cells from B1 to F5. The counting process will be