We may earn an affiliate commission when you visit our partners.

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.

This course is no longer available. Find something similar by browsing:

LookML Data Modeling Looker Derived Tables Data Caching

What's inside

Syllabus

Introduction to the Course

Introduction to Looker and LookML

Introducing Looker and LookML

Modeling Dimensions and Measures

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Provides foundational skills in LookML modeling, empowering learners to build and maintain data models in Looker instances

Empowers learners to curate and manage data within their organization's Looker instances

Teaches the foundations and essential concepts of LookML modeling for efficient and performant data management

Instructed by Google Cloud, recognized for their expertise in cloud computing and data management

Course materials are comprehensive, covering a wide range of topics and providing learners with a solid foundation in LookML modeling

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.

Save

Reviews summary

Practical lookml data model development

According to students, this course offers a strong foundation and practical understanding for developing LookML data models. Learners consistently highlight the instructor's exceptional clarity and the well-structured content, which effectively demystifies complex topics like derived tables and caching. The inclusion of hands-on labs is frequently cited as crucial for solidifying learning and applying concepts. While widely praised for its utility for beginners to intermediate professionals with some data experience, a few learners noted it could benefit from more advanced use cases or deeper dives for highly experienced practitioners.

Pacing and depth suit varied backgrounds, leading to mixed experiences.

"Good overview of LookML. For a beginner to LookML, it's a solid foundation. I wish there were more advanced use cases..."

"The course covers the basics but doesn't go very deep. It felt a bit slow at times if you already have some background."

"Found this course quite challenging to follow without prior Looker experience. Not recommended for complete novices."

"This course didn't meet my expectations... for an experienced analyst, it's a waste of time."

Content progresses smoothly from foundational to more advanced topics.

"The course content is well-structured, moving from basic concepts to more advanced topics smoothly."

"The material is well-organized, and the quizzes help check understanding."

"The modules on derived tables were a highlight. I think it serves its purpose well as an introductory to intermediate course."

Content is directly applicable to data professional roles, boosting confidence.

"This course has directly helped me in my data analyst role."

"This course significantly boosted my confidence in building robust LookML models. A must-take!"

"The practical examples were spot on. This course is an investment in your career."

"As a data engineer, I needed to get up to speed with LookML quickly, and this course delivered."

Effective hands-on labs reinforce learning and practical application.

"I especially appreciated the hands-on labs; they were crucial for solidifying my understanding."

"The hands-on exercises truly reinforce the learning."

"I found the section on version control particularly helpful... My main feedback would be to add more challenging practical exercises..."

"I liked the hands-on approach and the way the instructor broke down the syntax."

Instructor explains complex LookML concepts with great clarity.

"The instructor explains complex topics like derived tables and persistent derived tables (PDTs) with incredible clarity."

"The instructor's pacing is perfect, and I never felt rushed."

"The instructor is incredibly knowledgeable and articulates complex ideas clearly."

"The instructor's clarity is outstanding."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Developing Data Models with LookML with these activities:

Review Data Modeling Basics

Show steps

Strengthen your understanding of data modeling principles prior to working with LookML.

Browse courses on Data Modeling

Show steps

Review data models, including entities, attributes, and relationships
Practice identifying and normalizing data

Revisit Git Fundamentals

Show steps

Solidify or review your foundational Git skills and prepare for using Git with Looker.

Browse courses on Git

Show steps

Review core Git commands
Practice branching and merging

Follow LookML tutorials from the Looker documentation

Show steps

Learn from official Looker documentation and tutorials to supplement the course material.

Browse courses on LookML

Show steps

Identify relevant tutorials based on your learning goals
Follow the tutorials step-by-step and practice the exercises

Two other activities

Expand to see all activities and additional details

Show all five activities

Develop a LookML data model for a sample dataset

Show steps

Get hands-on practice creating and refining LookML models that you can apply to your own projects.

Browse courses on LookML

Show steps

Choose a sample dataset and define the scope of your model
Create a LookML model using the Looker IDE
Test and refine your model using Looker

Practice LookML coding challenges

Show steps

Sharpen your LookML skills by solving coding challenges that reinforce key concepts.

Browse courses on LookML

Show steps

Find online LookML coding challenges or create your own
Attempt to solve the challenges on your own
Review solutions and learn from your mistakes

