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.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

What's inside

Syllabus

Introducing Looker and LookML

This module provides an overview of Looker and the Looker integrated development environment (IDE) for LookML developers.

Data Modeling using LookML

This module reviews how to model new dimensions and measures using LookML. The module also explores the use of dashboards to combine key queries and visualizations into a one page executive view

Modeling Explores for your Users

This module provides a deeper dive into the model files of LookML projects for developers to start designing and building custom Explores for business users.

Working with Derived Tables

This module explains how to use derived tables in Looker to create new custom tables that do not yet exist in the underlying database. This module also provides an overview of how caching works in Looker and how developers can use datagroups to manage caching policies.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Explores Looker, which is standard in the data visualization industry

Taught by Google Cloud Training, who are recognized for their work in cloud computing

Examines LookML, which is highly relevant to data modeling and visualization

Develops skills in building and maintaining LookML models, which are core skills for data analysts and engineers

Covers unique perspectives on data modeling and visualization, which may add color to other topics and subjects

Requires learners to come in with some prior knowledge of data analysis and data modeling concepts

Save this course

Save Developing Data Models with LookML to your list so you can find it easily later:

Save

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 your SQL skills

Show steps

SQL is a required skill for this course, so it is important to make sure that you are up to speed before the course begins.

Browse courses on SQL

Show steps

Take a SQL practice test
Review your SQL notes
Complete a few SQL practice exercises

Join a study group for this course

Show steps

Joining a study group will allow you to connect with other students in the course, share ideas, and get help with difficult concepts.

Show steps

Post a message on the course discussion board
Meet with the other students in your group
Discuss the course material and work on assignments together

Mentor a fellow student in this course

Show steps

Mentoring a fellow student will help you to solidify your understanding of the course material and will also give you the opportunity to help others.

Show steps

Identify a student who needs help
Meet with the student regularly
Provide the student with guidance and support

One other activity

Expand to see all activities and additional details

Show all four activities

Compile your notes, assignments, and quizzes

Show steps

Compiling your materials will help you to stay organized and will make it easier to review for the exam.

Show steps

Gather your notes, assignments, and quizzes
Organize the materials in a logical order
Store the materials in a safe place

Career center

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

Data Engineer

Data Engineers create and maintain the infrastructure and tools that enable Data Scientists and Data Analysts to perform their jobs effectively. The course you have chosen will provide you with a strong foundation in data modeling and help you develop the skills necessary to succeed in this role. Data Engineers must have a deep understanding of the technologies and techniques used to store, process, and manage data.

See salaries and explore the career path for Data Engineer

Data Architect

Data Architects collaborate with stakeholders across the organization to define data strategy, data governance, and data policies. The skills taught in this course will help you become a more effective Data Architect. With the rise in business intelligence software, Data Architects must be familiar with the latest tools and techniques for modeling data for analysis. This course will help provide you with a foundation in that regard.

See salaries and explore the career path for Data Architect

Data Analyst

A Data Analyst may collaborate with a Data Engineer to determine the best format and storage for data or even design the schema of data. The work done in this course will help you stand out from other candidates. You will learn the foundations of data modeling and how to optimize data storage, retrieval and analysis. This will be particularly helpful for an analyst who frequently uses Looker to analyze data for their organization.

See salaries and explore the career path for Data Analyst

Database Administrator

Database Administrators (DBAs) play a critical role in ensuring the smooth operation of an organization's databases. The skills you will learn in this course will help you become a more effective Database Administrator. DBAs are responsible for the design, implementation, and maintenance of database systems. This course will provide you with an understanding of database modeling, query optimization, and data security.

See salaries and explore the career path for Database Administrator

Business Intelligence Analyst

Business Intelligence Analysts use data to help businesses make better decisions. The course you have chosen is an excellent way to learn the fundamentals of data modeling and data analysis. This will give you a strong foundation for a career as a Business Intelligence Analyst. Business Intelligence Analysts must be able to understand and interpret data in order to identify trends and patterns.

See salaries and explore the career path for Business Intelligence Analyst

Data Scientist

Data Scientists are responsible for developing and deploying machine learning models. The course you have chosen is a great way to learn the fundamentals of data modeling and data analysis. This will give you a strong foundation for a career as a Data Scientist. Data Scientists must be able to understand and interpret data, and identify trends and patterns.

See salaries and explore the career path for Data Scientist

Product Manager

Product Managers are responsible for the development and launch of new products. The course you have chosen will help you learn the fundamentals of data modeling and data analysis. This will give you a strong foundation for a career as a Product Manager. Product Managers must be able to understand and interpret data in order to make decisions about product development and marketing.

See salaries and explore the career path for Product Manager

Project Manager

Project Managers are responsible for planning, organizing, and executing projects. The course you have chosen will help you learn the fundamentals of data modeling and data analysis. This will give you a strong foundation for a career as a Project Manager. Project Managers must be able to understand and interpret data in order to make decisions about project scope, schedule, and budget.

See salaries and explore the career path for Project Manager

Financial Analyst

Financial Analysts use data to help businesses make investment decisions. The course you have chosen will help you learn the fundamentals of data modeling and data analysis. This will give you a strong foundation for a career as a Financial Analyst. Financial Analysts must be able to understand and interpret data in order to make recommendations about investment opportunities.

See salaries and explore the career path for Financial Analyst

Quantitative Analyst

Quantitative Analysts use data to develop financial models. The course you have chosen will help you learn the fundamentals of data modeling and data analysis. This will give you a strong foundation for a career as a Quantitative Analyst. Quantitative Analysts must be able to understand and interpret data in order to develop accurate financial models.

See salaries and explore the career path for Quantitative Analyst

Software Engineer

Software Engineers design, develop, and maintain software applications. The course you have chosen may be useful as it provides a good foundation in data modeling. Software Engineers sometimes work on projects that involve data analysis and data modeling.

See salaries and explore the career path for Software Engineer

Web Developer

Web Developers design and develop websites and web applications. The course you have chosen may be useful as it provides a good foundation in data modeling. Web Developers sometimes work on projects that involve data analysis and data modeling.

See salaries and explore the career path for Web Developer

Data Visualization Engineer

Data Visualization Engineers create visual representations of data. The course you have chosen may be useful as it provides a good foundation in data modeling. Data Visualization Engineers must understand data in order to create accurate and informative visualizations.

See salaries and explore the career path for Data Visualization Engineer

Data Journalist

Data Journalists use data to tell stories. The course you have chosen may be useful as it provides a good foundation in data modeling. Data Journalists must understand data in order to communicate it effectively to the public.

See salaries and explore the career path for Data Journalist

Marketing Analyst

Marketing Analysts use data to help businesses understand their customers and market their products and services. The course you have chosen may be useful as it provides a good foundation in data modeling. Marketing Analysts must understand data in order to make informed decisions about marketing campaigns.

See salaries and explore the career path for Marketing Analyst

Reading list

We've selected 11 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.

The Kimball Group Reader

Save

Classic work on dimensional modeling. It provides a step-by-step guide to creating dimensional models that are optimized for business intelligence.

Developing Data Models with LookML

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses