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 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 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?
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 per day, on a rolling basis.
How should that metric be calculated?
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?
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?
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?
Two weeks into the third quarter, an analyst needs to determine the total order count per month for only the first two
How should the analyst filter the query?
A company has a Customer Lookup dashboard that can be filtered on a unique customer name. Business users sometimes
report unexpected data when they use filters with starts with or contains for the customer name.
How should the analyst ensure that the filter is unique to one customer?
A business analyst is building a report of predicted sales. The business analyst wants to filter the results to only show dates
in the next seven days. This filter should work whenever the results are generated.
Which filter expression should the business analyst use?
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?
An analyst creates a column chart showing the count of total orders and the count of returned orders on each date. The
number of returned orders is much smaller than the number of total orders, so the columns for the returned orders are short
and it is difficult to compare all the columns visually.
How should the analyst ensure that the differences between returned order counts for each day are more visible?
An analyst for a movie producer is making an Explore query to show total box office revenue by movie. The initial query has
Ticket Purchase Month
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 select all users in the query results but only wants to visualize results for users that have more than 100
Which visualization option should the analyst utilize?
An analyst needs to display data from two different sources together. There is a Look for each data source, but there is no
shared field that can be combined. Both Looks are saved in the Shared folder.
How should the analyst display the data from both sources?