Data Analyst Training of Google BigQuery 2017-08-04T03:19:43+00:00

Data Analyst Training of Google BigQuery

Cloud Technologies 

Data Analyst Training of Google BigQuery

Data Analyst Training of Google BigQuery

Data Analyst Training of Google BigQuery  3-day instructor led class introduces participants to Google BigQuery.

Through a combination of instructor­led presentations, demonstrations, and hands­on labs, students learn how to store, transform, analyze, and visualize data using Google BigQuery.

This Data Analyst Training of Google BigQuery class is intended for data analysts and data scientists responsible for: analyzing and visualizing big data, implementing cloud­based big data solutions, deploying or migrating big data applications to the public cloud, implementing and maintaining large­scale data storage environments, and transforming/processing big data.

Data Analyst Training of Google BigQuery – CPB200 will introduce you to Google BigQuery. Through instructor-led online classrooms, demonstrations, and hands-on labs, you’ll learn to store, transform, analyze, and visualize data using Google BigQuery.

Duration

24 hours (usually 3 days including breaks)

TRAINING METHODOLOGY

In Class: $9,999
Locations: NEW YORK CITY, D.C, BAY AREA.
Next Session: Aug 14th 2017

Online: $4,999
Next Session: Aug 6th 2017

Home / All courses /  Cloud Technologies /Data Analyst Training of Google BigQuery

Data Analyst Training of Google BigQuery

Instructor: John Doe, Lamar George

DESCRIPTION

Data Analyst Training of Google BigQuery

Data Analyst Training of Google BigQuery

Data Analyst Training of Google BigQuery course is the final to become a Google data engineer by mastering Google BigQuery.

At the end of this one­day course, participants will be able to:

  • Understand the purpose of and use cases for Google BigQuery
  • Describe ways in which customers have used Google BigQuery to improve their businesses
  • Understand the architecture of Google BigQuery and how queries are processed
  • Interact with BigQuery using the web UI and command­line interface
  • Identify the purpose and structure of Google BigQuery schemas and data types
  • Understand the purpose of and advantages of Google BigQuery destinations tables and caching
  • Use Google BigQuery jobs
  • Transform and load data into Google BigQuery
  • Export data from Google BigQuery
  • Store query results in a destination table
  • Create a federated query
  • Export log data to Google BigQuery and query it
  • Understand the Google BigQuery pricing structure and evaluate mechanisms for controlling query and storage costs
  • Identify best practices for optimizing query performance
  • Troubleshoot common errors in Google BigQuery
  • Use various Google BigQuery functions
  • Use external tools such as spreadsheets to interact with BigQuery
  • Visualize BigQuery data
  • Use access controls to restrict access to Google BigQuery data
  • Query Google Analytics Premium data exported to Google BigQuery

Requirements

Before attending this course, participants should have:

  • Attended CP100A ­ Google Cloud Platform Fundamentals OR CPB100 ­ Google Cloud Platform Big Data & Machine Learning Fundamentals (or equivalent experience)
  • Experience using an SQL­like query language to analyze data

The average salary ranges from approximately $103,582 per year

CURRICULUM

Module 1: Introducing Google BigQuery

● Understand the purpose of and use cases for Google BigQuery

● Describe ways in which customers have used Google BigQuery to improve their businesses

Lab: Sign Up for the Free Trial and Create a Project

● Register for the GCP free trial

● Create a project using the Cloud Platform Console

Module 2: BigQuery Functional Overview

● Describe the components of a BigQuery project

● Identify how BigQuery stores data and list the advantages of the storage model

● Understand the architecture of BigQuery and how queries are processed

● Describe the methods of interacting with BigQuery

Lab: Explore BigQuery Interfaces

● Explore features of the BigQuery web UI

● Learn how to use the BQ shell

● Execute queries using the BigQuery CLI in Cloud Shell

Module 3: BigQuery Fundamentals

● Describe the purpose of denormalizing data

● Identify the purpose and structure of BigQuery schemas and data types

● Explain the types of actions available in BigQuery jobs

● Understand the purpose of and advantages of BigQuery destinations tables and caching

Lab: BigQuery Components and Jobs

● Explore how data is organized in BigQuery

● Learn about the two types of table schemas

● Learn about jobs, and how to cancel them

● Investigate caching and destination tables

Module 4: Ingesting, Transforming, and Storing Data

● Describe the methods for ingesting data, transforming data, and storing data using BigQuery

● Explain the function of BigQuery federated queries

Lab 4, Part I: Loading Data into BigQuery and Using Federated Queries

● Load a CSV file into a BigQuery table using the web UI

● Load a JSON file into a BigQuery table using the CLI

● Transform data and join tables using the web UI

● Store query results in a destination table

● Query a destination table using the web UI to confirm your data was transformed and loaded correctly

● Export query results from a destination table to Google Cloud Storage

● Create a federated query that queries data in Cloud Storage

Lab 4, Part II: Exporting App Engine Logs to BigQuery

● Set up Google Cloud Logging to export App Engine log data from the Guestbook application

● Use the BigQuery web UI to query the log data

Module 5: Pricing and Quotas

● Explain the advantages of the BigQuery pricing model

● Use the pricing calculator to calculate storage and query costs

● Identify the quotas that apply to BigQuery projects

Lab: BigQuery Pricing

● Evaluate the size of a query within BigQuery using the BigQuery web UI

● Use the Pricing Calculator and the total size of the query to estimate the query cost

● Examine how changing a query affects query cost

Module 6: Clauses and Functions

● Explain the differences between BigQuery SQL and ANSI SQL

