Question: 1
Refer to the exhibit
A business analyst needs to present the actual sales of the current year in a KPI on a dashboard. The expression in the Text field is NOT working
Which two changes will correct the expression? (Select two )
Question: 2
A business analyst wants to display sales by country region, city and customers. All the dimensions needs to be shown. Which chart can display a hierarchy without a drill-down dimension?
Question: 3
A business analyst has data for these fields
• Year
• Sales Amount
• Product Number
• Country
• Order Number
How many dimensions and measures exist?
Question: 4
Refer to the exhibits.
A business analyst has an application showing sales performance. The analyst will enter an expression in the search box of a filter pane to show only Salesman who generate more than $200,000 in sales.
Which is the correct expression?
A =Sum(Sales) >200000
B =If(Sum(Sales)>200000, Salesman)
C =Firstname(Salesman=,Rob,, 'Tom', 'Helen', 'Rock', 'Leif')
D = If (WildMatch (Salesman, 'Rob*' , 'Tom'', 'Helen* ', 'Rock*' , 'Leif'' ) , Sales)
Answer : D
Show Answer
Hide Answer
Question: 5
A business analyst wants to display sales by country region, city and customers. All the dimensions needs to be shown. Which chart can display a hierarchy without a drill-down dimension?
