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
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:
‘;
}});
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
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
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
