1 day course

Partner of the Year

Private

A private training session for your team. Groups can be of any size, at a location of your choice including our training centres.

Certificate of Attendance

As a Google Cloud Partner, Jellyfish provides world-leading Cloud-based training solutions to help clients succeed.

This introductory-level session outlines Looker’s capabilities for working with data, and provides guided demos and hands-on practice of data exploration, analysis and visualisation.

During the course, you’ll learn how to leverage Looker's modern analytics platform to find and explore relevant content in your organisation’s Looker instance. You’ll also be shown how to ask questions of your data, create new metrics as needed, and build and share visualisations and dashboards to facilitate data-driven decision-making.

Our Analysing and Visualising Data in Looker course is available as a private training session that can be delivered via Virtual Classroom, at our training centre in The Shard, or at a location of your choice in the UK.

Course overview

Who should attend:

This course is suitable for business users who need to draw insights from data, as well as data analysts who are responsible for data analysis and visualisation within their organisations.

What you'll learn:

By the end of this course, you will be able 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

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: Looks & Dashboards

Looks, Looker dashboards, data delivery options
Explain how to create and deliver Looks and dashboards in Looker to share results with stakeholders
Discuss how to create and share standalone visualisation reports called Looks
Discuss how to create and share dashboards to combine multiple visualisations for a business topic or domain
Add new content to an existing dashboard
Add filters to a Look or dashboard for flexible analysis of a subset of the data
Discuss the delivery of 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