04-07-2012, 04:52 PM
Decision Support Systems
Decision Support Systems.ppt (Size: 459.5 KB / Downloads: 50)
Extract Information from data to use as the basis for decision making
Used at all levels of the Organization
Tailored to specific business areas
Ad Hoc queries to retrieve and display information
Combines historical operation data with business activities
4 Components of DSS
Data Store – The DSS Database
Business Data
Business Model Data
Internal and External Data
Data Extraction and Filtering
Extract and validate data from the operational database and the external data sources
Dimensionality
Data is related in Many ways
Develop the larger picture
Multi-dimensional view of data
Information Package diagrams
IPD are the backbone of the requirements definition. An information package records the critical measurements or facts and business dimensions along which the facts are normally analysed.
Facts from the IPD will form the fact table ; similarly all the dimensions from the IPD will form the dimension tables.