In today’s data-driven landscape, the demand for professionals skilled in data preparation is soaring. The ‘Preparation of Self-Service Data’ course equips you with the 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, merge and process data effectively. By taking part, you will improve 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 the concepts of data preparation and their importance in data literacy
- Apply data cleaning techniques using Excel for effective dataset management
- Use Excel for data wrangling to improve data analysis processes
- Implement data blending strategies in Excel to combine multiple datasets
- Master Talend for data cleansing and wrangling in diverse data environments - utilise Dataprep by Trifacta for efficient data cleansing 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 using Excel
Data wrangling with Excel
Data blending in Excel
UNIT 3. DATA PREPARATION WITH TALEND
Installing Talend Data Preparation 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 using Dataprep by Trifacta
Data cleaning with Trifacta
Data wrangling with Dataprep by Trifacta
Data blending with Dataprep by Trifacta