[{"id":"75524","title":"Introducing Looker and LookML","description":"

This module provides an overview of Looker and the Looker integrated development environment (IDE) for LookML developers.

","steps":[{"id":"522752","prompt":null,"isOptional":true,"activities":[{"id":"515582","href":"/paths/18/course_templates/327/video/515582","isLocked":false,"duration":221000,"title":"Looker and LookML","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522753","prompt":null,"isOptional":true,"activities":[{"id":"515583","href":"/paths/18/course_templates/327/video/515583","isLocked":false,"duration":469000,"title":"The Looker user interface","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522754","prompt":null,"isOptional":true,"activities":[{"id":"515584","href":"/paths/18/course_templates/327/video/515584","isLocked":false,"duration":421000,"title":"The Looker IDE","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522755","prompt":null,"isOptional":true,"activities":[{"id":"515585","href":"/paths/18/course_templates/327/video/515585","isLocked":false,"duration":422000,"title":"LookML project version control","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522756","prompt":null,"isOptional":true,"activities":[{"id":"515586","href":"/paths/18/course_templates/327/video/515586","isLocked":false,"duration":305000,"title":"Example: Git workflow in Looker","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522757","prompt":null,"isOptional":true,"activities":[{"id":"515587","href":"/paths/18/course_templates/327/video/515587","isLocked":false,"duration":271000,"title":"How Looker writes SQL","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522758","prompt":null,"isOptional":false,"activities":[{"id":"515588","href":"/paths/18/course_templates/327/quizzes/515588","isLocked":false,"duration":2700000,"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":"75525","title":"Data Modeling using LookML","description":"

This module reviews how to model new dimensions and measures using LookML. The module also explores the use of dashboards to combine key queries and visualizations into a one page executive view

","steps":[{"id":"522759","prompt":null,"isOptional":true,"activities":[{"id":"515589","href":"/paths/18/course_templates/327/video/515589","isLocked":false,"duration":426000,"title":"Anatomy of a LookML project","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522760","prompt":null,"isOptional":true,"activities":[{"id":"515590","href":"/paths/18/course_templates/327/video/515590","isLocked":false,"duration":586000,"title":"Modeling dimensions","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522761","prompt":null,"isOptional":true,"activities":[{"id":"515591","href":"/paths/18/course_templates/327/video/515591","isLocked":false,"duration":405000,"title":"Example: Creating dimensions using LookML","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522762","prompt":null,"isOptional":true,"activities":[{"id":"515592","href":"/paths/18/course_templates/327/video/515592","isLocked":false,"duration":223000,"title":"Modeling measures","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522763","prompt":null,"isOptional":true,"activities":[{"id":"515593","href":"/paths/18/course_templates/327/video/515593","isLocked":false,"duration":267000,"title":"Example: Modeling measures using LookML","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522764","prompt":null,"isOptional":true,"activities":[{"id":"515594","href":"/paths/18/course_templates/327/video/515594","isLocked":false,"duration":221000,"title":"Dimension + measure modeling logic","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522765","prompt":null,"isOptional":false,"activities":[{"id":"515595","href":"/paths/18/course_templates/327/labs/515595","isLocked":false,"duration":3600000,"title":"Creating Dimensions and Measures with LookML","description":"In this lab, you write LookML code to create new dimensions and measures for business users using a mock e-commerce dataset containing information on orders and users.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522766","prompt":null,"isOptional":true,"activities":[{"id":"515596","href":"/paths/18/course_templates/327/video/515596","isLocked":false,"duration":360000,"title":"LookML dashboards","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522767","prompt":null,"isOptional":false,"activities":[{"id":"515597","href":"/paths/18/course_templates/327/quizzes/515597","isLocked":false,"duration":3000000,"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":"75526","title":"Modeling Explores for your Users","description":"

This module provides a deeper dive into the model files of LookML projects for developers to start designing and building custom Explores for business users.

","steps":[{"id":"522768","prompt":null,"isOptional":true,"activities":[{"id":"515598","href":"/paths/18/course_templates/327/video/515598","isLocked":false,"duration":678000,"title":"Modeling new Explores","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522769","prompt":null,"isOptional":true,"activities":[{"id":"515599","href":"/paths/18/course_templates/327/video/515599","isLocked":false,"duration":341000,"title":"Using LookML to filter Explores","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522770","prompt":null,"isOptional":true,"activities":[{"id":"515600","href":"/paths/18/course_templates/327/video/515600","isLocked":false,"duration":618000,"title":"Understanding symmetric aggregation","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522771","prompt":null,"isOptional":false,"activities":[{"id":"515601","href":"/paths/18/course_templates/327/quizzes/515601","isLocked":false,"duration":1800000,"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":"75527","title":"Working with Derived Tables","description":"

This module explains how to use derived tables in Looker to create new custom tables that do not yet exist in the underlying database. This module also provides an overview of how caching works in Looker and how developers can use datagroups to manage caching policies.

","steps":[{"id":"522772","prompt":null,"isOptional":true,"activities":[{"id":"515602","href":"/paths/18/course_templates/327/video/515602","isLocked":false,"duration":437000,"title":"Introducing derived tables","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522773","prompt":null,"isOptional":true,"activities":[{"id":"515603","href":"/paths/18/course_templates/327/video/515603","isLocked":false,"duration":202000,"title":"Types of derived tables","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522774","prompt":null,"isOptional":true,"activities":[{"id":"515604","href":"/paths/18/course_templates/327/video/515604","isLocked":false,"duration":365000,"title":"Using SQL derived tables","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522775","prompt":null,"isOptional":true,"activities":[{"id":"515605","href":"/paths/18/course_templates/327/video/515605","isLocked":false,"duration":455000,"title":"Using native derived tables","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522776","prompt":null,"isOptional":true,"activities":[{"id":"515606","href":"/paths/18/course_templates/327/video/515606","isLocked":false,"duration":217000,"title":"Native derived table parameters","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522777","prompt":null,"isOptional":true,"activities":[{"id":"515607","href":"/paths/18/course_templates/327/video/515607","isLocked":false,"duration":479000,"title":"Using persistent derived tables","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522778","prompt":null,"isOptional":false,"activities":[{"id":"515608","href":"/paths/18/course_templates/327/labs/515608","isLocked":false,"duration":3600000,"title":"Creating Derived Tables with LookML","description":"In this lab, you create SQL derived and native derived tables in LookML to define new tables that do not already exist in the underlying database. You also persist the derived tables, so they can be written back to the underlying database.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522779","prompt":null,"isOptional":true,"activities":[{"id":"515609","href":"/paths/18/course_templates/327/video/515609","isLocked":false,"duration":430000,"title":"Caching and datagroups","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522780","prompt":null,"isOptional":true,"activities":[{"id":"515610","href":"/paths/18/course_templates/327/video/515610","isLocked":false,"duration":322000,"title":"Implementing datagroups in Looker","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"522781","prompt":null,"isOptional":false,"activities":[{"id":"515611","href":"/paths/18/course_templates/327/quizzes/515611","isLocked":false,"duration":4200000,"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":"75528","title":"Course Resources","description":"

PDF links to all modules

","steps":[{"id":"522782","prompt":null,"isOptional":true,"activities":[{"id":"515612","href":"/paths/18/course_templates/327/documents/515612","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}]

06

Developing Data Models with LookML