The demand for data proficiency is at an all-time high, reshaping industries and redefining career paths. With our ‘Self-service Data Preparation: Excel, Talend and Trifacta’ course, you have the opportunity to master essential skills that are highly sought after in today’s data-driven world. This course equips you to efficiently clean, transform and organise data using powerful tools such as Excel for foundational techniques, Talend for sophisticated data integration, and Trifacta for advanced data wrangling. By enrolling, you will gain the expertise needed to manage data independently, enhancing your analytical capabilities and boosting your employability in a competitive job market. Seize the chance to become a data-savvy professional and stand out in your field.
Self-service data preparation. Excel, Talend and Trifacta
Big Data
40 hours
Introduction
Objectives
- To understand the fundamentals of data preparation processes and their importance.
- To master data manipulation techniques using Excel for effective data analysis.
- To learn how to automate data preparation tasks efficiently using Talend’s features.
- To explore advanced data wrangling capabilities using Trifacta Wrangler for complex datasets.
- To develop skills for cleaning and transforming raw data into usable formats for analysis.
- To integrate data preparation tools to streamline data workflows.
- To improve data quality through effective data preparation and cleansing techniques.
Table of Contents
UNIT 1. DATA PREPARATION
Introduction
Self-service solutions
Data processing techniques
Data quality management
Types of data problems
UNIT 2. EXCEL
Data cleaning using Excel
DATASET
Functions. Part I
Functions. Part II
Functions. Part III
UNIT 3. TALEND DATA PREPARATION
Instructions for installing Talend Data Preparation Free Desktop
Data Cleansing with Talend Data Preparation
Basic cleansing functions
Data normalisation
Data enrichment
UNIT 4. TRIFACTA WRANGLER
Registration instructions
Data cleansing with Trifacta
Basic cleansing functions
Data normalisation
Data enrichment