1.An "Orders" table has 30 columns, and the report only needs the order total by date. Which transformation should you perform?

Select an answer:

Filter the order amount field to not include blanks, and group by using the date column.

Remove the other columns. Group by using the date column and aggregate the appropriate total field.

Remove the other columns, and sort the date as descending.

Change the order total field data type, and remove the other columns.

2. A number field titled "ProductID" defaults to the SUM aggregate function. Which transformation can you apply so that it defaults to COUNT when used throughout other visuals?

Select an answer:

Change the data type to a fixed decimal point.

Convert the data type to String/Text.

Pivot the data by the ProductID field.

Change the data type to only count.

3.Your boss requests that you create a dashboard that includes a visual for your company's annual sales, with months by top 10 products. Which visualization would not be appropriate?

Select an answer:

bar chart

line chart

column chart

KPI

4.What can be customized to provide more insights into a visual when you hover over items?

Select an answer:

conditional formats

legends

tooltips

title