CourseImg
  1. Home
  2. Cloud Computing
  3. GOOGLE LOOKER

GOOGLE LOOKER

 Google Looker Data Visualization - C3. Roles and Responsibilities: Relevant work experience on the Looker platform. Looker development with good Data model experience. Expertise in ETL concepts and data visualization techniques Develop, design, and support Interactive dashboards and reports. Provide production support for looker dashboards and reporting solutions along with performance tuning. Should be able to communicate with business users and translate business requirements into looker dashboards and reports. Should be able to monitor team activities and follow Agile methodology for development activities. Candidate should have excellent written and spoken communication and facilitation skills. Ability to facilitate and coordinate discussion and manage the expectations of multiple stakeholders. SQL development experience with an understanding of relational and multi-dimensional data design. Experience in working on GCP data platform .

 

 

Introduction:

  • Introduction
  • Why use Looker?
  • Looker features
  • Setting up the Sandbox
  • Home Interface

Terminologies & Theoretical concepts for Google Looker:

  • Important terms used in Looker
  • Dimensions and Measures

The practical part begins here:

  • Creating your first Look
  • Saving a Look

Filters:

  • Filtering using Dimensions
  • Filtering using Measures

Popular Chart Types:

  • Single-Value Visualization
  • Bar and Column Chart
  • Line Chart
  • Pie Chart
  • Scatterplot
  • GeoMaps

Look View-mode:

  • Look view-mode

Looker Dashboards:

  • Creating a Dashboard in Looker
  • Adding filters to a dashboard
  • Setting the tiles and other options

Folders in Looker:

  • Creating folders and Managing Access

Downloading and sharing content:

Downloading Looks and dashboards

Sharing and Sending mails

Boards

  • Boards

LookML:

  • Why use LookML
  • Advantages of LookML
  • LookML important terms
  • Interface of LookML
  • How to create Views in LookML
  • SQL runner in Looker

Dimensions in Looker:

  • Dimensions - Syntax ed
  • Dimensions - Number
  • Dimensions - String
  • Dimensions - YesNo
  • Dimensions - Tier
  • Dimensions - Location - Tier
  • Dimensions - Date Time and Others

Creating Dimensions in Looker:

  • Dimensions in looker - Data sample and import
  • Dimensions in looker - For Airport view
  • Dimensions in looker - Creating single view explore
  • Dimensions in looker - Creating Airport dashboard
  • Dimensions in looker - Explore and look for Flight view

Measures:

  • Measures - Syntax
  • Measures - Average
  • Measures - Average Distinct
  • Measures - Count and Count Distinct
  • Measures - Other common measures
  • Measures - Running total
  • Measures - Percent of previous
  • Measures - Percent of total
  • Measures - List
  • Measures - YesNo

Creating Dimensions in Looker:

  • Measures in Looker - Data Sample and Measures calculation
  • Measures in Looker - Creating Measures
  • Measures in Looker - Measures in a look

Substitution operator:

  • Substitution operator

Joins Prerequisites:

Types of joins - Introduction and Left Join:

  • Types of joins - Full Outer join
  • Types of joins - Inner Join
  • Types of joins - Cross Join
  • Relationships for joins - Introduction
  • Relationships for joins - Why should we use relationships for joins
  • Primary Keys

Creating Joins in Looker:

  • Joins in Looker - Syntax
  • Joins in Looker - Syntax Example
  • Joins in Looker - Creating joins
  • Joins in Looker - Exploring joins in a look

Customization in Looker:

  • Customizing explore menu - Concepts and Syntax
  • Customizing explore menu - Application in looker
  • Customizing Field Picker - Concepts and Syntax
  • Customizing Field Picker - Application in Looker
Quick Enroll

Copyright © 2017 - Developed by Infihive Consulting Services LLC changes