Talend Data Quality Pack#1

After completing this training course, you will be able to develop your jobs using the power of the advanced software components and Java; you will also be able to analyze your data and maximize quality.

Even though knowledge of SQL is the only prerequisite to qualify for this training course, business knowledge will be needed to interpret the analyses related to data quality. Knowledge of the Java language is a plus.

Always based on real use cases, this five day training course allows you to master the Talend Data Quality software to analyze the data and to clean it. 

 

Talend Data Quality Pack#1

Course objectives:
  1. Model needs
  2. Control the component library
  3. Implement Jobs
  4. Develop analyses to monitor and improve data quality

Target audience:
  1. Project manager
  2. BI Expert
  3. System Engineer/DBA
  4. Development Engineer
  5. Architect

Pre-requisites:
  1. Knowledge of the SQL language
  2. Knowledge of the Java language is a plus

Teaching Method:

 This training course is based on real use cases
Theory: 20%
Practice: 80%

Duration::

 5 days or 35 hours

 
Course

 1. Learn how to use Talend Studio
  1. Model your needs and document a project
  2. Use the Job Designer to generate the code
  3. Manage access to files and access to databases
  4. Use the different transformation components
  5. Centralize metadata in the Repository
  6. Master advanced features
  7. Debug scripts and deploy jobs

 2. Presentation and installation of Talend Data Quality
  1. Presentation and installation of Talend Data Quality

 3. Connect to data sources and run your first analyses
  1. Connect to data sources and run your first analyses

 4. Analyze data from a column using patterns
  1. Generate regular expressions through the Pattern indicators
  2. Define your own built-in patterns
  3. Import patterns from Talend Exchange

 5. Apply your business rules in a Single Table / Multi-Column analysis
  1. Discover the Single Table analysis
  2. Create and apply your business rules
  3. Check the integrity of your data

 6. Generate your own reports
  1. Generate a simple report
  2. Generate a progress report - data quality monitoring

 7. Optimize your quality/clean your data
  1. Remove invalid data
  2. Parse, standardize and consolidate your data

 8. Define correlation analyses
  1. Create a Numerical Correlation analysis
  2. Create a Time Correlation analysis
  3. Create a Nominal Correlation analysis

 9. Take advantage of the Data Quality portal
  1. Use the dashboards
  2. Use the built-in Talend Data Quality reports
  3. Customize your reports in iReport

10. Set up team work - task management
  1. Create, revise and complete your reports

11. Benefit from Talend community support and services
  1. Discover the Best Practices
  2. Promote your patterns in the Talend community
  3. Use the Talend resources and services

 

Talend is a leading open source software vendor that makes powerful data integration and application integration solutions accessible to organizations of all sizes. For data integration, Talend offers an easy-to-use ETL tool that makes the development of data extraction, data transformation, and data loading processes faster and more reliable, as well as flexibly supporting a wide range of data management operations such as database conversion and data synchronization. Talend's open source data quality management solution features a powerful data profiler as well as advanced data cleaning and data enrichment functionality. For enterprise application integration, Talend extends proven Apache open source technologies like Apache CXF and Camel to provide high-performance, modular solutions that enable organizations to derive more business value from their distributed systems and applications.
Apache, the Apache feather logo, and all Apache-related trademarks are the property of the Apache Software Foundation, and are used with permission. Click here for more information.