YoVDO

Developing Data Models with LookML - Locales

Offered By: Google via Google Cloud Skills Boost

Tags

Business Intelligence Courses SQL Courses Data Modeling Courses Data Management Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 Databases
Meta 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