Get in Touch
 Duration 14 hours

Course Outline

Introduction

  • Recognizing the vital role of data preparation in analytics and machine learning
  • The data preparation pipeline and its position within the broader data lifecycle
  • Examining common issues in raw data and their consequences for analysis

Data Collection and Acquisition

  • Data sources: including databases, APIs, spreadsheets, text files, and other formats
  • Strategies for gathering data while maintaining quality during the acquisition phase
  • Methods for ingesting data from diverse sources

Data Cleaning Techniques

  • Detecting and managing missing values, outliers, and inconsistent records
  • Resolving duplicates and correcting errors within datasets
  • Applying cleaning processes to real-world datasets

Data Transformation and Standardization

  • Normalization and standardization methods
  • Managing categorical data through encoding, binning, and feature engineering
  • Converting raw data into structured, usable formats

Data Integration and Aggregation

  • Merging and combining datasets from multiple origins
  • Reconciling data conflicts and aligning data types
  • Methods for aggregating and consolidating data

Data Quality Assurance

  • Techniques for maintaining data quality and integrity throughout the workflow
  • Establishing quality checks and validation protocols
  • Reviewing case studies and practical examples of data quality assurance

Dimensionality Reduction and Feature Selection

  • Understanding the necessity of reducing dimensionality
  • Applying techniques such as PCA, feature selection, and reduction strategies
  • Executing dimensionality reduction methods

Summary and Next Steps

Requirements

  • Familiarity with fundamental data concepts

Target Audience

  • Data analysts
  • Database administrators
  • IT professionals

Number of participants


Price per participant (excl. VAT)

Testimonials (2)

Upcoming Courses

Related Categories