Google Cloud Skills Boost

Applying Advanced LookML Concepts in Looker

6 hours Intermediate universal_currency_alt Free
In this quest, you will get hands-on experience applying advanced LookML concepts in Looker. You will learn how to use Liquid to customize and create dynamic dimensions and measures, create dynamic SQL derived tables and customized native derived tables, and use extends to modularize your LookML code.
Badge for Applying Advanced LookML Concepts in Looker

When you complete this activity, you can earn the badge displayed above! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have developed!

  • Lab

    Getting Started with Liquid to Customize the Looker User Experience

    In this lab you will use Liquid to customize dimensions and measure in Looker.

  • Lab

    Enhancing User Interactivity in Looker with Liquid

    In this lab you will use Liquid parameters and templated filters to enhance interactivity by users in Looker.

  • Lab

    Creating dynamic SQL derived tables with LookML and Liquid

    In this lab you will learn how to create and update SQL derived tables to generate dynamic values.

  • Lab

    Answering Complex Questions Using Native Derived Tables with LookML

    In this lab you will use native derived tables to answer complex questions with LookML.

  • Lab

    Modularizing LookML Code with Extends

    In this lab you will learn how to modularize LookML code with Extends.

  • info
    Quest Info
    Objectives
    • Learn how to use Liquid to customize dimensions and measures
    • Use Liquid parameters and templated filters to enhance user interactivity by creating dynamic dimensions and measures
    • Understand how business users leverage dynamic SQL derived tables to answer complex questions
    • Understand how business users leverage customized native derived tables to answer complex questions
    • Use extends to modularize and easily reuse LookML code
    Prerequisites
    Familiarity with LookML is necessary. We recommend completing the Understanding LookML in Looker quest before beginning.
    Available languages
    English
    What do I do when I finish this quest?
    After finishing this quest, you can explore additional content in your learning path or browse the learning catalog.
    What badges can I earn?
    Upon finishing a quest, you will earn a badge of completion. Some quests test your ability to apply your knowledge via a final assessment challenge lab. For these quests, you will receive a skill badge. Badges can be viewed on your profile and shared with your social network.