Looker for visualization in GCP - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a Looker dashboard with a title.

GCP

dashboard = looker.create_dashboard(title=[1])

Drag options to blanks, or click blank then click option'

A12345

BSales Overview

Cdashboard_title

D"Sales Overview"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting quotes around the title

Using a variable name instead of a string

The title must be a string enclosed in quotes.

2fill in blank

medium

Complete the code to add a Looker tile with a query ID.

GCP

tile = dashboard.add_tile(query_id=[1])

Drag options to blanks, or click blank then click option'

Aquery123

B"query123"

Ctile1

D123query

Attempts:

3 left

💡 Hint

Common Mistakes

Using unquoted query ID

Using an invalid ID format

The query ID must be a string, so it needs quotes.

3fill in blank

hard

Fix the error in setting the visualization type for a Looker tile.

GCP

tile.set_visualization_type([1])

Drag options to blanks, or click blank then click option'

A"bar_chart"

Bbar_chart

CBarChart

DbarChart

Attempts:

3 left

💡 Hint

Common Mistakes

Missing quotes

Using camelCase or PascalCase instead of snake_case

The visualization type must be a string with quotes and lowercase with underscores.

4fill in blank

hard

Fill both blanks to filter a Looker query for sales greater than 1000.

GCP

query.set_filter(field=[1], value=[2])

Drag options to blanks, or click blank then click option'

A"sales"

B1000

C"region"

D500

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong field name

Putting numbers in quotes

The field name must be "sales" as a string, and the value must be 1000 without quotes.

5fill in blank

hard

Fill all three blanks to create a Looker visualization with a title, type, and filter.

GCP

dashboard = looker.create_dashboard(title=[1])
tile = dashboard.add_tile(query_id=[2])
tile.set_visualization_type([3])

Drag options to blanks, or click blank then click option'

A"Monthly Sales"

B"query789"

C"line_chart"

D"query123"

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong query ID

Missing quotes

Wrong visualization type format

The dashboard title is a string, the query ID must match an existing query string, and the visualization type must be a string with the correct format.