Free Salesforce Analytics-Con-301 Exam Questions

A client has a sales dataset that contains fields named Customer ID, Region, Item, and Sales Amount. Each row represents a single sale. There may be multiple sales for each Customer ID. The client wants to visualize the average total customer sales by region. Which Level of Detail (LOD) expression should a consultant recommend?

A business analyst needs to create a view in Tableau Desktop that reports data from both Excel and MSSQL Server. Which two features should the business analyst use to create the view? Choose two.

A client has a sales dataset that contains fields named Customer ID, Region, Item, and Sales Amount. Each row represents a single sale. There may be multiple sales for each Customer ID. The client wants to visualize the average total customer sales by region. Which Level of Detail (LOD) expression should a consultant recommend?

A data analyst sets up a calculation to filter a dashboard so that it displays only the users' information. The dashboard will then be published to Tableau Cloud. The data analyst plans to use the following calculation to filter the data: USERNAME() = [Correct Answer] Which column in the table below should the data analyst reference in the calculation? 

A business analyst is creating a view of the top 10 customers for each region. The analyst has set a "Top 10" filter on Customer Name. However, it did not display the top 10 customers per region, as shown in the image below.Which type of filter should the business analyst add to filter for region?