100% Free Analytics-Con-301 Practice Exam Questions (2026)

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 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 notices that while creating calculated fields, occasionally the new fields are created as strings,integers, or Booleans. The client asks a consultant ifthere is a performance difference among these three data types.What should the consultant tell the customer?

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.