UNIT 5 DATA MODELLING ASSIGNMENT 2

UNIT 5 DATA MODELLING ASSIGNMENT 2 Unit 5 Data Modelling Assignment 2 Introduction In this assignment, I was recently chosen to work as a trainee data analyst for a new organization. First and foremost, I am willing to develop an effective spreadsheet model that can forecast the effects of exchange rate fluctuations on company profit margins. I'll use this information to design a data model that meets all of the client's criteria, including worksheet structure diagrams and the ability to include a test plan. The design would then be reviewed with other clients in order to find and advise changes. Furthermore, I will clarify how the specifications are completely satisfied and then include a well-detailed and reasoned review of the optimized data model in comparison to existing client requirements. Problem The essence of the problem is that the consumer has previously faced a range of problems, one of which is the currency change question, which resulted in inaccuracy for both pounds and euros. Functions must perform The model must perform a number of functions for the segment. In certain cases, these functions necessitate a complex calculation that is integrated into the “Microsoft Excel” project. These are the functions that are currently available in this project. SUM – By adding the costs of numbers 1 and 2 together, this function will be used to measure the overall cost. For example, to get the total cost of the product, add all the numbers in cells B1 and F5 and then provide the equals symbol. AVERAGE – This function averages all of the numbers in cells B1 through F5. This feature can also be used as a part of a formula in a worksheet cell. COUNT – This function is typically used to count the number of cells containing numbers, followed by counting the numbers in the list of arguments. This function will also return the number of entries in a number field that contains a set of numbers. Entering the following formula to count the numbers in the range is an example of this. COUNTIF- This feature is usually used to count the number of numbers in cells B1 through F5 that are greater than 50. It will also be used to count the number of 70s in each cell from B1 to F5. IF- This function will run a logical test to see whether the conditions are met, and it returns one of two values: false or true. If the exchange rate of 0.7 is greater than 0.3 or 0.6, for example, it will result in a pass, but if it is less, it will result in a fail. LOOKUP – This function will be used to find a value in one column and return it from another one column. In general, the feature "LOOKUP" will be useful in Excel for solving specific problems. For e.g., if I wanted to find the total currency value (in pounds), I would select that column first, then another to find the overall value.