Business Analytics

  1. Data Management and Preparation
    1. Data Sourcing and Collection
      1. Internal Data Sources
        1. Transactional Systems
          1. Enterprise Resource Planning Systems
            1. Customer Relationship Management Systems
              1. Operational Databases
                1. Log Files and System Data
                2. External Data Sources
                  1. Public Datasets
                    1. Third-Party Data Vendors
                      1. Social Media Data
                        1. Web Scraping
                          1. APIs and Data Feeds
                          2. Data Source Evaluation
                            1. Data Quality Assessment
                              1. Cost-Benefit Analysis
                            2. Data Architecture and Storage
                              1. Data Warehouses
                                1. Architecture and Design Principles
                                  1. Star Schema and Snowflake Schema
                                    1. Data Integration Strategies
                                      1. OLAP vs. OLTP Systems
                                      2. Data Marts
                                        1. Departmental Data Stores
                                          1. Subject-Oriented Design
                                            1. Use Cases and Benefits
                                            2. Data Lakes
                                              1. Raw Data Storage
                                                1. Schema-on-Read vs. Schema-on-Write
                                                  1. Data Lake Architecture
                                                  2. Cloud Data Storage
                                                    1. Scalability and Flexibility
                                                      1. Cost Considerations
                                                        1. Security and Compliance
                                                      2. Data Extraction, Transformation, and Loading
                                                        1. Data Extraction
                                                          1. Data Source Connectivity
                                                            1. Extraction Methods and Tools
                                                              1. Change Data Capture
                                                              2. Data Transformation
                                                                1. Data Cleansing
                                                                  1. Handling Missing Values
                                                                    1. Outlier Detection and Treatment
                                                                      1. Data Validation Rules
                                                                      2. Data Standardization
                                                                        1. Format Standardization
                                                                          1. Unit Conversion
                                                                            1. Encoding Categorical Variables
                                                                            2. Data Integration
                                                                              1. Record Matching and Deduplication
                                                                                1. Data Consolidation
                                                                                  1. Conflict Resolution
                                                                                  2. Feature Engineering
                                                                                    1. Creating Derived Variables
                                                                                      1. Aggregation and Summarization
                                                                                        1. Dimensionality Reduction
                                                                                      2. Data Loading
                                                                                        1. Loading Strategies
                                                                                          1. Incremental vs. Full Loads
                                                                                            1. Error Handling and Recovery
                                                                                          2. Data Quality and Governance
                                                                                            1. Data Quality Dimensions
                                                                                              1. Accuracy
                                                                                                1. Completeness
                                                                                                  1. Consistency
                                                                                                    1. Timeliness
                                                                                                      1. Validity
                                                                                                        1. Uniqueness
                                                                                                        2. Data Quality Assessment
                                                                                                          1. Data Profiling
                                                                                                            1. Quality Metrics and KPIs
                                                                                                              1. Data Quality Monitoring
                                                                                                              2. Data Governance Framework
                                                                                                                1. Governance Structure and Roles
                                                                                                                  1. Data Stewardship
                                                                                                                    1. Policies and Standards
                                                                                                                      1. Data Lineage and Documentation
                                                                                                                      2. Master Data Management
                                                                                                                        1. Master Data Entities
                                                                                                                          1. Data Synchronization
                                                                                                                            1. Reference Data Management

                                                                                                                        Previous

                                                                                                                        2. Foundational Concepts

                                                                                                                        Go to top

                                                                                                                        Next

                                                                                                                        4. Descriptive Analytics