Creating Dimensions and Measures with LookML

Overview
Looker is a modern data platform in Google Cloud that lets business users analyze and visualize data interactively. LookML developers curate the data used by business users by creating new fields, tables, and views to customize and organize data.

In Looker, each dimension defines a unique attribute of the data; for example, a customer dataset may have different dimensions for user cities and user ages. These dimensions are used to organize and describe the data within the dataset. Measures are aggregations, such as a count or an average, of the data in one or more dimensions. Measures allow calculations about key performance indicators (KPIs) and help business users analyze data using different aggregated attributes.

In this lab, you learn how to create different types of dimensions and measures in LookML as a Looker developer. You also learn how to modify how data is modeled in Explores, which are data views that serve as the foundation for self-service exploration by the business users in Looker.

For this lab, a project called qwiklabs-ecommerce has been created for you in LookML. This project is based on a mock ecommerce dataset containing information on orders, products, and users. As the LookML developer for this project, your goal is to create new dimensions and measures that will enable business users to easily identify and analyze attributes for customers associated with email as the traffic source, such as the breakdown of these users by number of days since signup and the total percentage of revenue attributed to these users.

You can learn more about LookML modeling in the Write LookML section of the Looker documentation.

Objectives
In this lab, you will practice creating dimensions and measures in LookML and learn about the different data types that LookML supports.
Modify an existing LookML project (qwiklabs-ecommerce) published by a Looker admin.
Create different types of dimensions and measures in LookML to address business users' questions.
Test your LookML changes in development mode.
Use the Explore interface to view the dimensions and measures that you have created in the modified LookML project.
Send LookML changes from a development branch to production.
#gcp #googlecloud #qwiklabs #learntoearn