EncartaLabs

Matillion - ETL

( Duration: 1 Day )

In Matillion - ETL training course, you will learn the process to extract, migrate and transform data in the cloud using Matillion Software. In this, Matillion ETL workshop you will learn the concepts such as data export/import, scripting, audit logs, collaboration, job scheduling, version control, task management and much more through real-time scenarios.

COURSE AGENDA

1

Stage Airports Data Using the RDS Query Component

2

Data Preparation - Create Tables

3

Join Each Airport to its US State

4

Create the Airports Dimension Table

5

Load Flights Data Using the S3 Load Generator Component

6

Data Preparation - Create Views

7

Load Multiple Flights Data Files Using the Fixed Iterator Component

8

Control Business Logic with Logical Operators

9

Control Business Logic with Transactions

10

Schedule a Job

11

Cleanse Data and Rank Flights Based on Their Airtime

12

Convert Distances Using The Fixed Flow Component

13

Create the Fact Table For Flight Analysis

14

Load Data Into The Fact Table And Calculate the Average Delay Per Flight

15

Create a Date Dimension From a Sequence of Numbers

16

Add Month Names and Days of the Week to the Date Dimension

17

Calculate Days Per Month and Tidy Up Output Data

18

Interact with the AWS Console

19

Move Files, Write a Python Script and Use Password Manager

20

Add UK Holidays to the Date Dimension

21

Use Extract to New Job Feature to Reorganise Business Logic

22

Detect Changes in the Airports Data

23

Update Dimension Tables with New Changes

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top