● Identify the purpose of and use cases for user­defined functions

● Explain the purpose of various BigQuery functions

Lab: BigQuery Clauses and Functions

● Create and run a query using a wildcard function

● Create and run a query using a window function

● Create and run a query using a user­defined function

Module 7: Nested and Repeated Fields

● Identify the purpose and structure of BigQuery nested, repeated, and nested repeated fields

● Describe the use cases for nested, repeated, and nested repeated fields

Lab: Nested Fields

● Create a BigQuery table using nested data

● Run queries to explore the structure of the nested data

Lab: Repeated Fields

● Create a BigQuery table using repeated data

● Run queries to explore the structure of the repeated data

Lab: Nested Repeated Fields

● Create a BigQuery table using nested repeated data

● Run queries to explore the structure of the nested repeated data

Module 8: Query Performance

● Explain the impact of the following in query performance: JOIN and GROUP BY, table wildcards, and table decorators

● Identify various best practices for optimizing query performance

Lab: BigQuery Best Practices and Optimization Techniques

● Use denormalization to improve query performance

● Use sub selects to improve the performance of queries with JOIN clauses

● Use destination tables to lower costs when running multiple, similar queries

● Use table decorators and table wild cards to improve query performance and to reduce costs

Module 9: Troubleshooting Errors

● Describe how to handle the most common BigQuery errors: request encoding errors, resource errors, and HTTP errors

Lab: Handling Errors

● Correct queries that produce syntax­related error messages

● Correct an error involving the order of a JOIN clause

● Correct an error involving an invalid table name

● Modify queries that exceed resource constraints

Module 10: Access Control

● Describe the purpose of access control lists in BigQuery

● List and explain the project and data set roles available in BigQuery

● Apply views for row­level security

Lab: Access Control

● Manage access to datasets using project­level ACLs

● Manage access to datasets using dataset­level ACLs

● Set row­level permissions using views

Module 11: Exporting Data

● List the methods of exporting data from BigQuery and the data formats available

● Describe the process of creating a job to export data from BigQuery

● Explain the purpose of wild card exports to partition export data

Lab: Exporting Data

● Export data from BigQuery using the web UI and CLI

● Export large tables using wildcard URIs

Module 12: Interfacing with External Tools

● Describe how to use external tools to interface with BigQuery, including spreadsheets, ODBC and JDBC drivers, the BigQuery encrypted client, and R

Lab: Interfacing with External Tools

● Set up the BigQuery Reports add­on for Google Sheets

● Use the Reports add­on to query BigQuery data

Module 13: Working with Google Analytics Premium Data

● Describe the schema of the Google Analytics Premium and AdSense data exported to BigQuery

Lab: Working with Google Analytics Premium Data

● Build queries to analyze data from Google Analytics Premium

Module 14: Data Visualization

● Describe the options available for visualizing BigQuery data

Lab: Visualizing Data

● Use Google Cloud Datalab to visualize data

Online: $4999
Next Batch: starts from Aug 6th 2017

In Class: $9999
Locations: New York City, D.C., Bay Area
Next Batch: starts from Aug 14th 2017

COURSE HIGHLIGHTS

Skill level: Intermediate
Language: English
Certificate: No
Assessments: Self
Prerequisites: Basic Python programming

SCHEDULE YOUR FREE DEMO

TALK TO US

NEED CUSTOM TRAINING FOR YOUR CORPORATE TEAM?

NEED HELP? MESSAGE US

SOME COURSES YOU MAY LIKE

data science Bootcamp
Deep Learning with Tensor Flow In-Class or Online

Good grounding in basic machine learning. Programming skills in any language (ideally Python/R).

Instructors: John Doe, Lamar George
Duration:
 
50 hours
Lectures:  25

Neural Networks Fundamentals using Tensor Flow as Example Training (In-Class or Online) 

Good grounding in basic machine learning. Programming skills in any language (ideally Python/R).

Instructors: John Doe, Lamar George
Duration:
 
50 hours
Lectures:  25

Deep learning tutorial

Tensor Flow for Image Recognition Bootcamp (In-Class and Online)

Good grounding in basic machine learning. Programming skills in any language (ideally Python/R).

Instructors: John Doe, Lamar George
Duration:
 
50 hours
Lectures:  25

OUR PRODUCTS

SOME OTHER COURSES YOU MAY LIKE

FAQ'S

FAQ

What is the duration of the Data Analyst Training of Google BigQuery course?

Advanced Course like Data Analyst Training of Google BigQuery Training Course duration largely depends on trainee requirements, it is always recommended to consult one of our advisors for specific course duration.
What If I Miss A Data Analyst Training of Google BigQuery Class?
We record each LIVE class session you undergo through and we will share the recordings of each session/class.
Can I Request For A Support Session If I Find Difficulty In Grasping Data Analyst Training of Google BigQuery Topics?
If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers.
What Kind Of Projects Will I Be Working On As Part Of The Data Analyst Training of Google BigQuery Training?
You will work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready.
How Will I Execute The  Data Analyst Training of Google BigQuery Practical?
Our Trainers will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.
Are These  Data Analyst Training of Google BigQuery Classes Conducted Via Live Online Streaming?
Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.
Will the Data Analyst Training of Google BigQuery course fetch me a job?
The Data Analyst Training of Google BigQuery by BigdataGuys will not only increase your CV potential but will offer you a global exposure with enormous growth potential.

STUDENTS WHO VIEWED THIS COURSE ALSO VIEWED

[thim-courses featured=”” order=”category” cat_id=”1214″ layout=”grid” css_animation=”appear”]