• Post category:StudyBullet-12
  • Reading time:16 mins read


Learn Google’s Data Visualization tools – Looker and Looker Studio (previously Google Data Studio) + LookML for Devs

What you will learn

How to use Looker and Looker Studio to turns your data into fully customizable informative reports and dashboards

Learn why businesses should use Looker to explore their data

How to visualize data using popular chart types in Looker and Looker Studio

Filter and sort data to find the right answer for your business questions

Sharing and collaborating on Looker studio reports

Branding a report – Adding Logo and setting theme

How to share and schedule charts and dashboards with team mates

Description

5 Reasons why you should choose this Google Looker and Looker Studio course

  • Carefully designed course, teaching you not only how to draw all types of charts in Looker and Looker Studio
  • Concise – you can complete this Looker and Looker Studio course within a week
  • Business-related examples and case studies
  • Downloadable resources for learning Data Visualization
  • Your queries will be responded by the Instructor himself

Start using Google’s Looker and Looker Studio to their full potential to become proficient at Looker and Data Visualization and reporting tasks today!

Either you’re new to Data Visualization or Google Looker and Looker Studio, or you’ve made some charts and graphs using some data visualization software such as MS Excel or Tableau. Either way, this course will be great for you.

A Verifiable Certificate of Completion is presented to all students who undertake this Google Looker course.

Why should you choose this course?

This is a complete and concise tutorial on Google Looker which can be completed within 6 hours. We know that your time is important and hence we have created this fast paced course without wasting time on irrelevant operations.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. We have in-depth understanding on and practical exposure to Google Looker and Data Visualization.

We are also the creators of some of the most popular online courses – with over 600,000 enrollments and thousands of 5-star reviews like these ones:


Get Instant Notification of New Courses on our Telegram channel.


I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! – Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. – Armand

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, Google Looker, Data Visualization, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

And so much more!

By the end of this course, your confidence in using Google Looker for data visualization will soar. You’ll have a thorough understanding of how to use Google Looker for creating insightful dashboards and beautiful reports.

Go ahead and click the enroll button, and I’ll see you in lesson 1 of this Google Data Studio course!

Cheers

Start-Tech Academy

English
language

Content

Introduction

Introduction
Why use Looker?
This is a Milestone!
Course Resources
Google Data Viz & Bi products

Google Data Studio

Why Data Studio?

Terminologies & Theoretical concepts for Data Studio

Data Studio Home Screen & Dataset vs Data Source
Structure of Input data
Dimensions vs Measures (new definition)

Practical part begins here

Opening Data Studio
Adding a data source
Managing added data source

Charts to highlight numbers

Data Table
Styling tab for data table
Scorecards

Charts for comparing categories : Bar charts and stacked charts

Simple Bar and Column chart
Stacked Column chart

Charting maps of a country, continent, or a region – Geomaps

GeoMap

Charts to highlight trends: Time Series, Line and Area charts

Time Series
Update to Time Series chart
Line Chart and Combo Chart

Highlight contribution to total: Pie chart & Donut Chart

Pie Chart and Donut Chart
Stacked Area Charts

Relationship between two or more variables: Scatter plots

Scatter Plots and Bubble charts

Aggregating on two dimension: Pivot tables

Pivot tables for cross tabulation

All about a single Metric: Bullet Chart

Bullet Chart

Chart for highlighting heirarchy: TreeMap

TreeMaps

Branding a Report

Branding a Report: Brand Logo and Company Details
Brand colors for report branding

Giving the power to filter Data to viewers

Filter controls for viewers

Add Videos, Feedback form etc. to your Report

URL Embed to include external content

Sometimes data is in multiple tables

Blending data from multiple tables
Different types of Joins while blending data

Sharing and Collaborating on Data Studio report

Downloading report as PDF and Page Management
Sharing report and Data Credentials
Sharing report using a link
Scheduling emails
Embeding report on Website

Google BigQuery Connection

Connecting and Visualizing Data in Google BigQuery

Charting Best Practices

Highlighting chart message
Eliminating Distractions from the Graph
Avoiding clutter
Avoiding the Spaghetti plot

Looker Features

Looker features
Setting up the Sandbox
Home Interface

Terminologies & Theoretical concepts for Google Looker

Important terms used in Looker
Dimensions and Measures

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

Custom fields

Table Calculations
Creating a custom dimension using a Looker expression
Binning – Custom Dimension
Groups – Custom Dimension
Custom Measures

Look view-mode

Look view-mode
Other options in 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 to use LookML
LookML Slides
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 Measures 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

Customising explore menu – Concepts and Syntax
Customizing explore menu – Application in looker
Customizing Field Picker – Concepts and Syntax
Customizing Field Picker – Application in Looker

Git and Github : Basics

Git and Github : Basics

Congratulations & About your certificate

The final milestone!
Bonus Lecture