Get Started ~ Talend/Big Data/GCP BigQuery & Data Studio

Name: Get Started ~ Talend/Big Data/GCP BigQuery & Data Studio
Rating: 3.5 (33 reviews)

Fast track instruction to ingest, convert, load & visualize a BigQuery table using TOS (Talend Open Studio) for Big Data

Created byJoan Macijunas

Last updated 2/2020

English

English [Auto],

What you'll learn

Share techniques to connect successfully with Talend Open Studio to Google Cloud Platform services
Fast track steps to use TOS to load tables in BigQuery and access using SQL queries
Learn best techniques to convert source datatypes to modified target datatypes
Cover basic GCP /project/dataset/table and compute storage BigQuery requirements
Cover basic TOS Big Data job design, execution and resolution research
Experience the agility to build, load and analyze data with GCPs fully managed services
Visualize Data Results with Google Data Studio

Course content

5 sections • 11 lectures • 56m total length

Before We Dive Right In1:04
Download three data sets from the reserved section, create a free Google Cloud Platform account, and download Talend Open Studio for Big Data version 7.
Data Warehouse and Columnar Datastores4:41
Explore data warehouses and the star schema with fact and dimension tables, while examining primary and foreign keys in columnar stores for faster queries and better compression.

Talend ETL Successful Run & BQ Validation3:53
Execute a Talend Open Studio ETL job version 7, validate the run in BigQuery, confirm exit code 0, refresh project history, and overwrite the target table when needed.
Talend ETL Job (let's build that job together from scratch)9:53
Build a Talend ETL job from scratch, wiring file input delimited, tConvert, and file output delimited, then load the results into a BigQuery table.
Talend ETL Results Validation (did we miss any checkboxes ?:) )1:35

Visualization & The Science of Dashboard Design6:05
Learn to ingest data with Talend Open Studio for Big Data, load into BigQuery, and visualize results in Google Data Studio, while mastering dashboard design, SQL validation, and BI workflow.
Bonus: Since we are using GCP, Let's Create a Data Studio Dashboard12:37
As an added bonus to take us beyond SQL reporting, let's see the power of visualization with Google Data Studio. Since this course utilized GCP BigQuery, Google Data Studio has been chosen over many other visualization tools (QuickSight, Tableau, Qlik) etc to name a few.

Requirements

Google Cloud Platform Account (free GCP account)
Talend Open Studio for Big Data software (opensource download)
Basic Talend Open Studio knowledge
Basic SQL knowledge (Queries, Table Design)
A Windows, Linux or Mac PC/Laptop
Internet Access

Description

This course will guide you step-by-step to ingest a local file, convert data types and load to GCP's (Google Cloud Platform) BigQuery using Talend Open Studio for Big Data, and immediately access and analyze the BigQuery table using SQL statements. We will also visualize the data results using Google Data Studio. This course is designed to piece together all the components, not focus on a particular software product. We will look at configuration areas that can be time consuming to troubleshoot. The focus and emphasis is on the entire workflow success and encourage the student to move on to more sophisticated approaches.

Who this course is for:

Data Analysts
Cloud BigQuery Analysts
Talend ETL Analysts for Big Data (GCP specific)

Get Started ~ Talend/Big Data/GCP BigQuery & Data Studio

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 6min

Google Cloud Platform Walk-thru / Storage / BigQuery Tables etc.3 lectures • 13min

Talend Open Studio for Big Data using GCP BigQuery3 lectures • 15min

Data Exploration of the BigQuery Table1 lecture • 4min

Data Visualization of the BigQuery Table using Google Data Studio2 lectures • 19min

Requirements

Description

Who this course is for: