ISOM pwpt ch 9

ISOM pwpt ch 9 - 9-1BUSINESS DRIVEN TECHNOLOGYChapter Nine:...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 9-1BUSINESS DRIVEN TECHNOLOGYChapter Nine: Enabling the Organization Decision Making9-2OLTP vs. OLAPTransaction processing system - the basic business database system that serves the operational (day-to-day operations) level in an organizationOnline transaction processing (OLTP) The general activity of updating (i.e. inserting, modifying, and deleting), querying (i.e. retrieving), and presenting text and number data from databases for operational purposesOnline analytical processing (OLAP) The general activity of querying (i.e. retrieving) and presenting text and number data from data 9-3Decision MakingThe following systems are used to support decision making, problem solving, and opportunity capturing:Decision support systems (DSS)Model information to support managers and business professionals during the decision-making processInclude On-line Analytical Processing (OLAP) ToolsExcel can be a DSSExecutive information systems (EIS)A system containing enterprise-wide information presented via simple and easy to use interfaces for quick insight and analysis by executivesCan be OLAP-tool based9-4DECISION SUPPORT SYSTEMSThree quantitative models typically used by DSSs:1.Sensitivity analysis the study of the impact that changes in one (or more) parts of the model have on other parts of the model (SOLVER)2.What-if analysis checks the impact of a change in an assumption on the proposed solution (IF FUNCTION, SCENARIO MANAGER)3.Goal-seeking analysis finds the inputs necessary to achieve a goal such as a desired level of output (GOAL SEEK)9-5OLAP TOOLS and EXECUTIVE INFORMATION SYSTEMS...
View Full Document

Page1 / 15

ISOM pwpt ch 9 - 9-1BUSINESS DRIVEN TECHNOLOGYChapter Nine:...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online