Talend Data Quality

Il corso Talend Data Quality è per gli utilizzatori di Talend Open Studio/Talend Integration Suite.

Dopo aver completato questo corso, sarete in grado di analizzare i vostri dati, generare reports e monitorare i vostri dati.

Anche se la conoscenza di SQL e del software Talend data integration è il solo prerequisito per qualificarsi per questo corso, la conoscenza del buiness sarà necessaria per interpretare l’analisi relativa alla qualità dei dati.
Sempre basato su reali casi d’uso, questi tre giorni di corso vi permetteranno di imparare ad utilizzare il sofware Talend Data Quality per analizzare i vostri dati.

 

Course objectives:

  1. Develop analyses to monitor the quality of data from the enterprise repository
  2. Optimize the quality of data

Target audience:

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

Prerequisites:

  1. Knowledge of the SQL language
  2. Talend Open Studio Foundation or Talend Integration Suite Development

Teaching Method:

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

Duration::

3 days or 21 hours

 1. Presentation and installation of Talend Data Quality

  1. Become familiar with the architecture
  2. Discover the Data Quality components

 2. Connect to data sources and run your first analyses

  1. Define a Database Structure Overview analysis
  2. Take advantage of the Data Explorer
  3. Discover the Schema and Catalog analyses

 3. 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

 4. 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

 5. Generate your own reports

  1. Generate a simple report
  2. Generate a progress report - data quality monitoring

 6. Optimize your quality/clean your data

  1. Remove invalid data
  2. Parse, standardize and consolidate your data

 7. Define correlation analyses

  1. Create a Numerical Correlation analysis
  2. Create a Time Correlation analysis
  3. Create a Nominal Correlation analysis

 8. Take advantage of the Data Quality portal

  1. Use dashboards
  2. Use the built-in Talend Data Quality reports
  3. Customize your reports in iReport

 9. Set up team work - task management

  1. Create, revise and complete your reports

10. 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