Title: Purvi Patel
1Group 4
- Purvi Patel
- Colin Fernandes
- Felicia Arambula
- Toris Martin
- Cesar Terriquez
2DSS
- Decision Support System
- An interactive system that provides the user with
easy access to decision models and data in order
to support semistructured and unstructured
decision making tasks.
33 levels of DSS Technology
- Specific DSS
- DSS Generator
- DSS Tools
4Relationships Among DSS Levels
5Organizational Roles
- Manager or User
- Intermediary
- DSS Builder
- Technical Supporter
- Toolsmith
6Relationship Between DSS Roles Levels
Specific DSS
Manager
Intermediary
DSS Generator
DSS Builder
Technical Supporter
DSS Tools
Toolsmith
7Components Of A DSS
- The Dialog
- The Data
- The Models
8The Dialog
- The Knowledge Base
- The Action Language
- The Presentation Language
-
Key to Info
9The Data
Internal
External
Employee or Customer Records
Airline Schedules or Stock Prices
Record Based
Document Based
Opinions or Rumors
Ideas, thoughts or opinions
10The Models (The Model Base)
- Strategic Models
- Tactical Models
- Operational Models
11OLAP
- Online Analytical Processing
- Software technology that enables users to access
data interactively with wide variety of possible
views of information that has been transformed
from raw to real data.
12Rules for OLAP
- Multidimensional
- Transparency
- Accessibility
- Consistent Reporting Performance
- Client/server architecture
- Generic dimensionality
13OLAP Rules (cont)
- Dynamic sparse matrix handling
- Multi-user support
- Unrestricted cross-dimensional operations
- Intuitive data manipulation
- Flexible reporting
- Unlimited dimensions aggregation levels
14Multidimensional Databases
- Critical to OLAP.
- Multidimensional Databases data taken from
operational databases (ex sales) and processed
(ex aggregated) before being placed on a server. - Designed to support and operate on
multidimensional data structures.
15Multidimensional Databases
- Examples of multidimensional servers
- Lightship Server from Pilot Software
- Essbase from Arbor Software
16Multidimensional DatabasesSupports data analysis
- Calculations
- Trend Analysis
- Slicing Subsets of data
- drilldown
- Reach-through
- Rotations
17Multidimensional Databases
- Companies are using multidimensional databases
- They generate information that previously was
difficult or impossible to obtain quickly - Example Emery Worldwide
18Emery Worldwide
- Emery Essbase pricing application is 9 gigabytes
and runs on a Pentium processor - Load about 150 megabytes of extracted data from
DB2 transaction system into Essbase each month. - Gives analysts access to data and analysis
capabilities.
19DSS in EIS
- Keep characteristics and needs of user in mind
- Executives with little or no computer experience
may only want to view information from different
perspectives - Administrative assistants who use a computer on a
regular basis
20DSS in EIS 4 Approaches to Including DSS
- Accessing a DSS through the EIS
- Slicing and Dicing Data
- Cutting and Pasting Data into DSS
- Using Integrated DSS/EIS Software
21Accessing DSS
- User clicks on a menu bar or icon
- For user with no need for DSS, hide its existence
- DSS is seen and can be launched only by those who
need it
22Slicing and Dicing Data
- Allow user to view data form different dimensions
and perspectives - Executives most likely to want this capability
- user specify the member of each dimension
- alternative default condition for the
information screen and allow changes
23Cut and Paste
- Extract data from the system and analyze it
further - desired mostly by executive support staff
- ex What if scenario
24Integrated DSS/EIS software
- Provides powerful decision support capabilities
- allows information screen to display the results
of an analysis performed by a compatible DSS
product