Overview

Capstone Concept

• Looker contains the Looker Data Dictionary which is a powerful but often under-utilized tool, which "...provides a dedicated, centralized interface for searching through all Looker fields and descriptions"
• The idea of the capstone is to help automate the slow and time consuming process of writiing individual descriptions for the hundred to thousands of individual measures found within LookML files

Technical Details:

• The underlying data is from the NYC Citi Bike Trips Dataset
• The LookML is from the following public repository
• The model was given the following context:
  • "Write a Python regex to grab all examples of the text between the word "measure:" and the closing "}" character and add a description: "
• ~15 examples were used to train the model

Outputs: Compare Before/After

Examples of descriptions added

Avg. Trip Duration

Unique Bikes

Unique Bikes: Filtered

Trip Duration per Bike

Count

Output within the Data Dictionary

Count