GateXAIMLData Warehousing & OLAP
  • Chapter 1: The Data
    • Data Objects and Attribute Types
      • Nominal Attributes
      • Binary Attributes
      • Ordinal Attributes
      • Numeric Attributes
      • Discrete versus Continuous Attributes
    • Basic Statistical Descriptions of Data
      • Measuring the Central Tendency: Mean, Median, and Mode
        • Mean
        • Median
        • Mode
      • Measuring the Dispersion of Data
        • Range
        • Quartiles and IQR
        • Variance and Standard Deviation
  • Chapter 2: Data Preprocessing
    • Data Cleaning
      • Handling Missing Values
      • Noisy Data: Binning, Regression, and Clustering
        • 1. Binning (Local Smoothing)
        • 2. Regression & Outlier Analysis
    • Data Reduction
      • Dimensionality Reduction
        • Principal Component Analysis
        • Feature Subset Selection
      • Numerosity Reduction
        • Sampling
        • Clustering & Regression
      • Data Compression
        • Lossless Compression
        • Run-Length Encoding (RLE)
        • Diagram 1 — RLE Encoding Pipeline
        • Diagram 2 — RLE on Binary Bitmap (Fax / Sparse Column)
        • Huffman Coding
        • Diagram 3 — Huffman Tree Construction
        • Diagram 4 — Encode and Decode Pipeline
        • LZW (Lempel--Ziv--Welch)
        • Diagram 5 — LZW Encoding Trace
        • Lossy Compression
        • Diagram — PCA: 2-D to 1-D Projection
        • Diagram — Quality vs.\ Compression Ratio Trade-off
    • Data Transformation
      • Data Transformation by Normalization
        • Min-Max Normalization
        • Z-Score Normalization (Standardization)
        • Decimal Scaling
    • Data Discretization
      • Discretization by Binning
      • Discretization by Histogram Analysis
  • Chapter 3: Data Warehousing and Online Analytical Processing
    • Data Warehouse: Basic Concepts
      • OLTP versus OLAP
      • Data Warehousing: A Multitiered Architecture
    • Data Warehouse Modeling: Data Cube and OLAP
      • Data Cube: A Multidimensional Data Model
      • Types of Data Cubes
    • Schemas for Multidimensional Data Models
    • Concept Hierarchy
      • Measures: Categorization and Computation
    • Typical OLAP Operations
GateXAIML · ML Concept Notes

Data Preprocessing & Data Warehousing

Chapter 1
The Data
15 sections
Data Objects and Attribute Types, Basic Statistical Descriptions of Data
Chapter 2
Data Preprocessing
33 sections
Data Cleaning, Data Reduction, Data Transformation...
Chapter 3
Data Warehousing and Online Analytical Processing
10 sections
Data Warehouse: Basic Concepts, Data Warehouse Modeling: Data Cube and OLAP, Schemas for Multidimensional Data Models...
GateXAIML · Data Warehousing & OLAP — Concept Notes
Home | About Us | Contact Us | Privacy Policy | Disclaimer
© 2026 GateXAIML. All original content. Not affiliated with IIT / GATE authorities.