UNIT 5 DATA
MODELLING By:
ASSIGNMENT A
,TABLE OF CONTENT
• What is data modelling
• Stages of decision making
• Features of spreadsheet software used to supp
the process of decision making
• Analyzing the features of spreadsheet software
how contributes to the process of decision mak
• Evaluating spreadsheet software and how it
contributes to the process of decision making
• Pros of using Excel in a decision-making proces
• Cons of using Excel in a decision-making proce
,DATA MODELLING
Data modeling is the process of using a
worksheet or another tool to simulate a real-
world situation where business decisions need t
be made.
Data modelling is the act of creating a visual
representation of a full information system or a
subset of it to communicate linkages between
data items and structures.
,STAGES IN Understanding the Scenarios
DECISION Identifying information and sources
MAKING Factors affecting the quality of information
Analysing the information
Identifying alternatives
Identifying consequences of implementing
the alternatives
Making and justifying a decision
Communicating the decision to others
, UNDERSTANDI • The scenario clarifies what the spreadsheet mu
able to achieve.it is a situation whereby a data
NG THE is needed. It essentially provides a description
subject matter or topic you'll be modelling.
SCENARIOS • Majority of your data models will include a scen
based on the type of business.
MODELLING By:
ASSIGNMENT A
,TABLE OF CONTENT
• What is data modelling
• Stages of decision making
• Features of spreadsheet software used to supp
the process of decision making
• Analyzing the features of spreadsheet software
how contributes to the process of decision mak
• Evaluating spreadsheet software and how it
contributes to the process of decision making
• Pros of using Excel in a decision-making proces
• Cons of using Excel in a decision-making proce
,DATA MODELLING
Data modeling is the process of using a
worksheet or another tool to simulate a real-
world situation where business decisions need t
be made.
Data modelling is the act of creating a visual
representation of a full information system or a
subset of it to communicate linkages between
data items and structures.
,STAGES IN Understanding the Scenarios
DECISION Identifying information and sources
MAKING Factors affecting the quality of information
Analysing the information
Identifying alternatives
Identifying consequences of implementing
the alternatives
Making and justifying a decision
Communicating the decision to others
, UNDERSTANDI • The scenario clarifies what the spreadsheet mu
able to achieve.it is a situation whereby a data
NG THE is needed. It essentially provides a description
subject matter or topic you'll be modelling.
SCENARIOS • Majority of your data models will include a scen
based on the type of business.