Training - Course Description

Course:
Pentaho Data Integration I

Course Number: PDI2000
Audience: This course is intended for technical users who integrate disparate data sources (including big data sources), build/maintain data models for analysis, and manage BI data/metadata, including: Database Developers, Power Users, Technical Business Analysts, BI Solution Architects, Systems Integrators, and Data Scientists
Level: Introductory – This course is intended for students with database development or administration experience who are new to Pentaho Data Integration
Delivery Method: Public classroom, Instructor-led online, private on-site (please contact us for on-site pricing)
Duration: 4 Days
Public Training Cost: USD $2,600 (4 credits)
Course Placement: This course is the first course in the Database Developer path. Students with prior database development or administration experience who are new to Pentaho Data Integration should take this course.

Course Schedule:

In the schedule below, click the course title for detailed information on the class, click the provider link for information on the authorized training provider, or click the Register Now link to enroll.

Note: All courses provided by Pentaho-EMEA are offered in the Central European time zone. All US courses (provided by Pentaho) are offered in the Eastern time zone. Beginning in July, 2013, all US courses will be offered in the Central time zone.

Course Overview:

With continuous volumes and increased variety and velocity of data, organizations need fast and easy ways to harness data and gain insight from it. However, one of the biggest challenges facing IT organizations today is to provide a consistent, single version of the truth across all sources of information in an analytics-ready format. With powerful data extract, transform and load (ETL) capabilities, an intuitive and rich graphical design environment, and an open and standards-based architecture, Pentaho Data Integration is increasingly the choice over proprietary and homegrown data integration tools.

Pentaho Data Integration provides a full ETL solution, including:

• Rich graphical designer to empower ETL developers
• Broad connectivity to any type of data, including diverse and big data
• Enterprise scalability and performance, including in-memory caching
• Big data integration, analytics and reporting, including Hadoop, NoSQL, traditional OLTP & analytic databases
• Modern, open, standards-based architecture

Through a series of lectures and hands-on exercises covering theory, best practices, and design patterns, Pentaho Data Integration for Database Developers provides students the skills they need to maximize the value of data to the organization. This course helps prepare you for the Pentaho Data Integration Certification Exam.

Course Benefits:

• Improve productivity by giving your data integration team the skills they need to succeed with Pentaho Data Integration
• Instead of coding in SQL or writing MapReduce Java functions, you can immediately gain real value from data, including from multiple sources like Hadoop, NoSQL and relational data stores, using an easy to use graphical designer
• Learn to deliver data to a wide variety of applications using Pentaho's out-of-the-box data standardization, enrichment and quality capabilities
• Interactive, hands-on training materials significantly improve skill development and maximize retention

Skills Achieved:

At the completion of this course, you should be able to:

• Install Pentaho Data Integration
• Create, preview, and run basic transformations containing steps and hops
• View transformation results in the Step Metrics view and the Log view
• Create a database connection and use Database Explorer to interact with a data source
• Create more complex transformations that involve configuring the following steps: Table input, Table output, Text file output, CSV file input, Insert/Update, Add constants, Filter, Value Mapper, Stream lookup, Join rows, Merge join, Sort rows, Row normalizer, JavaScript, Dimension lookup/update, Database Lookup, Get Data from XML, Set Environment Variables, and Analytic query
• Create transformations that use parameterized values
• Map the structure of an online transaction processing database to the structure of an online analytical processing database
• Load data from and write data to different data sources
• Use ETL design patterns to populate a data warehouse
• Create a transformation that handles slowly changing dimensions
• Create Pentaho Data Integration jobs that: run multiple transformations, use variables, contain sub-jobs, provide built-in error notification, load and process multiple text files, and convert files into Microsoft Excel format
• Configure logging for transformation steps and for job entries and examine the logged data
• Configure error handling for transformation steps
• Configure the Pentaho Enterprise Repository, including basic security
• Use the Pentaho Enterprise Repository to: create folders; store transformations and jobs; move, lock, revise, delete, and restore artifacts
• Schedule and monitor the execution of a transformation in Pentaho Data Integration and in the Pentaho Enterprise Console
• Create and drop indexes using a transformation
• Create a transformation that contains steps configured to run in a cluster, run the transformation in the cluster, examine the results, and monitor the transformation
• Create a transformation that uses a partition schema to partition data to slave servers in the cluster

Course Requirements:

Students attending classroom courses in the United States are provided with a PC to use during class. Students attending courses outside the US should contact the Authorized Training Provider regarding PC requirements for Pentaho courses.

In general, if your training provider requires you to bring a PC to class, it must meet the following requirements. You can also verify your system against the Compatibility Matrix: List of Supported Products topic in the Pentaho InfoCenter:

• Windows XP, 7 desktop operating system (for Macintosh support, please contact your Customer Success Manager)
• RAM: at least 4GB
• Hard drive space: at least 2GB for the software, and more for solution and content files
• Processor: dual-core AMD64 or Intel EM64T
• DVD drive

Online courses require a broadband Internet connection, the use of a modern Web browser (such as Microsoft Internet Explorer or Mozilla Firefox), and the ability to connect to the WebEx Training Center. For more information on WebEx Training Center requirements, see http://www.webex.com. Online courses use Pentaho’s cloud-based exercise environment. Students are provided access to a virtual machine used to complete the exercises.

For online courses, students are provided with a secured, electronic course manual. Printed manuals are not provided for online courses. When an electronic manual is provided, students are encouraged to print the exercise book before class begins, though this is not required.

Students attending this course on-site should contact their Customer Success Manager for hardware and software requirements. You can also email us at training@pentaho.com for more information regarding on-site training requirements.

Course Agenda: