Unit 5: Data Modelling Assignment 1 –
Investigating data modelling and how it
can be used in the decision-making
process
By Victor Anosike
, I am creating a presentation that will expla
how spreadsheet models can be used
predict the outcome of different situatio
and, therefore support the decisions th
the managers need to make as they run th
company.
Introduction Before creating a data model using a
spreadsheet or another app to simulate a
real-life situation, Data Modelling walks yo
through the stages of decision-making. It
allows all possibilities to be considered
when predicting outcomes.
,Stages in the Decision-Making Process
, The first stage is to Understand the scenari
which is the situation in which a data mode
is needed. The scenario is required for a
successful data model, failure to fully
understand it will result in problems and
reduce the usefulness of your spreadsheet.
The scenario lets you understand what you
Understanding spreadsheet needs to be able to do. You wi
need to know who wants the spreadsheet
the Scenario and why. Manufacturers of ice cream, for
example, would need to know what to
produce and when to produce it at the righ
time (around the starting time the demand
for ice cream peaks, usually around summe
This allows the manufacturers to get a sens
of the situation and determine how they w
respond.
Investigating data modelling and how it
can be used in the decision-making
process
By Victor Anosike
, I am creating a presentation that will expla
how spreadsheet models can be used
predict the outcome of different situatio
and, therefore support the decisions th
the managers need to make as they run th
company.
Introduction Before creating a data model using a
spreadsheet or another app to simulate a
real-life situation, Data Modelling walks yo
through the stages of decision-making. It
allows all possibilities to be considered
when predicting outcomes.
,Stages in the Decision-Making Process
, The first stage is to Understand the scenari
which is the situation in which a data mode
is needed. The scenario is required for a
successful data model, failure to fully
understand it will result in problems and
reduce the usefulness of your spreadsheet.
The scenario lets you understand what you
Understanding spreadsheet needs to be able to do. You wi
need to know who wants the spreadsheet
the Scenario and why. Manufacturers of ice cream, for
example, would need to know what to
produce and when to produce it at the righ
time (around the starting time the demand
for ice cream peaks, usually around summe
This allows the manufacturers to get a sens
of the situation and determine how they w
respond.
