Developing Data Models with LookML - Locales
Offered By: Google via Google Cloud Skills Boost
Course Description
Overview
This course, Developing Data Models with LookML - Locales, is intended for non-English learners only. To enroll in this content in English, please enroll in Developing Data Models with LookML. This course empowers you to develop scalable, performant LookML (Looker Modeling Language) models that provide your business users with the standardized, ready-to-use data that they need to answer their questions. Upon completing this course, you will be able to start building and maintaining LookML models to curate and manage data in your organization’s Looker instance.
Syllabus
- Introduction to the Course
- Course Introduction
- Module 0 Slides
- Introduction to Looker and LookML
- Module 1 Introduction
- Introduction to the Looker platform
- Understanding your users' experience
- LookML project hierarchy
- The Looker development environment
- Module 1 Summary
- Module 1 Quiz
- Module 1 Slides
- Modeling Dimensions and Measures
- Module 2 Introduction
- Modeling dimensions
- Example: Creating dimensions using LookML
- Modeling measures
- Example: Creating measures using LookML
- Advanced logic for dimensions and measures
- Lab Intro: Creating Dimensions and Measures with LookML
- Creating Dimensions and Measures with LookML
- Module 2 Summary
- Module 2 Quiz
- Module 2 Slides
- Project Version Control
- Module 3 Introduction
- Project version control with Git
- Example: Git workflow in Looker
- Module 3 Summary
- Module 3 Quiz
- Module 3 Slides
- Model Files
- Module 4 Introduction
- How Looker writes SQL
- Explores and join logic
- Symmetric aggregation
- Filtering Explores
- Module 4 Summary
- Module 4 Quiz
- Module 4 Slides
- Derived Tables
- Module 5 introduction
- Introduction to derived tables
- Types of derived tables
- Example: Creating SQL derived tables
- Example: Creating native derived tables
- Useful parameters for native derived tables
- Persistent derived tables
- Lab Intro: Creating Derived Tables with LookML
- Creating Derived Tables with LookML
- Module 5 Summary
- Module 5 Quiz
- Module 5 Slides
- Caching and Datagroups
- Module 6 Introduction
- Caching in Looker
- Example: Implementing datagroups in Looker
- Module 6 Summary
- Module 6 Quiz
- Module 6 Slides
- Course Summary
- Course Summary
- Module 7 Slides
Tags
Related Courses
Introduction to DatabasesMeta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX