Online Access Free Analytics-DA-201 Practice Test

A Data Analyst is subscribed to several views.
The analyst needs to unsubscribe from the views.
What should the analyst use?

• A.The Shared with Me page
• B.The Notifications area of Tableau Prep
• C.The Data Source page of Tableau Desktop
• D.The My Content area of Tableau Server / Cloud

A Data Analyst has the following dashboard.

Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.
The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.
What should the analyst do?

• A.Deselect Use as Filter from drop-down menu of Profits by State
• B.Select Deselect from the drop-down menu of Sales over time.
• C.Select Ignore Actions from the drop-down menu of Sales over time.
• D.Select Remove Dashboard Item from the drop-down menu of Sales over time.

You want to create the following table in a view.

Which function should you use to create the Position column?

• A.RANK
• B.INDKX
• C.LAST
• D.FIRST

In a worksheet, you have a calculated column named YTD Sales that uses the following formula.
[Order Date] <= TODAY () AND DATETBUNC {"year", [Order Dace]) = DATETPUNC)"year", TODAY(J) You want to create a calculated column named Exclude Current Month that will be dragged to the Filters shell. Exclude Current Month will exclude the current month values from YTD Sales.
How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

Correct Answer:

Explanation:

A colleague provides a Data Analyst with access to a folder that has the following files:
* Sales.csv
* Book1.json
* Sales.tds
* Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?

• A.Export.mdb
• B.Sales.tds
• C.Sales.csv
• D.Book1.json