This course is an introductory-level training that outlines Looker’s capabilities for working with data and provides guided demos and hands-on practice with Looker functionality for data exploration, analysis and visualisation.
1 day course
Supporting material
Google Cloud Partner of the Year
Private
Private
A private training session for your team. Groups can be of any size, at a location of your choice including our training centres.
In this course, you will learn how to undertake data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts.
Upon completion of this course, you will be able to leverage Looker's modern analytics platform to find and explore relevant content in your organisation’s Looker instance, ask questions of your data, create new metrics as needed, and build and share visualisations and dashboards to facilitate data-driven decision making.
Jellyfish has recently been named a Google Cloud Specialisation Partner of the Year. This title recognises our commitment to provide world-leading Cloud-based Training solutions that help our clients succeed.
Course overview
Who should attend:
Business users who need to draw insights from data; Data analysts who are responsible for data analysis and visualisation within their organisations.
Walk away with the ability to:
Define Looker and the capabilities it provides for working with data
Explain the four core analytical concepts in Looker (dimensions, measures, filters, pivots)
Use dimensions, measures, filters and pivots to analyse and visualise data
Create advanced metrics instantaneously with table calculations
Create dashboards to combine and share visualisations
Utilise folders and boards in Looker to organise content for navigability and discoverability
Prerequisites
No prior technical knowledge is required.
Course agenda
Module 1: Introduction to Looker
Looker interface and components
Define Looker and the capabilities it provides for working with data
Navigate the Looker interface to access data and functionality
Module 2: Core Analytics Concepts
Dimensions, measures, filters, pivots
Explain the four core analytical concepts in Looker (dimensions, measures, filters and pivots)
Use dimensions to access data attributes
Use measures to aggregate data attributes
Combine dimensions and measures for richer data analysis and visualisation
Filter dimensions and measures to analyse a subset of data
Use pivots to restructure and group data
Module 3: Table Calculations
Table calculations, offset functions
Explain how table calculations and offset functions are used to work with data in Looker
List the types of table calculations and offset functions available in Looker
Create new metrics instantaneously with table calculations and offset functions
Module 4: Dashboards
Looker dashboards, data delivery options
Understand how to use dashboards in Looker to share data and results with stakeholders
Create dashboards to visualise multiple aspects of a business topic or domain
Add new content to an existing dashboard
Add filters to a dashboard for flexible analysis of a subset of the data
Deliver data outside of Looker for access by other stakeholders or systems
Module 5: Content Management
Looker content organisation, folders, boards
Explain how to use folders in Looker to organise content for navigability and discoverability
Create and share boards to centralise content pertaining to one topic or theme