Looker-Business-Analyst Sample Questions Answers

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 analyst needs to see all store data in Looker.

What should the analyst build to accommodate these requirements?

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?

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 Type dimension. Looking at the results, the Count of King rooms seems unusually low one week.

What should the analyst do to further investigate the low numbers?

Users find it difficult to distinguish the dashboards they need for tracking sales performance. There are more than 30 operation-related dashboards in the same folder.

What should the analyst do to improve the navigation experience?

An analyst for a movie producer is making an Explore query to show total box office revenue by movie. The initial query has three dimensions:

Ticket Purchase Month

Movie Name

Ticket Revenue

The analyst notices that the numbers look a lot smaller than expected and the results are difficult to understand.

What should the analyst do to make the Explore query show the desired metric?

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.)

The query below shows how many uses purchased an item from each of two clothing departments.

Why are the total and sum of the rows unequal?

An analyst at a banana quality assurance firm needs to compare performance week over week to make sure the firm stays on track. The analyst needs to show two metrics:

Number of bananas cleared for consumption the previous week

Number of bananas cleared for consumption the week before that

Which process should the analyst follow to show these two metrics in a report?

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?