Analysing and Visualising Data in Looker

Want to learn how to undertake data exploration and analysis in Looker that would formerly be done by SQL developers or analysts? Then this one-day course is the perfect place to start.

google badge
Book this course
Call our sales team today
1 day course
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.

Buy 1 Private Course, Get 2 Scheduled Courses Free

Buy any private course for delivery in 2024, and receive two free scheduled training courses to be taken before March 31, 2025. See our offers page for more details.

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 visualization.

During the course, you’ll learn how to leverage Looker's modern analytics platform to find and explore relevant content in your organization’s Looker instance. You’ll also be shown how to ask questions of your data, create new metrics as needed, and build and share visualizations 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 or at a location of your choice in South Africa.

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 visualization within their organizations.

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 analyze and visualize data
  • Create advanced metrics instantaneously with table calculations
  • Create dashboards to combine and share visualizations
  • Utilize folders and boards in Looker to organize 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 visualization
  • Filter dimensions and measures to analyze 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 visualization reports called Looks
  • Discuss how to create and share dashboards to combine multiple visualizations 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 organization, folders, boards
  • Explain how to use folders in Looker to organize content for navigability and discoverability
  • Create and share boards to centralize content pertaining to one topic or theme
close
Don't miss out
Keep up to date with news, views and offers from Jellyfish Training.
Your data will be handled in accordance with our Privacy Policy