Do you know that you can access more real exam questions via Premium Access? ()
Using the Sales Analysis Dashboard, create a filter action that will trigger once you select any state in Sales by State View, and it should update the Profit Vs Sales view. Find out using trend lines in the Profit Vs Sales view, how much does profit increase for each dollar of sales for the California state?
Answer : B
Go to the Dashboard menu -> Actions -> Add Action -> Filter
Configure the properties as:
Ensure that West Region should be selected in the Region filter.
The final view should be:
profit increase by 0.133134 for each dollar of sales for the California state
Using the Sales Analysis Dashboard, If you click on any of the products, it should navigate to the All Products worksheet. How you will accomplish it?
Answer : D
Go to Dashboard->Actions and create the go to sheet action
Connect to the "Kiva Loans - India" data source, find out which sector has the highest distribution of loan amount using interquartile ranges?
Answer : D
Create a box plot using Sector and Loan amount.
The IQR is maximum for the Wholesale sector.
Connect to the "Kiva Loans - India" data source, create a chart using the continuous disbursed month (Disbursed Time field) and sum of the loan amount, exclude the null values. What is the skewness of this chart?
Answer : A
Enable the Summary Card from Show/Hide menu as shown:
Skewness is .42
Connect to the "Global Superstore" data source and use the Orders table. Find out how many products from the Office Supplies category are in the Top 10 most profitable product list?
Answer : B
First, create a set using the Product Name. Select the Top condition as:
Drop this Set to the filters shelf and select IN only.
Drop this Set to the filters shelf and select IN only.
Drop the Category, Top 10 profitable products and Product Name to the view:
