Purvi Patel - PowerPoint PPT Presentation

1 / 24
About This Presentation
Title:

Purvi Patel

Description:

Software technology that enables users to access data interactively with wide ... User clicks on a menu bar or icon. For user with no need for DSS, hide its existence ... – PowerPoint PPT presentation

Number of Views:40
Avg rating:3.0/5.0
Slides: 25
Provided by: col699
Category:
Tags: patel | purvi

less

Transcript and Presenter's Notes

Title: Purvi Patel


1
Group 4
  • Purvi Patel
  • Colin Fernandes
  • Felicia Arambula
  • Toris Martin
  • Cesar Terriquez

2
DSS
  • 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.

3
3 levels of DSS Technology
  • Specific DSS
  • DSS Generator
  • DSS Tools

4
Relationships Among DSS Levels
5
Organizational Roles
  • Manager or User
  • Intermediary
  • DSS Builder
  • Technical Supporter
  • Toolsmith

6
Relationship Between DSS Roles Levels
Specific DSS
Manager
Intermediary
DSS Generator
DSS Builder
Technical Supporter
DSS Tools
Toolsmith
7
Components Of A DSS
  • The Dialog
  • The Data
  • The Models

8
The Dialog
  • The Knowledge Base
  • The Action Language
  • The Presentation Language

Key to Info
9
The Data
Internal
External
Employee or Customer Records
Airline Schedules or Stock Prices
Record Based
Document Based
Opinions or Rumors
Ideas, thoughts or opinions
10
The Models (The Model Base)
  • Strategic Models
  • Tactical Models
  • Operational Models

11
OLAP
  • 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.

12
Rules for OLAP
  • Multidimensional
  • Transparency
  • Accessibility
  • Consistent Reporting Performance
  • Client/server architecture
  • Generic dimensionality

13
OLAP Rules (cont)
  • Dynamic sparse matrix handling
  • Multi-user support
  • Unrestricted cross-dimensional operations
  • Intuitive data manipulation
  • Flexible reporting
  • Unlimited dimensions aggregation levels

14
Multidimensional 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.

15
Multidimensional Databases
  • Examples of multidimensional servers
  • Lightship Server from Pilot Software
  • Essbase from Arbor Software

16
Multidimensional DatabasesSupports data analysis
  • Calculations
  • Trend Analysis
  • Slicing Subsets of data
  • drilldown
  • Reach-through
  • Rotations

17
Multidimensional Databases
  • Companies are using multidimensional databases
  • They generate information that previously was
    difficult or impossible to obtain quickly
  • Example Emery Worldwide

18
Emery 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.

19
DSS 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

20
DSS 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

21
Accessing 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

22
Slicing 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

23
Cut and Paste
  • Extract data from the system and analyze it
    further
  • desired mostly by executive support staff
  • ex What if scenario

24
Integrated DSS/EIS software
  • Provides powerful decision support capabilities
  • allows information screen to display the results
    of an analysis performed by a compatible DSS
    product
Write a Comment
User Comments (0)
About PowerShow.com