Home

Home / Google / Looker Business Analyst

Question list

List of questions

Question 1

(0)

Two weeks into the third quarter, an analyst needs to determine the total order count per month for only the first two quarters. How should the analyst filter the query?

Question 2

(0)

An analyst needs to send a Look to an external client in CSV format. When the data is being downloaded, the Limit section has the option to select All Results grayed out, with text reading "All Resu

Question 3

(0)

An analyst adds a Day dimension and a Signup Count measure to an Explore to show the number of new users added per day. The analyst wants to add a metric that increases by the number of new users pe

Question 4

(0)

An analyst wants to schedule a dashboard in a way that makes it easier for viewing on a mobile device or for viewing a printout of the dashboard. How can the analyst set up a schedule to accomplish

Question 5

(0)

A business analyst is creating an Explore that shows the number of hotel rooms booked per week, by room type. The analyst is using a Week dimension and a Count measure, and is provisioning on a Room

Question 6

(0)

An analyst is trying to rank companies in an Explore and visualize the rank as a column chart. The analyst selects the Brand Name dimension and the Rank dimension. They then select the column chart

Question 7

(0)

An analyst has created a line chart with Value Labels enabled, but the values are too long and need to be abbreviated. Which visualization option should the analyst utilize to alter the display of

Question 8

(0)

An analyst needs to send a daily PDF to three different stores and wants it to contain five visualizations of KPI data. Each store's users must receive only the data filtered for that store. The ana

Question 9

(0)

An analyst has a dashboard with table visualizations that display the first few results, and the user can scroll down to see the remaining results. The analyst wants to download a PDF of the dashboa

Question 10

(0)

An executive needs to receive a dashboard every morning with data for the previous day only. The dashboard currently has a date filter defined. The executive must receive only the data requested, an

Open VPLUS File

Convert VPLUS to PDF

Related questions

An analyst needs to filter the sum of the sales between 12 complete months ago to the last 9 complete months ago. How can the analyst create this filter condition?

An analyst needs to send a Look to an external client in CSV format. When the data is being downloaded, the Limit section has the option to select All Results grayed out, with text reading "All Results Unavailable." What are three causes of this message? (Choose three.)

A business analyst is filtering for this year's data in an Explore. There is a requirement to show future dates for this year in the visualization, even though those dates do not yet have associated data. Where should the analyst go to make sure dates are filled in for the future?

An analyst creates a dashboard that shows sales at an aggregate and then an individual level. This dashboard is slow to run, and the analyst sees a warning about how load times may be impacted in dashboards with more than 25 tiles. What should the analyst create to make sure all data sources in this dashboard are connected but still load quickly?

An analyst creates a table visualization. There is one dimension, a few count type measures, and a percentage table calculation. When the analyst tries to download all 200,000 rows of results in CSV, the option is unavailable. The analyst has been provided permission to download all results. Which action should the analyst take to download all results?

An analyst has a dashboard with a single filter on Created Date "is in the past year", but a tile on the dashboard is returning results for only the past 7 days. When the analyst selects "Explore from Here" on the tile, there are filters on both Created Date "is in the past year" and Created Time "is in the past 7 days". How should the analyst make sure that only the filter set on the dashboard is applied to the tile?

An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit. How should the analyst, in addition to selecting the measure Total Sales build the report?

A company has an operational dashboard that needs to display the latest data every 5 minutes on a monitor. How should the analyst configure the dashboard?

The sales team has all its Looker content stored in a folder called Sales. Team members are complaining that the Looks and dashboards have been getting moved and edited in unwanted ways. Only the sales analyst should be editing the content in the Sales folder. Which access settings should be applied to the folder?

An executive needs to receive a dashboard every morning with data for the previous day only. The dashboard currently has a date filter defined. The executive must receive only the data requested, and the dashboard data needs to remain unchanged for all other users. What should the analyst do to meet this requirement?

Question 38 - Looker Business Analyst discussion

Report

An analyst needs to analyze the ecommerce quarter-over-quarter order growth. Two fields are given: Order Created Quarter and Order Count.

Which table calculation function should the analyst use to calculate the quarter-over-quarter order growth?

A.

pivot_offset()

B.

lookup()

C.

offset_list()

D.

offset()

Show Answer

asked 18/09/2024

MIGUEL PARADA VAZQUEZ

34 questions

User

Your answer: A B C D

0 comments

Sorted by

Leave a comment first