Essay

Unit 5: Data Modelling Assignment 1 (Distinction)

0 purchase

Module
Unit 5 - Data Modelling

Institution
PEARSON (PEARSON)

You have recently joined a new company as a trainee data analyst. The local leisure centre wants to begin a new programme to help people become fitter and healthier by reducing their Body Mass Index (BMI). You have been asked to design and create a spreadsheet model, which can predict the pote...

[Show more]

Preview 2 out of 12 pages

View example

Uploaded on June 14, 2023
Number of pages 12
Written in 2022/2023
Type Essay
Professor(s) Unknown
Grade A+

investigate data modelling and how it can be used
assignment 1 models and decision making
unit 5 data modelling
unit 5 data modelling assignment 1

tasnimsultana1 Member since 2 year 29 documents sold

Name: Tasnim Sultana Unit 5 Date:
30/09/2022

Data modelling - Investigate data modelling and how it can
be used in the decision making process
Introduction to the assignment-
In this assignment, I will be investigating the process of the decision making process for data
modelling. Therefore, I will explain the stages in the decision making process along with
others such as spreadsheets features, using data modelling to consider alternatives,
Evaluating models and being able to provide documentation and justification of the models.

It's important for us to understand what data modelling is and how it can be applied correctly
to create spreadsheets for the clients. In the event that a client asks to complete certain
tasks, We can use data modelling to create and consider alternative options.

As part of data modelling, connections between data points and structures are visually
represented to illustrate how an information system or its components are connected. It is
intended to illustrate how data is used and stored within the system, its relationships among
data types, and the ways that it can be categorised and organised.

Stages in the decision making process-
1. Understanding the scenario
2. Identifying information and sources
3. Factors affecting the quality of informations
4. Analysing the information
5. Identifying alternatives
6. Identifying consequences of implementing the alternatives
7. Making the justifying the decision
8. Communicating decisions to others.

Understanding the scenario-
Before doing anything with your data modelling, it's required to understand the scenario
because it allows you to understand what your spreadsheet needs to be able to do. On the
other hand if you don't understand the scenario it's going to cause some problems in your
spreadsheet and you might not be able to solve it. The first thing is to figure out who wants
this spreadsheet. It's important because it gives you the information about the owner and
who’s going to use it. You will be able to find out why they want it, why it’s important and
what they want to display from the spreadsheets. These are the basic questions you will be
answered when you have a good understanding about the scenario.
For example- In the scenario that I was given on the assignment brief, I was asked to design
and create a spreadsheet model to predict the potential impact of changes in exercise diet
on a person's BMI. In addition the model I develop should be designed to be used by people
who do not have a background in IT. so, who wants the sheet? The local leisure centre
Who will be using the spreadsheet? Other people. Why do they need it? To predict the
potential impact of changes in exercise diet on a person's BMI.

, Name: Tasnim Sultana Unit 5 Date:
30/09/2022

Identifying information and sources-
To make your decision and data modelling, you have to identify the information you get.
Such as where did the information come from and is it reliable to use because wrong
information will end up with negative assaults. There are 3 types of information in data
modelling.

Required Information:
The information required is for the spreadsheets. I have to find and Identify this information
for the spreadsheet. To predict BMI, for example, exercise and diet information must be
collected over a period of 10 weeks, so the data sources can be verified. Since you could
compare the data to the requirements, this list of requirements would be a great tool for
verifying the data.

Information that is already given:
Figuring this out is easier than required information, because some of the information will be
given to you through the scenario. All you have to do is read and understand the scenario
carefully and then identify the information from it. For example you might want to find out
how many days they want to check their BMI.

Additional required information:
After you found the useful information from the scenario, then you might need some
additional information as well for your spreadsheet and modelling process. This information
will not be in the scenario. You have to find this information from somewhere else and
include it in a spreadsheet. For example, if you need to know how to collect a person’s
BMI.Then you have to do a research on the internet cause you might not know how to
calculate.

Factors affecting the quality of informations
Currency of data
In terms of data currency, it refers to how recently it has been collected. Data that is
outdated becomes less relevant as time goes on, whereas information that is current
becomes more valuable. As far as your model is concerned, it is best to leave behind the
information that has lost its currency, as it is not as useful as current data. Suppose a
restaurant wanted to know when their busiest time would be; the answer would depend on
the currency of the data. Data from 10 years ago about people going to the restaurant
mostly in January isn't accurate if people go in June now. So they would have to find recent
information such as the busiest time from last year.

External factors
An external factor is something that is from the outside, which could possibly affect your data
model. They can be anything, it may have a good effect or a bad effect, on the information
you have collected. For example, relating to the restaurant scenario, they could have taken a
survey of the amount of customers in june, but it could've been events such as festivals
taking place in the same time period leading to an increased amount than any normal

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

You can quickly pay through credit card for the summaries. There is no membership needed.

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

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.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller tasnimsultana1. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for £10.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69988 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 15 years now

Start selling

Seller

Package deal ·

Essay

Unit 5: Data Modelling Assignment 1 (Distinction)

Document information

Subjects

Written for