Ensayo
Unit 5: Data Modelling - Assignment 2 & 3 (Learning Aim B & C) (All Criterias Met
- Grado
- Institución
Unit 5: Data Modelling - Assignment 2 & 3 (Learning Aim B & C) (All Criterias Met
[Mostrar más]Vista previa 3 fuera de 27 páginas
Vista previa 3 fuera de 27 páginas
Añadir al carrito
Añadir al carrito
Vendedor
Seguir
Succeesspro
Comentarios recibidos
Vista previa del contenido
Unit 5: Data Modelling - Assignment 2 & 3(Learning Aim B & C) (All Criterias Met)
written by
johnatkinson
www.stuvia.co.uk
Downloaded by: ibrahimzitouni1 | izitouni54@gmail.com
Distribution of this document is illegal
, Stuvia.co.uk - The Marketplace for Revision Notes & Study Guides
Name: John Atkinson Unit 5 – Learning Aim B Date: 13/06/2019
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.
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
Downloaded by: ibrahimzitouni1 | izitouni54@gmail.com
Distribution of this document is illegal
, Stuvia.co.uk - The Marketplace for Revision Notes & Study Guides
Name: John Atkinson Unit 5 – Learning Aim B Date: 13/06/2019
IF – This function can perform a logical test to check whether the conditions are met and returns one
value of false and another value of true. For instance, if the exchange rate of 0.7 is greater 0.3 or 0.6,
it would result with a pass but if it is less then it will result with a fail instead.
LOOKUP – This function would be used to search one column and would return the corresponding
value from another one-column or one-row range. In general, the function “LOOKUP” would make it
useful for solving certain problems in Excel. For example, if I wanted to search for a value of the total
currency (in pounds), I would select that specific column and then another column to find an overall
value.
User interface:
The user interface will consider including a minimum of at least two or three design layouts. In
addition to this, I will be using Microsoft Excel to provide all the data into an entity and from this, I
will be drawing rough designs to include the display of how my data model will look like before
implementing this. Furthermore, my table will contain links such as including buttons so that it
navigates to another page. The other page will be my form to include the labels and fields for users
to input information. Also, I will also comprise a data analyst such as graphs to track the changes
being made and if the costs of sale are lower or higher predicting the results to be changed over
time.
Constraints:
For this part, I will be considering the constraints that could occur during the process of my data
modelling using the project “Microsoft Excel”. This would help me to improve and make sure that I
do not encounter the same problems again in the future. One of these constraints will include:
Time – This will be one of the constraint issues that can exist as I may not have enough time to finish
off the project and to make it accurate and efficient as possible. Furthermore, the limit of time could
affect me with calculations as it may usually take long to figure out the data to be calculated.
Cost – This would be another issue of my constraint as the amount of budget I have may not be
enough to meet each of the hardware requirements and which ones to buy. The limitations with
these will possibly prevent me to continue with the data modelling process since the hardware that I
have may not function properly after having to purchase a cheaper hardware (PC, Laptop).
Skills - The skills would be another common issue as part of my constraint because I may have a lack
of skills that would need to be required when dealing with the tools that have been provided on the
project “Microsoft Excel”. There are some tools that I may not know about or have a clue, and this
would show that I have less skills which wouldn’t meet the criteria or requirement.
Hardware – The use of hardware that I use may process slower than expected and will be wasting
time as I would have to wait until it loads each time I create a column and inputting the data. If the
loading process takes too long, then it will buffer and result with having to exit the application and
restart.
Downloaded by: ibrahimzitouni1 | izitouni54@gmail.com
Distribution of this document is illegal
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable. Así llegas a la conclusión rapidamente!
Preguntas frecuentes
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Succeesspro. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for $12.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
45,681 summaries were sold in the last 30 days
Founded in 2010, the go-to place to buy summaries for 14 years now
Vistos recientemente
Resumen ·
Samenvatting Politicologie Communicatiewetenschappen
