W10 Information Systems Security

Question 1

Define Business intelligence

Answer 1

General term for 
	Application
	Technologies
	Processes
Used for
	Decision making
	Organisational performance
	Creating competitive advantage
Effects
	All stakeholders

Question 2

Identify and explain the different scopes of BI in an organisation

Answer 2

One or few BI applications: Specific department for specific problem
Enterprise wide BI:
BI support for organisational transformation: BI influences organisation competes
 support new business models
 enable new business strategies

Question 3

Define what is management and what is the manager role

Answer 3

help the organisation achieve its goal by using resources
 Interpersonal role: Leadership
 Informational role: Monitor, analysing data
 Decisional role: decisions, allocate, negotiator

Question 4

Identify and explain the different steps in the decision making process

Answer 4

1) Intelligence: Examining > Identify > Define
2) Design: constructing a model
3) Choice: Selecting the solution and implementing

Question 5

Identify and explain the different reason why management need IT support

Answer 5

Increasing number of alternatives: More = More support
Decision under time pressures:
Increasing uncertainty: need for models
Bring everything together quickly and inexpensive

Question 6

Explain the different nature of decision making

Answer 6

Strategic planning: LT goals and policies
Management control: acquiring resources
Operational control: Executing a specific task

Question 7

Identify what type of decisions are made by
Senior management
Middle management
Low level management

Answer 7

Low: structured/semi problem associated to operation and structured management
Middle: Semi structured management decisions
Senior: Unstructured management, Semi/Unstructured strategic problems

Question 8

Explain what is Multidimensional Analysis/ Online Analytical Processing (OLAP) and some data analysis tools

Answer 8

Stores data in a multidimensional format
Tools:
	Dice and slicing
	Drilling
	rollup

Question 9

Explain what is data mining

Answer 9

Searching for valuable information
 Predicting trends and behaviours
 Identifying unknown patterns

Question 10

Explain the goal of the following analysis
Sensitivity analysis
What-if Analysis
Goal seeking analysis

Answer 10

Sensitivity analysis: impact on change in input on the output
What-if Analysis: Impact of a change on assumptions
Goal seeking analysis: Analysis the value of inputs required to achieve desired level of output

Question 11

Explain what is a dash board

Answer 11

A graphically interface that presents
 Provides easy access/timely information
 Access to management reports
Can have real time BI data

Question 12

Identify what are the capabilities of a dashboard

Answer 12

REPORTS
 KPI: measures of critical success factors (CSF)
 Trend Analysis: trends and forecast in KPI/metrics
 Exception Reporting: highlight deviations larger than a certain threshold
OTHER
 Drill-down: going into more detail
 Status Access: up to date information

Question 13

Explain what is data visualisation technology

Answer 13

Graphically portrayal of data
 Communicating data in the form of visual objects
 Attractive and understandable to the user
Geographic information system

Question 14

Explain what is real time BI

Answer 14

enable real time data analyse
 Used to help make decisions and
 interact with customers
Can be in the form of a dashboard