{"id":28720,"date":"2026-06-07T04:50:41","date_gmt":"2026-06-07T04:50:41","guid":{"rendered":"https:\/\/www.cloudthat.com\/training\/?post_type=stm-courses&p=28720"},"modified":"2026-06-12T04:25:18","modified_gmt":"2026-06-12T04:25:18","slug":"developing-data-models-with-lookml-2","status":"publish","type":"stm-courses","link":"https:\/\/www.cloudthat.com\/training\/google-cloud-certification\/developing-data-models-with-lookml","title":{"rendered":"Developing Data Models with LookML"},"content":{"rendered":"

This instructor-led course empowers learners to develop scalable, maintainable, and performant data models using Looker\u00a0Modeling\u00a0Language (LookML). Participants will learn how to curate and manage enterprise data within Looker by building dimensions, measures, Explores, dashboards, and derived tables that support consistent business analytics.<\/span>\u00a0<\/span><\/p>\n

The course covers LookML fundamentals, Looker IDE workflows, Git-based version control, data modeling techniques, custom Explores, derived tables, caching strategies, and data group management. Learners will also explore how LookML transforms SQL into business-friendly analytics experiences for end users.<\/span>\u00a0<\/span><\/p>\n

Through demonstrations, quizzes, labs, and guided implementation exercises, participants will gain practical experience building and maintaining LookML projects for enterprise-grade business intelligence solutions.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

This instructor-led course empowers learners to develop scalable, maintainable, and performant data models using Looker\u00a0Modeling\u00a0Language (LookML). Participants will learn how to curate and manage enterprise data within Looker by building dimensions, measures, Explores, dashboards, and derived tables that support consistent business analytics.\u00a0 The course covers LookML fundamentals, Looker IDE workflows, Git-based version control, data modeling […]<\/p>\n","protected":false},"author":5091,"featured_media":12394,"template":"","meta":{"footnotes":""},"stm_lms_course_taxonomy":[58],"metadata":{"stm_lms_product_id":["28721"],"_edit_lock":["1781238197:6767"],"_edit_last":["6767"],"permalink_customizer":["google-cloud-certification\/developing-data-models-with-lookml"],"permalink_customizer_regenerate_status":["1"],"_thumbnail_id":["12394"],"popular_course":["0"],"_popular_course":["field_64253688bc2e5"],"banner_image":[""],"_banner_image":["field_621873548f922"],"banner_description":["Learn how to build scalable and performant LookML data models in Looker to create standardized, business-ready datasets, custom Explores, dashboards, and derived tables for enterprise analytics workflows. "],"_banner_description":["field_612c733ed3564"],"overview_section_heading":["Course Overview of Developing Data Models with LookML:"],"_overview_section_heading":["field_64538867ffdd0"],"after_completing_course_heading":["After completing Developing Data Models with LookML, participants will be able to: "],"_after_completing_course_heading":["field_645c78ade3f50"],"after_completing_course_0_desciption":["Define LookML terms, concepts, and building blocks"],"_after_completing_course_0_desciption":["field_6103ad2f9f5b2"],"after_completing_course_1_desciption":["Build dimensions and measures using LookML"],"_after_completing_course_1_desciption":["field_6103ad2f9f5b2"],"after_completing_course_2_desciption":[" Create and manage LookML projects using Looker IDE "],"_after_completing_course_2_desciption":["field_6103ad2f9f5b2"],"after_completing_course_3_desciption":["Understand Git integration and version control workflows in Looker"],"_after_completing_course_3_desciption":["field_6103ad2f9f5b2"],"after_completing_course_4_desciption":["Design and build custom Explores for business users"],"_after_completing_course_4_desciption":["field_6103ad2f9f5b2"],"after_completing_course_5_desciption":["Create and manage LookML dashboards"],"_after_completing_course_5_desciption":["field_6103ad2f9f5b2"],"after_completing_course_6_desciption":[" Use derived tables for advanced data modeling workflows"],"_after_completing_course_6_desciption":["field_6103ad2f9f5b2"],"after_completing_course_7_desciption":["Implement persistent derived tables and caching strategies"],"_after_completing_course_7_desciption":["field_6103ad2f9f5b2"],"after_completing_course_8_desciption":["Configure datagroups for optimized query performance"],"_after_completing_course_8_desciption":["field_6103ad2f9f5b2"],"after_completing_course_9_desciption":["Build scalable and maintainable enterprise data models in Looker"],"_after_completing_course_9_desciption":["field_6103ad2f9f5b2"],"after_completing_course":["10"],"_after_completing_course":["field_6103aae828228"],"key_features_heading":["Key Features of Developing Data Models with LookML "],"_key_features_heading":["field_645388ceffdd1"],"key_features_0_lists":["Enterprise Data Modeling with LookML"],"_key_features_0_lists":["field_6103ad559f5b3"],"key_features_1_lists":["Hands-On Learning Experience"],"_key_features_1_lists":["field_6103ad559f5b3"],"key_features_2_lists":["LookML Fundamentals and IDE Workflows"],"_key_features_2_lists":["field_6103ad559f5b3"],"key_features_3_lists":["Dimensions, Measures, and Dashboards"],"_key_features_3_lists":["field_6103ad559f5b3"],"key_features_4_lists":["Explore Modeling and User Experience"],"_key_features_4_lists":["field_6103ad559f5b3"],"key_features_5_lists":["Derived Tables and Advanced Modeling"],"_key_features_5_lists":["field_6103ad559f5b3"],"key_features_6_lists":["Performance Optimization and Caching"],"_key_features_6_lists":["field_6103ad559f5b3"],"key_features_7_lists":["Google Cloud Analytics Ecosystem Exposure"],"_key_features_7_lists":["field_6103ad559f5b3"],"key_features":["8"],"_key_features":["field_6103aaff28229"],"who_should_attend_heading":["Who should Attend Developing Data Models with LookML ?"],"_who_should_attend_heading":["field_645388faffdd2"],"who_should_attend_0_attend_lists":["Data Developers "],"_who_should_attend_0_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_1_attend_lists":["Analytics Engineers "],"_who_should_attend_1_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_2_attend_lists":["Data Analysts "],"_who_should_attend_2_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_3_attend_lists":["Business Intelligence Developers "],"_who_should_attend_3_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_4_attend_lists":["Cloud Analytics Professionals"],"_who_should_attend_4_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_5_attend_lists":["Looker Developers "],"_who_should_attend_5_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_6_attend_lists":[" Professionals responsible for enterprise analytics modeling "],"_who_should_attend_6_attend_lists":["field_6103adfb3f3e4"],"who_should_attend":["7"],"_who_should_attend":["field_6103ab0d2822a"],"prerequisites_heading":["Prerequisites of Developing Data Models with LookML "],"_prerequisites_heading":["field_64538a51ffdd3"],"prerequisites_text":["

  • Basic understanding of SQL \r\n
  • Familiarity with Git concepts \r\n
  • Understanding of the Looker business user experience \r\n
  • Recommended: Completion of \u201cAnalyzing and Visualizing Data in Looker\u201d \r\n
  • Interest in analytics engineering and data modeling workflows "],"_prerequisites_text":["field_612c7498c4b84"],"question_sets_details_heading":[""],"_question_sets_details_heading":["field_65d303841f38d"],"question_sets_details_description":[""],"_question_sets_details_description":["field_65d303841f38e"],"question_sets_details_button_text":[""],"_question_sets_details_button_text":["field_65d303841f38f"],"question_sets_details_question_sets":[""],"_question_sets_details_question_sets":["field_65d303841f390"],"question_sets_details":[""],"_question_sets_details":["field_65d303841f38c"],"category_features_heading":[""],"_category_features_heading":["field_644b8ff35049c"],"category_features_features":[""],"_category_features_features":["field_644b90025049d"],"category_features_cta_text":[""],"_category_features_cta_text":["field_644b90285049f"],"category_features_cta_link":[""],"_category_features_cta_link":["field_644b902d504a0"],"category_features":[""],"_category_features":["field_644b8fe15049b"],"course_features_0_heading":["Why choose CloudThat as your training partner for Developing Data Models with LookML?"],"_course_features_0_heading":["field_644a0fae0e67e"],"course_features_0_features_list_0_list":["Specialized Google Cloud Analytics Expertise<\/span><\/b> - <\/span>CloudThat\u00a0specializes in cloud and analytics technologies, delivering industry-focused Google Cloud and Looker training programs with practical enterprise implementation experience.<\/span>\u00a0<\/span>"],"_course_features_0_features_list_0_list":["field_644a0fc80e680"],"course_features_0_features_list_1_list":["Industry-Recognized Trainers<\/span><\/b> - <\/span>Our trainers are certified professionals with\u00a0expertise\u00a0in Looker,\u00a0LookML,\u00a0BigQuery, analytics engineering, and business intelligence solutions.<\/span>\u00a0<\/span>"],"_course_features_0_features_list_1_list":["field_644a0fc80e680"],"course_features_0_features_list_2_list":["Hands-On Learning Approach<\/span><\/b> - <\/span>CloudThat\u00a0emphasizes practical learning through guided labs,\u00a0LookML\u00a0implementation exercises,\u00a0modeling\u00a0workflows, and real-world analytics scenarios.<\/span>"],"_course_features_0_features_list_2_list":["field_644a0fc80e680"],"course_features_0_features_list_3_list":["Customized Learning Paths<\/span><\/b> - <\/span>Training programs are designed for data developers, analysts, analytics engineers, and cloud professionals with varying levels of analytics\u00a0expertise.<\/span>\u00a0<\/span>"],"_course_features_0_features_list_3_list":["field_644a0fc80e680"],"course_features_0_features_list_4_list":["Interactive and Practical Sessions<\/span><\/b> - <\/span>Sessions include demonstrations, collaborative activities, quizzes, implementation walkthroughs, and troubleshooting exercises.<\/span>\u00a0<\/span>"],"_course_features_0_features_list_4_list":["field_644a0fc80e680"],"course_features_0_features_list_5_list":["Career and Certification Support<\/span><\/b> - <\/span>CloudThat\u00a0supports learners with analytics project guidance, interview preparation, and practical business intelligence implementation strategies.<\/span>\u00a0<\/span>"],"_course_features_0_features_list_5_list":["field_644a0fc80e680"],"course_features_0_features_list_6_list":["Updated Industry-Relevant Content- <\/strong>Course content is continuously updated to align with the latest advancements in Looker, LookML, cloud analytics, and data modeling technologies."],"_course_features_0_features_list_6_list":["field_644a0fc80e680"],"course_features_0_features_list_7_list":["Trusted by Enterprises Worldwide<\/span><\/b> - <\/span>Thousands of professionals and organizations trust\u00a0CloudThat\u00a0for advanced cloud, analytics, data engineering, and business intelligence training programs.<\/span>"],"_course_features_0_features_list_7_list":["field_644a0fc80e680"],"course_features_0_features_list":["8"],"_course_features_0_features_list":["field_644a0fb70e67f"],"course_features_0_background_color":["a:1:{i:0;s:4:\"blue\";}"],"_course_features_0_background_color":["field_644a0fde0e681"],"course_features_1_heading":["Learning Objective of Developing Data Models with LookML"],"_course_features_1_heading":["field_644a0fae0e67e"],"course_features_1_features_list_0_list":["Understand\u00a0<\/span>LookML<\/span> architecture and development workflows<\/span><\/span>
    <\/span>"],"_course_features_1_features_list_0_list":["field_644a0fc80e680"],"course_features_1_features_list_1_list":["Build scalable dimensions, measures, and Explores<\/span><\/span>
    <\/span>"],"_course_features_1_features_list_1_list":["field_644a0fc80e680"],"course_features_1_features_list_2_list":["Create and manage\u00a0<\/span>LookML<\/span>\u00a0dashboards<\/span><\/span>"],"_course_features_1_features_list_2_list":["field_644a0fc80e680"],"course_features_1_features_list_3_list":["Utilize Git integration and version control workflows"],"_course_features_1_features_list_3_list":["field_644a0fc80e680"],"course_features_1_features_list_4_list":["Implement advanced derived table strategies"],"_course_features_1_features_list_4_list":["field_644a0fc80e680"],"course_features_1_features_list_5_list":["Configure caching and datagroups for performance optimization"],"_course_features_1_features_list_5_list":["field_644a0fc80e680"],"course_features_1_features_list_6_list":["Build reusable and maintainable enterprise data models"],"_course_features_1_features_list_6_list":["field_644a0fc80e680"],"course_features_1_features_list_7_list":["Improve analytics usability and business reporting workflows"],"_course_features_1_features_list_7_list":["field_644a0fc80e680"],"course_features_1_features_list_8_list":["Support enterprise analytics governance and consistency"],"_course_features_1_features_list_8_list":["field_644a0fc80e680"],"course_features_1_features_list_9_list":["Develop scalable business intelligence solutions using Looker"],"_course_features_1_features_list_9_list":["field_644a0fc80e680"],"course_features_1_features_list":["10"],"_course_features_1_features_list":["field_644a0fb70e67f"],"course_features_1_background_color":["a:1:{i:0;s:5:\"white\";}"],"_course_features_1_background_color":["field_644a0fde0e681"],"course_features":["2"],"_course_features":["field_644a0fa10e67d"],"certification_heading":["Certification Details of Developing Data Models with LookML "],"_certification_heading":["field_64538bffffdd5"],"certification_0_short_description":[""],"_certification_0_short_description":["field_6103ab2f2822c"],"certification_0_list_content":["CloudThat Course Completion Certificate "],"_certification_0_list_content":["field_6103ab4a2822d"],"certification_0_image":["28701"],"_certification_0_image":["field_6103ab5b2822e"],"certification":["1"],"_certification":["field_6103ab1a2822b"],"about_trainer":[""],"_about_trainer":["field_6103ab6c2822f"],"course_fee_heading":[""],"_course_fee_heading":["field_64538c1cffdd6"],"course_fee_list":[""],"_course_fee_list":["field_6103abb728234"],"brochure_pdf":[""],"_brochure_pdf":["field_61232e258f89b"],"trainer":[""],"_trainer":["field_6124990e13784"],"course_outline_heading":["Course Outline of Developing Data Models with LookML "],"_course_outline_heading":["field_64538a8effdd4"],"course_section_0_module_title":["Introducing Looker and LookML"],"_course_section_0_module_title":["field_612f5535940c3"],"course_section_0_module_description":[""],"_course_section_0_module_description":["field_612f564c921af"],"course_section_0_section_0_title":["Lecture Content "],"_course_section_0_section_0_title":["field_612f5233b0278"],"course_section_0_section_0_lesson_list_0_lession_title":["Looker and LookML"],"_course_section_0_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_1_lession_title":["The Looker User Interface"],"_course_section_0_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_2_lession_title":["The Looker IDE"],"_course_section_0_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_3_lession_title":["LookML Project Version Control "],"_course_section_0_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_4_lession_title":["Git Workflow in Looke"],"_course_section_0_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_5_lession_title":["How Looker Writes SQL "],"_course_section_0_section_0_lesson_list_5_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_6_lession_title":["LookML Development Lifecycle "],"_course_section_0_section_0_lesson_list_6_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_7_lession_title":["SQL and LookML Relationship "],"_course_section_0_section_0_lesson_list_7_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list":["8"],"_course_section_0_section_0_lesson_list":["field_612f530a0ac40"],"course_section_0_section_1_title":["Learning Objectives "],"_course_section_0_section_1_title":["field_612f5233b0278"],"course_section_0_section_1_lesson_list_0_lession_title":["Articulate the benefits of LookML for data modeling and analytics "],"_course_section_0_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_1_lession_title":["Identify the primary components of the Looker user interface"],"_course_section_0_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_2_lession_title":["Define LookML terminology and concepts"],"_course_section_0_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_3_lession_title":["Understand Git integration within Looker workflows "],"_course_section_0_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_4_lession_title":["Describe the LookML development lifecycle "],"_course_section_0_section_1_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_5_lession_title":["Explain how LookML generates SQL queries "],"_course_section_0_section_1_lesson_list_5_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list":["6"],"_course_section_0_section_1_lesson_list":["field_612f530a0ac40"],"course_section_0_section_2_title":["Activities "],"_course_section_0_section_2_title":["field_612f5233b0278"],"course_section_0_section_2_lesson_list_0_lession_title":["2 Demos"],"_course_section_0_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_2_lesson_list_1_lession_title":["1 Quiz"],"_course_section_0_section_2_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_2_lesson_list":["2"],"_course_section_0_section_2_lesson_list":["field_612f530a0ac40"],"course_section_0_section":["3"],"_course_section_0_section":["field_612f51e6b0277"],"course_section_1_module_title":["Data Modeling Using LookML"],"_course_section_1_module_title":["field_612f5535940c3"],"course_section_1_module_description":[""],"_course_section_1_module_description":["field_612f564c921af"],"course_section_1_section_0_title":["Lecture Content "],"_course_section_1_section_0_title":["field_612f5233b0278"],"course_section_1_section_0_lesson_list_0_lession_title":["Anatomy of a LookML Project"],"_course_section_1_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_1_lession_title":["Modeling Dimensions "],"_course_section_1_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_2_lession_title":["Creating Dimensions using LookML "],"_course_section_1_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_3_lession_title":["Modeling Measures"],"_course_section_1_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_4_lession_title":["Modeling Measures using LookML"],"_course_section_1_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_5_lession_title":["Dimension and Measure Modeling Logic "],"_course_section_1_section_0_lesson_list_5_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_6_lession_title":["LookML Dashboards "],"_course_section_1_section_0_lesson_list_6_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_7_lession_title":["Dashboard Development Workflows "],"_course_section_1_section_0_lesson_list_7_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list":["8"],"_course_section_1_section_0_lesson_list":["field_612f530a0ac40"],"course_section_1_section_1_title":["Learning Objectives "],"_course_section_1_section_1_title":["field_612f5233b0278"],"course_section_1_section_1_lesson_list_0_lession_title":["Detail the hierarchical layers within a LookML project "],"_course_section_1_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_1_lession_title":["Construct dimensions and measures with proper logic and calculations"],"_course_section_1_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_2_lession_title":[" Understand the relationship between IDE development and Explore usage"],"_course_section_1_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_3_lession_title":["Create and manage LookML dashboards "],"_course_section_1_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_4_lession_title":["Build enhanced analytics experiences for business users"],"_course_section_1_section_1_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list":["5"],"_course_section_1_section_1_lesson_list":["field_612f530a0ac40"],"course_section_1_section_2_title":["Lab Content "],"_course_section_1_section_2_title":["field_612f5233b0278"],"course_section_1_section_2_lesson_list_0_lession_title":["Lab: Creating Dimensions and Measures with LookML "],"_course_section_1_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_2_lesson_list":["1"],"_course_section_1_section_2_lesson_list":["field_612f530a0ac40"],"course_section_1_section_3_title":["Activities "],"_course_section_1_section_3_title":["field_612f5233b0278"],"course_section_1_section_3_lesson_list_0_lession_title":["2 Demos"],"_course_section_1_section_3_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_3_lesson_list_1_lession_title":["1 Quiz"],"_course_section_1_section_3_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_3_lesson_list_2_lession_title":["1 Lab"],"_course_section_1_section_3_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_3_lesson_list":["3"],"_course_section_1_section_3_lesson_list":["field_612f530a0ac40"],"course_section_1_section":["4"],"_course_section_1_section":["field_612f51e6b0277"],"course_section_2_module_title":["Modeling Explores for Your Users"],"_course_section_2_module_title":["field_612f5535940c3"],"course_section_2_module_description":[""],"_course_section_2_module_description":["field_612f564c921af"],"course_section_2_section_0_title":["Lecture Content "],"_course_section_2_section_0_title":["field_612f5233b0278"],"course_section_2_section_0_lesson_list_0_lession_title":["Modeling New Explores "],"_course_section_2_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_1_lession_title":["Using LookML to Filter Explores"],"_course_section_2_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_2_lession_title":["Understanding Symmetric Aggregation"],"_course_section_2_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_3_lession_title":["Designing User-Friendly Data Exploration Workflows "],"_course_section_2_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_4_lession_title":["Explore Optimization Concepts "],"_course_section_2_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list":["5"],"_course_section_2_section_0_lesson_list":["field_612f530a0ac40"],"course_section_2_section_1_title":["Learning Objectives "],"_course_section_2_section_1_title":["field_612f5233b0278"],"course_section_2_section_1_lesson_list_0_lession_title":["Create custom Explores and filters in Looker IDE"],"_course_section_2_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list_1_lession_title":["Connect Explore models to end-user analytics workflows"],"_course_section_2_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list_2_lession_title":["Understand symmetric aggregation concepts "],"_course_section_2_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list_3_lession_title":["Design scalable and user-friendly analytics experiences "],"_course_section_2_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list":["4"],"_course_section_2_section_1_lesson_list":["field_612f530a0ac40"],"course_section_2_section_2_title":["Activities "],"_course_section_2_section_2_title":["field_612f5233b0278"],"course_section_2_section_2_lesson_list_0_lession_title":["1 Quiz"],"_course_section_2_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_2_lesson_list":["1"],"_course_section_2_section_2_lesson_list":["field_612f530a0ac40"],"course_section_2_section":["3"],"_course_section_2_section":["field_612f51e6b0277"],"course_section_3_module_title":["Working with Derived Tables"],"_course_section_3_module_title":["field_612f5535940c3"],"course_section_3_module_description":[""],"_course_section_3_module_description":["field_612f564c921af"],"course_section_3_section_0_title":["Lecture Content "],"_course_section_3_section_0_title":["field_612f5233b0278"],"course_section_3_section_0_lesson_list_0_lession_title":["Introduction to Derived Tables "],"_course_section_3_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_1_lession_title":["Types of Derived Tables"],"_course_section_3_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_2_lession_title":["SQL Derived Tables "],"_course_section_3_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_3_lession_title":["Native Derived Tables "],"_course_section_3_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_4_lession_title":["Native Derived Table Parameters"],"_course_section_3_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_5_lession_title":["Persistent Derived Tables (PDTs)"],"_course_section_3_section_0_lesson_list_5_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_6_lession_title":["Caching and Datagroups "],"_course_section_3_section_0_lesson_list_6_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_7_lession_title":["Implementing Datagroups in Looker "],"_course_section_3_section_0_lesson_list_7_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_8_lession_title":["Query Optimization Strategies "],"_course_section_3_section_0_lesson_list_8_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list":["9"],"_course_section_3_section_0_lesson_list":["field_612f530a0ac40"],"course_section_3_section_1_title":["Learning Objectives "],"_course_section_3_section_1_title":["field_612f5233b0278"],"course_section_3_section_1_lesson_list_0_lession_title":["Understand SQL, native, and persistent derived tables "],"_course_section_3_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_1_lession_title":["Identify use cases for different derived table types "],"_course_section_3_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_2_lession_title":["Create derived tables within Looker workflows "],"_course_section_3_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_3_lession_title":["Configure caching and datagroups for performance optimization "],"_course_section_3_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_4_lession_title":["Evaluate the impact of caching on Looker performance and scalability "],"_course_section_3_section_1_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list":["5"],"_course_section_3_section_1_lesson_list":["field_612f530a0ac40"],"course_section_3_section_2_title":["Lab Content "],"_course_section_3_section_2_title":["field_612f5233b0278"],"course_section_3_section_2_lesson_list_0_lession_title":["Lab: Creating Derived Tables with LookML "],"_course_section_3_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_2_lesson_list":["1"],"_course_section_3_section_2_lesson_list":["field_612f530a0ac40"],"course_section_3_section_3_title":["Activities "],"_course_section_3_section_3_title":["field_612f5233b0278"],"course_section_3_section_3_lesson_list_0_lession_title":["2 Demos "],"_course_section_3_section_3_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_3_lesson_list_1_lession_title":["1 Quiz"],"_course_section_3_section_3_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_3_lesson_list_2_lession_title":["1 Lab"],"_course_section_3_section_3_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_3_lesson_list":["3"],"_course_section_3_section_3_lesson_list":["field_612f530a0ac40"],"course_section_3_section":["4"],"_course_section_3_section":["field_612f51e6b0277"],"course_section":["4"],"_course_section":["field_612f4f27b0276"],"note_section":[""],"_note_section":["field_616d3ed46bbd2"],"popular_sort":[""],"_popular_sort":["field_6172496402af3"],"related_courses":[""],"_related_courses":["field_61c453ca6b2dd"],"reviews_heading":[""],"_reviews_heading":["field_64538c39ffdd7"],"review_rating":[""],"_review_rating":["field_62a813a92bee6"],"total_review_count":["1986"],"_total_review_count":["field_62b002d8d2de5"],"average_review_count":["4.6"],"_average_review_count":["field_62b00367d2de6"],"faq_heading":["FAQs for Developing Data Models with LookML:"],"_faq_heading":["field_64538c59ffdd8"],"educational_schema":[""],"_educational_schema":["field_652fbbf6f589a"],"course_banner_image":[""],"_course_banner_image":["field_63c69a6b81cf1"],"mobile_banner_image":[""],"_mobile_banner_image":["field_63cf93896d207"],"banner_link":[""],"_banner_link":["field_63c69a9681cf2"],"curriculum":[""],"featured":[""],"views":["50"],"level":["intermediate"],"current_students":["0"],"duration_info":["1 Day"],"video_duration":[""],"status":[""],"status_dates":[""],"not_single_sale":[""],"price":["57950"],"sale_price":[""],"sale_price_dates":[""],"enterprise_price":[""],"not_membership":[""],"affiliate_course":[""],"affiliate_course_text":[""],"affiliate_course_link":[""],"expiration_course":[""],"end_time":[""],"drip_content":[""],"prerequisites":[""],"prerequisite_passing_level":[""],"announcement":[""],"faq":["[{\"question\":\"Who is this course for?\",\"answer\":\"This course is designed for data developers, analytics engineers, and analysts interested in building scalable LookML data models in Looker.\"},{\"question\":\"What topics are covered in this course?\",\"answer\":\"The course covers LookML fundamentals, dimensions, measures, Explores, dashboards, derived tables, Git workflows, caching, and datagroups. \"},{\"question\":\"Do I need prior experience with Looker?\",\"answer\":\"Basic familiarity with the Looker business user experience is recommended. \"},{\"question\":\"Is SQL knowledge required?\",\"answer\":\"Yes, a basic understanding of SQL is recommended.\"},{\"question\":\"What is the duration of the course?\",\"answer\":\"The course is available as: \\n\u2022 Instructor-Led Training (1 Day) \\n\u2022 On-Demand Training (Approx. 7 Hours) \"},{\"question\":\"Are hands-on labs included?\",\"answer\":\"Yes, the course includes practical labs, quizzes, and guided LookML implementation exercises. \"},{\"question\":\"What are derived tables in LookML?\",\"answer\":\"Derived tables are custom tables created within Looker using SQL or LookML logic to support advanced analytics workflows.\"},{\"question\":\"Does the course cover Git integration?\",\"answer\":\"Yes, learners will explore Git-based version control workflows within Looker IDE.\"},{\"question\":\"Will performance optimization be covered?\",\"answer\":\"Yes, the course includes caching, datagroups, and query optimization strategies. \"},{\"question\":\"Is this course suitable for intermediate learners?\",\"answer\":\"Yes, this is an intermediate-level course intended for professionals familiar with SQL, analytics, and basic Looker concepts. \"}]"],"course_files_pack":[""],"course_certificate":[""],"type":[""],"video_type":[""],"presto_player_idx":[""],"lesson_video":[""],"lesson_video_poster":[""],"lesson_video_width":[""],"lesson_shortcode":[""],"lesson_embed_ctx":[""],"lesson_youtube_url":[""],"lesson_stream_url":[""],"lesson_vimeo_url":[""],"lesson_ext_link_url":[""],"duration":[""],"preview":[""],"lesson_excerpt":[""],"lesson_files_pack":[""],"questions":[""],"quiz_style":[""],"duration_measure":[""],"correct_answer":[""],"passing_grade":[""],"re_take_cut":[""],"random_questions":[""],"answers":[""],"question_explanation":[""],"question_view_type":[""],"review_course":[""],"review_user":[""],"review_mark":[""],"order":[""],"absolute":[""],"sticky":[""],"sticky_threshold":[""],"sticky_threshold_color":[""],"stm_agenda":[""],"stm_host":[""],"stm_select_approved_denied":[""],"stm_multiselect_approved":[""],"stm_multiselect_denied":[""],"stm_date":[""],"stm_time":[""],"stm_timezone":[""],"stm_duration":[""],"stm_password":[""],"stm_waiting_room":[""],"stm_join_before_host":[""],"stm_host_join_start":[""],"stm_start_after_participants":[""],"stm_mute_participants":[""],"stm_enforce_login":[""],"stm_alternative_hosts":[""],"author_id":[""],"emails":[""],"wpdocs-meta-bdt":["57950"],"wpdocs-meta-gbp":["599"],"wpdocs-meta-rand":["13255"],"wpdocs-meta-aed":["2932"],"wpdocs-meta-usd":["799"],"offline_price":[""],"offline-bdt":[""],"offline-gbp":[""],"offline-rand":[""],"offline-aed":[""],"offline-usd":[""],"_yoast_wpseo_primary_stm_lms_course_taxonomy":["58"],"_yoast_wpseo_content_score":["90"],"_yoast_wpseo_estimated-reading-time-minutes":["1"]},"acf":[],"_links":{"self":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/28720"}],"collection":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses"}],"about":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/types\/stm-courses"}],"author":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/users\/5091"}],"version-history":[{"count":3,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/28720\/revisions"}],"predecessor-version":[{"id":29455,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/28720\/revisions\/29455"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media\/12394"}],"wp:attachment":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media?parent=28720"}],"wp:term":[{"taxonomy":"stm_lms_course_taxonomy","embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm_lms_course_taxonomy?post=28720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}