Tag: ETL

Course content

• Introduction and Prerequisites
• The Basics
• IICS – Informatica Intelligent Cloud Services
• Getting Started with IICS
• Data Integration Service
• Transformations in Informatica Cloud
• Business Use Case
• Tasks
• Scheduling in Informatica Cloud
• Bonus

• Introduction
• Installing and Configuring Pentaho
• Overview of Pentaho Features and Architecture
• Understanding Pentaho’s In-Memory Caching
• Navigating the User Interface
• Connecting to a Data Source
• Configuring the Pentaho Enterprise Repository
• Transforming Data
• Viewing the Transformation Results
• Resolving Transformation Errors
• Processing a Data Stream
• Reusing Transformations
• Scheduling Transformations
• Securing Pentaho
• Integrating with Third-party Applications (Hadoop, NoSQL, etc.)
• Analytics and Reporting
• Pentaho Design Patterns and Best Practices
• Troubleshooting

Introduction

• Tableau Prep Builder as an ETL (Extract, Transform and Load) tool

Setting up Tableau Prep Builder

• Activating and Register Tableau Prep Builder

Overview of Tableau Prep Builder Features and Architecture

• Tableau Prep Builder and its relation to Tableau Desktop, Tableau Server and Tableau Prep Conductor

Navigating the Tableau Prep Builder Workspace 

• Panes and data grids

Connecting to Data Source

• Reading an Excel
• Reading from a database

Shaping Data

• Creating a Join
• Creating a Union

Pivoting Data

• Changing columns to rows

Cleaning Data

• What is dirty data?
• Changing the data type
• Filtering data
• Aggregating data
• Updating multiple values at once

Running a Flow

• Building a flow
• Refreshing a flow
• Running a flow from the command line

Outputing Data to Tableau Desktop

• Analyzing data

Publishing Data

• Packaging a Prep Builder data flow into an extract
• Publishing a flow with Prep Conductor 

Best Practices 

Troubleshooting