Decision Support Systems

  1. Data Management for Decision Support
    1. Data Sources and Types
      1. Internal Data Sources
        1. Transactional Systems
          1. Sales Data
            1. Financial Records
              1. Operational Metrics
              2. Operational Databases
                1. Customer Information
                  1. Product Catalogs
                    1. Inventory Records
                    2. Historical Archives
                      1. Time-series Data
                        1. Trend Information
                          1. Comparative Analysis
                        2. External Data Sources
                          1. Market Intelligence
                            1. Industry Reports
                              1. Competitor Analysis
                                1. Economic Indicators
                                2. Public Data Sources
                                  1. Government Statistics
                                    1. Regulatory Information
                                      1. Demographic Data
                                      2. Social and Web Data
                                        1. Social Media Feeds
                                          1. Web Analytics
                                            1. Customer Reviews
                                          2. Personal and Subjective Data
                                            1. Expert Opinions
                                              1. User Preferences
                                                1. Qualitative Assessments
                                                  1. Judgment-based Inputs
                                                2. Data Warehousing Concepts
                                                  1. Data Warehouse Characteristics
                                                    1. Subject Orientation
                                                      1. Business Process Focus
                                                        1. Functional Area Organization
                                                          1. Cross-functional Integration
                                                          2. Data Integration
                                                            1. Source System Consolidation
                                                              1. Data Standardization
                                                                1. Quality Assurance
                                                                2. Time Variance
                                                                  1. Historical Perspective
                                                                    1. Temporal Consistency
                                                                      1. Trend Analysis Support
                                                                      2. Non-volatility
                                                                        1. Read-only Operations
                                                                          1. Data Stability
                                                                            1. Audit Trail Preservation
                                                                          2. Data Warehouse Architecture
                                                                            1. Source Systems Layer
                                                                              1. Operational Systems
                                                                                1. External Data Sources
                                                                                  1. Legacy System Integration
                                                                                  2. Data Staging Area
                                                                                    1. Temporary Storage
                                                                                      1. Data Processing Zone
                                                                                        1. Quality Control
                                                                                        2. Data Storage Layer
                                                                                          1. Core Data Warehouse
                                                                                            1. Data Mart Structures
                                                                                              1. Archive Systems
                                                                                              2. Presentation Layer
                                                                                                1. Access Tools
                                                                                                  1. Reporting Systems
                                                                                                    1. Analytical Applications
                                                                                                  2. Data Mart Implementation
                                                                                                    1. Dependent Data Marts
                                                                                                      1. Top-down Approach
                                                                                                        1. Enterprise Integration
                                                                                                          1. Centralized Control
                                                                                                          2. Independent Data Marts
                                                                                                            1. Bottom-up Development
                                                                                                              1. Departmental Focus
                                                                                                                1. Rapid Implementation
                                                                                                                2. Hybrid Approaches
                                                                                                                  1. Federated Architecture
                                                                                                                    1. Hub-and-spoke Model
                                                                                                                      1. Data Virtualization
                                                                                                                    2. ETL Process Management
                                                                                                                      1. Data Extraction
                                                                                                                        1. Full Extraction
                                                                                                                          1. Incremental Extraction
                                                                                                                            1. Change Data Capture
                                                                                                                            2. Data Transformation
                                                                                                                              1. Data Cleansing
                                                                                                                                1. Format Standardization
                                                                                                                                  1. Business Rule Application
                                                                                                                                  2. Data Loading
                                                                                                                                    1. Bulk Loading
                                                                                                                                      1. Real-time Loading
                                                                                                                                        1. Error Handling
                                                                                                                                    2. Online Analytical Processing
                                                                                                                                      1. Multidimensional Data Concepts
                                                                                                                                        1. Dimension Structures
                                                                                                                                          1. Hierarchical Dimensions
                                                                                                                                            1. Network Dimensions
                                                                                                                                              1. Time Dimensions
                                                                                                                                              2. Fact Tables
                                                                                                                                                1. Additive Facts
                                                                                                                                                  1. Semi-additive Facts
                                                                                                                                                    1. Non-additive Facts
                                                                                                                                                    2. Measure Definitions
                                                                                                                                                      1. Base Measures
                                                                                                                                                        1. Calculated Measures
                                                                                                                                                          1. Derived Metrics
                                                                                                                                                        2. OLAP Cube Design
                                                                                                                                                          1. Star Schema
                                                                                                                                                            1. Fact Table Design
                                                                                                                                                              1. Dimension Table Structure
                                                                                                                                                                1. Relationship Management
                                                                                                                                                                2. Snowflake Schema
                                                                                                                                                                  1. Normalized Dimensions
                                                                                                                                                                    1. Storage Optimization
                                                                                                                                                                      1. Query Complexity
                                                                                                                                                                      2. Galaxy Schema
                                                                                                                                                                        1. Multiple Fact Tables
                                                                                                                                                                          1. Shared Dimensions
                                                                                                                                                                            1. Complex Relationships
                                                                                                                                                                          2. OLAP Operations
                                                                                                                                                                            1. Slice and Dice
                                                                                                                                                                              1. Dimension Filtering
                                                                                                                                                                                1. Data Subset Selection
                                                                                                                                                                                  1. View Customization
                                                                                                                                                                                  2. Drill Operations
                                                                                                                                                                                    1. Drill-down Analysis
                                                                                                                                                                                      1. Roll-up Aggregation
                                                                                                                                                                                        1. Drill-through Details
                                                                                                                                                                                        2. Pivot Operations
                                                                                                                                                                                          1. Dimension Rotation
                                                                                                                                                                                            1. Perspective Changes
                                                                                                                                                                                              1. View Reorganization
                                                                                                                                                                                              2. Aggregation Functions
                                                                                                                                                                                                1. Sum Operations
                                                                                                                                                                                                  1. Average Calculations
                                                                                                                                                                                                    1. Count Functions
                                                                                                                                                                                                      1. Statistical Measures
                                                                                                                                                                                                  2. Data Mining Applications
                                                                                                                                                                                                    1. Data Mining Fundamentals
                                                                                                                                                                                                      1. Pattern Discovery
                                                                                                                                                                                                        1. Hidden Relationships
                                                                                                                                                                                                          1. Trend Identification
                                                                                                                                                                                                            1. Anomaly Detection
                                                                                                                                                                                                            2. Predictive Modeling
                                                                                                                                                                                                              1. Future Behavior Prediction
                                                                                                                                                                                                                1. Risk Assessment
                                                                                                                                                                                                                  1. Outcome Forecasting
                                                                                                                                                                                                                2. Classification Techniques
                                                                                                                                                                                                                  1. Decision Trees
                                                                                                                                                                                                                    1. Tree Construction
                                                                                                                                                                                                                      1. Pruning Methods
                                                                                                                                                                                                                        1. Rule Extraction
                                                                                                                                                                                                                        2. Neural Networks
                                                                                                                                                                                                                          1. Network Architecture
                                                                                                                                                                                                                            1. Training Algorithms
                                                                                                                                                                                                                              1. Pattern Recognition
                                                                                                                                                                                                                              2. Support Vector Machines
                                                                                                                                                                                                                                1. Kernel Functions
                                                                                                                                                                                                                                  1. Margin Optimization
                                                                                                                                                                                                                                    1. Non-linear Classification
                                                                                                                                                                                                                                  2. Clustering Methods
                                                                                                                                                                                                                                    1. K-means Clustering
                                                                                                                                                                                                                                      1. Centroid-based Approach
                                                                                                                                                                                                                                        1. Distance Metrics
                                                                                                                                                                                                                                          1. Cluster Validation
                                                                                                                                                                                                                                          2. Hierarchical Clustering
                                                                                                                                                                                                                                            1. Agglomerative Methods
                                                                                                                                                                                                                                              1. Divisive Approaches
                                                                                                                                                                                                                                                1. Dendrogram Analysis
                                                                                                                                                                                                                                                2. Density-based Clustering
                                                                                                                                                                                                                                                  1. DBSCAN Algorithm
                                                                                                                                                                                                                                                    1. Noise Handling
                                                                                                                                                                                                                                                      1. Arbitrary Shape Clusters
                                                                                                                                                                                                                                                    2. Association Analysis
                                                                                                                                                                                                                                                      1. Market Basket Analysis
                                                                                                                                                                                                                                                        1. Frequent Itemsets
                                                                                                                                                                                                                                                          1. Association Rules
                                                                                                                                                                                                                                                            1. Support and Confidence
                                                                                                                                                                                                                                                            2. Sequential Pattern Mining
                                                                                                                                                                                                                                                              1. Time-ordered Patterns
                                                                                                                                                                                                                                                                1. Sequence Databases
                                                                                                                                                                                                                                                                  1. Pattern Evaluation
                                                                                                                                                                                                                                                                2. Regression Analysis
                                                                                                                                                                                                                                                                  1. Linear Regression
                                                                                                                                                                                                                                                                    1. Simple Linear Models
                                                                                                                                                                                                                                                                      1. Multiple Regression
                                                                                                                                                                                                                                                                        1. Model Validation
                                                                                                                                                                                                                                                                        2. Logistic Regression
                                                                                                                                                                                                                                                                          1. Binary Classification
                                                                                                                                                                                                                                                                            1. Odds Ratio Interpretation
                                                                                                                                                                                                                                                                              1. Model Diagnostics
                                                                                                                                                                                                                                                                              2. Non-linear Regression
                                                                                                                                                                                                                                                                                1. Polynomial Models
                                                                                                                                                                                                                                                                                  1. Exponential Functions
                                                                                                                                                                                                                                                                                    1. Curve Fitting
                                                                                                                                                                                                                                                                                  2. Time Series Analysis
                                                                                                                                                                                                                                                                                    1. Trend Analysis
                                                                                                                                                                                                                                                                                      1. Trend Decomposition
                                                                                                                                                                                                                                                                                      2. Seasonal Patterns
                                                                                                                                                                                                                                                                                        1. Seasonal Decomposition
                                                                                                                                                                                                                                                                                          1. Seasonal Adjustment
                                                                                                                                                                                                                                                                                            1. Cyclical Analysis
                                                                                                                                                                                                                                                                                            2. Forecasting Methods
                                                                                                                                                                                                                                                                                              1. Moving Averages
                                                                                                                                                                                                                                                                                                1. Exponential Smoothing
                                                                                                                                                                                                                                                                                                  1. ARIMA Models
                                                                                                                                                                                                                                                                                                2. Data Mining Process
                                                                                                                                                                                                                                                                                                  1. Business Understanding
                                                                                                                                                                                                                                                                                                    1. Problem Definition
                                                                                                                                                                                                                                                                                                      1. Success Criteria
                                                                                                                                                                                                                                                                                                        1. Resource Assessment
                                                                                                                                                                                                                                                                                                        2. Data Understanding
                                                                                                                                                                                                                                                                                                          1. Data Collection
                                                                                                                                                                                                                                                                                                            1. Data Exploration
                                                                                                                                                                                                                                                                                                              1. Quality Assessment
                                                                                                                                                                                                                                                                                                              2. Data Preparation
                                                                                                                                                                                                                                                                                                                1. Data Selection
                                                                                                                                                                                                                                                                                                                  1. Data Cleaning
                                                                                                                                                                                                                                                                                                                    1. Feature Engineering
                                                                                                                                                                                                                                                                                                                    2. Modeling Phase
                                                                                                                                                                                                                                                                                                                      1. Technique Selection
                                                                                                                                                                                                                                                                                                                        1. Model Building
                                                                                                                                                                                                                                                                                                                          1. Parameter Tuning
                                                                                                                                                                                                                                                                                                                          2. Evaluation Phase
                                                                                                                                                                                                                                                                                                                            1. Model Assessment
                                                                                                                                                                                                                                                                                                                              1. Performance Metrics
                                                                                                                                                                                                                                                                                                                                1. Business Value
                                                                                                                                                                                                                                                                                                                                2. Deployment Phase
                                                                                                                                                                                                                                                                                                                                  1. Implementation Planning
                                                                                                                                                                                                                                                                                                                                    1. Monitoring Systems
                                                                                                                                                                                                                                                                                                                                      1. Maintenance Procedures

                                                                                                                                                                                                                                                                                                                                Previous

                                                                                                                                                                                                                                                                                                                                2. DSS Architecture and Components

                                                                                                                                                                                                                                                                                                                                Go to top

                                                                                                                                                                                                                                                                                                                                Next

                                                                                                                                                                                                                                                                                                                                4. Model Management for Decision Support