Talend Open Profiler

Dopo aver completato questo corso, sarete in grado di analizzare i dati e identificare le ottimizzazioni da implementare per migliorare la qualità dei dati.

Anche se la conoscenza di SQL è l’unico prerequisito per questo corso, la conoscenza del business sarà necessaria per intrerpretare l’analisi relativa alla qualità dei dati. 
Sempre basato su casi reali, questo giorno di corso vi permetterà di imparare ad utilizzare il software Talend Open Profiler.

 

Talend Open Profiler

Course objectives:

 Develop analyses to monitor the quality of data from the enterprise repository

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

Prerequisites:

 Knowledge of the SQL language

Teaching Method:

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

Duration::

 1 day or 7 hours

 
Course

 1. Presentation and installation of Talend Open Profiler
  1. Become familiar with the architecture

 2. Connect to data sources and run the 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 analysis
  1. Discover the Single Table analysis
  2. Create and apply your business rules

 5. Define Multi Column analyses
  1. Create and apply your business rules
  2. Check the integrity of your data

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

 7. 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 the leading developer and distributor of open source middleware. The freely available Talend Open Studio makes it faster and easier for developers to build and deploy data integration processes like data migration, data replication, and ETL. Subscription-based enterprise grade solutions from Talend support advanced functionality like change data capture and support for enterprise data governance. Talend also offers open source application integration solutions that leverage and extend popular Apache ESB technologies like Apache Camel, ActiveMQ, CXF, and Karaf.
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.