Multiple-choice Questions
- In Looker Studio, what color represents parameters?
a. Green b. Blue c. Purple d. Yellow
Answer: c
- What should you use to get user input for a parameter in Looker Studio?
a. Dropdown list b. Input box c. Checkbox d. Radio button
Answer: b
- How do you link a parameter to an input box?
a. Double-click the parameter b. Drag and drop the parameter onto the input box c. Click the parameter and press Enter d. Right-click the parameter and select "Link"
Answer: b
- To display the parameter value on a scorecard, you must:
a. Drag the parameter onto the scorecard b. Create a custom field using the parameter value c. Set the data type to a percentage d. Both b and c
Answer: d
True/False Questions
- Custom fields can be used for both calculations and visualizations in Looker Studio.
Answer: True
- Parameters can be directly displayed on scorecards without creating a custom field.
Answer: False
- Looker Studio allows users to input percentages directly for parameters.
Answer: False
Fill-in-the-Blanks
- When creating a parameter in the data source, you need to specify the _______, _______, _______, and _______.
Answer: name, ID, data type, range
- In Looker Studio, dimensions have a _______ background, metrics have a _______ background, and parameters have a _______ background.
Answer: green, blue, purple
Open-ended Question
- A marketing team wants to use Looker Studio to project their revenue based on various user input percentage increases. Describe how you would set up a parameter, gather user input, and create a custom field for calculating the projected revenue.
Example Answer:
To project revenue based on user input percentage increases, follow these steps:
- Create a parameter in the data source with a name, ID, data type (whole number or decimal), and range (e.g., from -100 to 100).
- Use an input box control to get user input for the parameter. Link the parameter to the input box by dragging and dropping it onto the control.
- Create a custom field called "Projected Revenue" that calculates the projected revenue based on the user input percentage increase. The formula would be
Revenue * (1 + (Percentage Increase / 100)), where "Percentage Increase" is the user input.
Once the custom field is set up, you can use it in your calculations and visualizations, such as displaying the projected