Free Salesforce Analytics-Con-301 Exam Questions

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 client wants to use a bar chart to visualize the trend in profit per quarter for the last 5 years. They want each bar's color to be determined by whether the profit during that quarter was greater than the median profit for the past four quarters, including the current quarter. For example, if a bar represents profit for 2020 Q4, they want to visually see whether the profit for 2020 Q4 is greater than the median profit for 2020 Q1–2020 Q4. Which table calculation should produce the desired result?

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 client wants to use a bar chart to visualize the trend in profit per quarter for the last 5 years. They want each bar's color to be determined by whether the profit during that quarter was greater than the median profit for the past four quarters, including the current quarter. For example, if a bar represents profit for 2020 Q4, they want to visually see whether the profit for 2020 Q4 is greater than the median profit for 2020 Q1–2020 Q4. Which table calculation should produce the desired result?