Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Testimonials (2)
The variety of the information shared and the clarity to explain terms in plain English.
Arisbe Mendoza - Fairtrade International
Course - GDPR Workshop
It's a hands-on session.