In today’s data-driven landscape, the demand for professionals skilled in data preparation is surging. The Preparation of Self-Service Data course equips you with essential skills to thrive in this booming sector. As organisations increasingly rely on data to inform decision-making, mastering data literacy and quality management is crucial. This course covers a range of tools and techniques, including Excel and Talend, to help you clean, blend and wrangle data effectively. By participating, you will enhance your ability to work with datasets, ensuring they are accurate and ready for analysis. With a focus on self-service capabilities, this course empowers you to take charge of data preparation, making you an invaluable asset in the workplace. Join us and seize the opportunity to advance your career in this high-demand field, where your expertise can drive impactful results.
Preparation of self-service data
Big Data
40 hours
Introduction
Objectives
- Understand Data preparation concepts and their importance in Data literacy
- Apply Data cleaning techniques using Excel for effective dataset management
- Utilise Excel for Data wrangling To enhance Data analysis processes
- Implement Data blending strategies in Excel To combine multiple datasets
- master Talend for Data cleansing and wrangling in diverse Data environments - leverage Dataprep by Trifacta for efficient Data cleaning and preparation - integrate Data preparation tools To improve overall Data quality management
Table of Contents
UNIT 1. DATA PREPARATION
Introduction
Data literacy
Working with data
Solutions and data processing techniques
Data quality management
UNIT 2. EXCEL
Working with data in Excel
Dataset
Data cleaning with Excel
Data wrangling with Excel
Data blending in Excel
UNIT 3. DATA PREPARATION WITH TALEND
Installation Talend Data Prepation desktop
Working with data in Talend
Data cleansing with Talend
Data wrangling with Talend
Data blending with Talend
UNIT 4. DATA PREPARATION WITH DATAPREP BY TRIFACTA
Registration in Dataprep by Trifacta
Working with data with Dataprep by Trifacta
Data cleaning with Trifacta
Data wrangling with Dataprep by Trifacta
Data blending with Dataprep by Trifacta