[{"id":"75697","title":"The Looker platform","description":"

This module provides an overview of the Looker user interface and its key components for data explorers.

","steps":[{"id":"523954","prompt":null,"isOptional":true,"activities":[{"id":"516790","href":"/paths/18/course_templates/323/video/516790","isLocked":false,"duration":127000,"title":"What is Looker?","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523955","prompt":null,"isOptional":true,"activities":[{"id":"516791","href":"/paths/18/course_templates/323/video/516791","isLocked":false,"duration":814000,"title":"Looker user interface","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523956","prompt":null,"isOptional":true,"activities":[{"id":"516792","href":"/paths/18/course_templates/323/video/516792","isLocked":false,"duration":235000,"title":"Organizing content with folders","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523957","prompt":null,"isOptional":false,"activities":[{"id":"516793","href":"/paths/18/course_templates/323/quizzes/516793","isLocked":false,"duration":1800000,"title":"Module 1 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75698","title":"Data analysis building blocks","description":"

This module reviews three data analysis building blocks - dimensions, measures, and filters.

","steps":[{"id":"523958","prompt":null,"isOptional":true,"activities":[{"id":"516794","href":"/paths/18/course_templates/323/video/516794","isLocked":false,"duration":189000,"title":"Dimensions in Looker","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523959","prompt":null,"isOptional":true,"activities":[{"id":"516795","href":"/paths/18/course_templates/323/video/516795","isLocked":false,"duration":90000,"title":"Measures in Looker","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523960","prompt":null,"isOptional":true,"activities":[{"id":"516796","href":"/paths/18/course_templates/323/video/516796","isLocked":false,"duration":152000,"title":"Example: Exploring measures using customer data","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523961","prompt":null,"isOptional":true,"activities":[{"id":"516797","href":"/paths/18/course_templates/323/video/516797","isLocked":false,"duration":108000,"title":"Using dimensions and measures","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523962","prompt":null,"isOptional":true,"activities":[{"id":"516798","href":"/paths/18/course_templates/323/video/516798","isLocked":false,"duration":120000,"title":"Example: Combining dimensions and measures","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523963","prompt":null,"isOptional":true,"activities":[{"id":"516799","href":"/paths/18/course_templates/323/video/516799","isLocked":false,"duration":147000,"title":"Filtering dimensions","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523964","prompt":null,"isOptional":true,"activities":[{"id":"516800","href":"/paths/18/course_templates/323/video/516800","isLocked":false,"duration":223000,"title":"Filtering measures","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523965","prompt":null,"isOptional":true,"activities":[{"id":"516801","href":"/paths/18/course_templates/323/video/516801","isLocked":false,"duration":133000,"title":"Example: Filtering with measures","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523966","prompt":null,"isOptional":false,"activities":[{"id":"516802","href":"/paths/18/course_templates/323/labs/516802","isLocked":false,"duration":3600000,"title":"Analyzing and Visualizing Data in Looker","description":"In this lab, you will use dimensions, measures, filters, and pivots to create a series of visualizations from the Federal Aviation Administration (FAA) airports and flights datasets and save them to dashboards in Looker.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523967","prompt":null,"isOptional":false,"activities":[{"id":"516803","href":"/paths/18/course_templates/323/quizzes/516803","isLocked":false,"duration":2100000,"title":"Module 2 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75699","title":"Working with Looker content","description":"

This module explores the use of dashboards for multiple visualizations and boards to curate Looker content.

","steps":[{"id":"523968","prompt":null,"isOptional":true,"activities":[{"id":"516804","href":"/paths/18/course_templates/323/video/516804","isLocked":false,"duration":143000,"title":"Filtering Looks","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523969","prompt":null,"isOptional":true,"activities":[{"id":"516805","href":"/paths/18/course_templates/323/video/516805","isLocked":false,"duration":164000,"title":"Introducing dashboards","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523970","prompt":null,"isOptional":true,"activities":[{"id":"516806","href":"/paths/18/course_templates/323/video/516806","isLocked":false,"duration":214000,"title":"Filtering dashboards","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523971","prompt":null,"isOptional":true,"activities":[{"id":"516807","href":"/paths/18/course_templates/323/video/516807","isLocked":false,"duration":329000,"title":"Curating Looker content in boards","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523972","prompt":null,"isOptional":true,"activities":[{"id":"516808","href":"/paths/18/course_templates/323/video/516808","isLocked":false,"duration":59000,"title":"Example: Board creation","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523973","prompt":null,"isOptional":false,"activities":[{"id":"516809","href":"/paths/18/course_templates/323/quizzes/516809","isLocked":false,"duration":2100000,"title":"Module 3 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75700","title":"Customizing Explores","description":"

This module explores pivoting data in Looker to turn a selected dimension into several columns. The module also covers the writing of table calculations to instantaneously create new metrics and offset calculations to programmatically reference values from other rows or columns in your query results to calculate new values.

","steps":[{"id":"523974","prompt":null,"isOptional":true,"activities":[{"id":"516810","href":"/paths/18/course_templates/323/video/516810","isLocked":false,"duration":122000,"title":"Pivoting data in Looker","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523975","prompt":null,"isOptional":true,"activities":[{"id":"516811","href":"/paths/18/course_templates/323/video/516811","isLocked":false,"duration":155000,"title":"Example: Working with pivots","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523976","prompt":null,"isOptional":true,"activities":[{"id":"516812","href":"/paths/18/course_templates/323/video/516812","isLocked":false,"duration":158000,"title":"Introduction to table calculations","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523977","prompt":null,"isOptional":true,"activities":[{"id":"516813","href":"/paths/18/course_templates/323/video/516813","isLocked":false,"duration":281000,"title":"Types of table calculations","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523978","prompt":null,"isOptional":true,"activities":[{"id":"516814","href":"/paths/18/course_templates/323/video/516814","isLocked":false,"duration":338000,"title":"Writing table calculations","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523979","prompt":null,"isOptional":true,"activities":[{"id":"516815","href":"/paths/18/course_templates/323/video/516815","isLocked":false,"duration":154000,"title":"Example: Writing and visualizing table calculations","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523980","prompt":null,"isOptional":true,"activities":[{"id":"516816","href":"/paths/18/course_templates/323/video/516816","isLocked":false,"duration":301000,"title":"Example: Percent of total table calculations","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523981","prompt":null,"isOptional":true,"activities":[{"id":"516817","href":"/paths/18/course_templates/323/video/516817","isLocked":false,"duration":325000,"title":"Introducing offset functions","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523982","prompt":null,"isOptional":true,"activities":[{"id":"516818","href":"/paths/18/course_templates/323/video/516818","isLocked":false,"duration":253000,"title":"Writing offset calculations","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523983","prompt":null,"isOptional":true,"activities":[{"id":"516819","href":"/paths/18/course_templates/323/video/516819","isLocked":false,"duration":124000,"title":"Example: Writing offset calculations","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523984","prompt":null,"isOptional":false,"activities":[{"id":"516820","href":"/paths/18/course_templates/323/labs/516820","isLocked":false,"duration":3600000,"title":"Getting Started with Table Calculations and Offsets in Looker","description":"In this lab, you will use table calculations and offsets to create a series of visualizations from a simulated ecommerce dataset and save them to dashboards in Looker.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523985","prompt":null,"isOptional":false,"activities":[{"id":"516821","href":"/paths/18/course_templates/323/quizzes/516821","isLocked":false,"duration":3600000,"title":"Module 4 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75701","title":"Creating new Looker content","description":"

This module explores the creation of single, stand-alone reports (Looks) and dashboards, which can be used to combine individual visualizations.

","steps":[{"id":"523986","prompt":null,"isOptional":true,"activities":[{"id":"516822","href":"/paths/18/course_templates/323/video/516822","isLocked":false,"duration":325000,"title":"Creating new Looks","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523987","prompt":null,"isOptional":true,"activities":[{"id":"516823","href":"/paths/18/course_templates/323/video/516823","isLocked":false,"duration":146000,"title":"Creating new dashboards","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523988","prompt":null,"isOptional":false,"activities":[{"id":"516824","href":"/paths/18/course_templates/323/quizzes/516824","isLocked":false,"duration":1200000,"title":"Module 5 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75702","title":"Sharing Looker data with others","description":"

This module explores how you can share or export content from Looker.

","steps":[{"id":"523989","prompt":null,"isOptional":true,"activities":[{"id":"516825","href":"/paths/18/course_templates/323/video/516825","isLocked":false,"duration":255000,"title":"Sharing and scheduling Looks","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523990","prompt":null,"isOptional":true,"activities":[{"id":"516826","href":"/paths/18/course_templates/323/video/516826","isLocked":false,"duration":331000,"title":"Sharing and scheduling dashboards","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523991","prompt":null,"isOptional":true,"activities":[{"id":"516827","href":"/paths/18/course_templates/323/video/516827","isLocked":false,"duration":322000,"title":"Tile-level dashboard alerts","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"523992","prompt":null,"isOptional":false,"activities":[{"id":"516828","href":"/paths/18/course_templates/323/quizzes/516828","isLocked":false,"duration":1800000,"title":"Module 6 Quiz","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"75703","title":"Course Resources","description":"

PDF links to all modules

","steps":[{"id":"523993","prompt":null,"isOptional":true,"activities":[{"id":"516829","href":"/paths/18/course_templates/323/documents/516829","isLocked":false,"duration":1800000,"title":"Course Resources","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"next-steps","title":"Your Next Steps","description":null,"steps":[{"id":"badge-step","prompt":null,"isOptional":true,"activities":[{"id":"badge","href":null,"isLocked":true,"duration":null,"title":"Course Badge","description":null,"type":"badge","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":true}]

Google Cloud Skills Boost

05

Analyzing and Visualizing Data in Looker