Career center

Learners who complete Developing Data Models with LookML will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts help businesses make informed decisions by collecting, analyzing, and interpreting data. They use their knowledge of data modeling and analysis tools to identify trends, patterns, and insights that can help businesses improve their operations and make better decisions. This course can help Data Analysts develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts help businesses improve their performance by analyzing their business processes and identifying areas for improvement. They use their knowledge of data modeling and analysis tools to develop solutions that can help businesses improve their efficiency, effectiveness, and profitability. This course can help Business Analysts develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Business Analyst

Data Scientist

Data Scientists use their knowledge of data modeling and analysis tools to develop models that can predict future outcomes and identify opportunities for improvement. They use their skills to help businesses make better decisions, improve their operations, and develop new products and services. This course can help Data Scientists develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Data Scientist

Data Engineer

Data Engineers design and build the systems and processes that are used to collect, store, and analyze data. They use their knowledge of data modeling and analysis tools to develop solutions that can help businesses improve their data management capabilities and make better use of their data. This course can help Data Engineers develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Data Engineer

Software Engineer

Software Engineers design and develop software applications. They use their knowledge of programming languages and software development tools to create solutions that meet the needs of businesses and users. This course can help Software Engineers develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Software Engineer

Database Administrator

Database Administrators manage and maintain databases. They use their knowledge of database management systems and tools to ensure that databases are running smoothly and efficiently. This course can help Database Administrators develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Database Administrator

Project Manager

Project Managers plan and execute projects. They use their knowledge of project management methodologies and tools to ensure that projects are completed on time, within budget, and to the required quality standards. This course can help Project Managers develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Project Manager

Business Intelligence Analyst

Business Intelligence Analysts use their knowledge of data modeling and analysis tools to develop solutions that can help businesses improve their decision-making. They use their skills to identify trends, patterns, and insights that can help businesses improve their operations and make better decisions. This course can help Business Intelligence Analysts develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Business Intelligence Analyst

Data Visualization Specialist

Data Visualization Specialists use their knowledge of data visualization tools and techniques to create visual representations of data. They use their skills to help businesses communicate complex data in a clear and concise way. This course can help Data Visualization Specialists develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Data Visualization Specialist

Marketing Analyst

Marketing Analysts use their knowledge of data modeling and analysis tools to develop solutions that can help businesses improve their marketing campaigns. They use their skills to identify trends, patterns, and insights that can help businesses improve their marketing ROI and make better decisions. This course can help Marketing Analysts develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Marketing Analyst

Financial Analyst

Financial Analysts use their knowledge of data modeling and analysis tools to develop solutions that can help businesses improve their financial performance. They use their skills to identify trends, patterns, and insights that can help businesses make better investment decisions and improve their profitability. This course can help Financial Analysts develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Financial Analyst

Risk Analyst

Risk Analysts use their knowledge of data modeling and analysis tools to develop solutions that can help businesses identify and manage risks. They use their skills to identify trends, patterns, and insights that can help businesses make better decisions and improve their risk management strategies. This course can help Risk Analysts develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Risk Analyst

Compliance Analyst

Compliance Analysts use their knowledge of data modeling and analysis tools to develop solutions that can help businesses comply with regulations. They use their skills to identify trends, patterns, and insights that can help businesses make better decisions and improve their compliance posture. This course can help Compliance Analysts develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Compliance Analyst

Fraud Analyst

Fraud Analysts use their knowledge of data modeling and analysis tools to develop solutions that can help businesses detect and prevent fraud. They use their skills to identify trends, patterns, and insights that can help businesses make better decisions and improve their fraud management strategies. This course can help Fraud Analysts develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Fraud Analyst

Security Analyst

Security Analysts use their knowledge of data modeling and analysis tools to develop solutions that can help businesses protect their data and systems from threats. They use their skills to identify trends, patterns, and insights that can help businesses make better decisions and improve their security posture. This course can help Security Analysts develop the skills they need to build scalable, performant LookML models that provide business users with the standardized, ready-to-use data they need to answer their questions.

See salaries and explore the career path for Security Analyst

Reading list

We've selected eight books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Developing Data Models with LookML.