The Self-Service Data Preparation course opens the door to the exciting world of data management and analysis, a skill that is increasingly in demand in today’s job market. With the global explosion of data, companies are looking for experts who can transform raw data into valuable insights. This course equips you to master essential tools such as Excel, Talend and Dataprep by Trifacta, enabling you to prepare and manage data independently and efficiently. You’ll learn to optimise processes, facilitating decision-making based on robust data. Taking this course strategically positions you within a booming sector, giving you the flexibility to learn from anywhere thanks to its online format. Don’t miss the opportunity to enhance your skills and stand out in a field as crucial as data analysis.
Self-Service Data Preparation
Introduction
Objectives
- Identify data requirements in order to prepare relevant datasets.
- Apply data cleaning techniques to improve the quality of the information.
- Use Excel to process and organise large volumes of data.
- Implement data integration processes using Talend efficiently.
- Explore and prepare data using Dataprep by Trifacta for advanced analysis.
- Analyse patterns and trends in the data to gain valuable insights.
- Optimise data workflows using automated tools.
Table of Contents
TEACHING UNIT 1. DATA PREPARATION
Introduction
Data literacy
Working with data
Data processing solutions and techniques
Data quality management
TEACHING UNIT 2. DATA PREPARATION USING EXCEL
Working with data in Excel
Dataset (DATASET)
Data Cleansing with Excel
Data Wrangling with Excel
Data Blending in Excel
TEACHING UNIT 3. DATA PREPARATION USING TALEND
Installing Talend Data Preparation Desktop
Working with data in Talend
Data Cleansing with Talend
Data Wrangling with Talend
Data Blending with Talend
TEACHING UNIT 4. DATA PREPARATION WITH DATAPREP BY TRIFACTA
Registration with Dataprep by Trifacta
Working with data using Dataprep by Trifacta
Data Cleansing with Trifacta
Data Wrangling with Dataprep by Trifacta
Data Blending with Dataprep by Trifacta