2 Data Preprocessing And Preparation

Data Warehousing and Data Mining · Unit 2

Data Preprocessing and Preparation

Exam-focused notes for Data Preprocessing and Preparation (Data Warehousing and Data Mining, BIT454): what the TU syllabus asks and how it has actually been tested, with 1 solved past questions from this unit.

What this unit covers

  • Need for data preprocessing
  • Data cleaning and transformation methods
  • Data integration and consolidation
  • Data reduction techniques
  • Handling missing values and noise

Need for data preprocessing

20815 marks

Why is data preprocessing required? Explain any two data preprocessing methods. [5]

Data preprocessing is essential because: 1. Raw data quality issues: Real-world data contains inconsistencies, missing values, duplicates, and noise that can negatively impact model performance and accuracy. 2. Improved model performance: Cleaning and trans...

Full solved answer →