You have the following bar chart.You want the chart to appear as shown in the Mowing exhibit.What should you add?
Answer(s): B
A reference line is used in Tableau to display a line at a constant value or a computed value such as an average, median, minimum, or maximum in a bar chart. In this case, adding a reference line would allow you to show the median, upper quartile, and lower quartile, which corresponds to the changes shown in the bar chart.
DRAG DROP (Drag and Drop is not supported)You conned to a Microsoft SQL Server databaseYou need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returnedHow should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Answer(s): A
SelectWhereThe correct way to complete the query is:SELECT * FROM [dbo] . [Students]WHERE [Students].[City] = `Berlin'The SELECT statement is used to retrieve data from a table or a view. The * symbol means that all columns will be returned. The FROM clause specifies the table or view name and the schema name. The WHERE clause is used to filter the data based on a condition. The condition is [Students].[City] = `Berlin', which means that only rows where the City column of the Students table is equal to `Berlin' will be returned.The other options are not relevant for this query. CAST is a function that converts a value from one data type to another. JOIN is a clause that combines data from two or more tables based on a common field. ON is a keyword that specifies the join condition. UNION is a set operation that combines the results of two or more queries into one result set.
https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server- ver15 https://docs.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server- ver15 https://docs.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server- ver15#join https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union- transact-sql?view=sql-server-ver15
DRAG DROP (Drag and Drop is not supported)You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the futureWhich three actions should you perform m order?(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)
The correct order of the three actions is:Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf.Aggregate the date to month and year.From the Analytics pane, drag Forecast to the worksheet. The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default. The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month.The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card. The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.
https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/dates.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_statistical.htm#MODEL_QUANTILE
You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.You create several filters.From the Data Source page you plan to add data source fillers When type of filter will appear in the Edit Data Source Filters dialog box?
Answer(s): D
A data source filter is a filter that applies to all the worksheets that use the same data source. It filters the data before any other filters or calculations are applied. You can add a data source filter from the Data Source page by clicking on the Add button next to Filters. The type of filter that will appear in the Edit Data Source Filters dialog box is a dimension filter on all the sheets. This means that you can choose a dimension from your data source and filter it by values, range, condition, or top/bottom. The filter will affect all the worksheets that use that dimension. The other types of filters are not data source filters and will not appear in the Edit Data Source Filters dialog box. A table calculation filter is a filter that applies to a table calculation, such as percent of total or running total. A top N condition filter is a filter that shows only the top or bottom N values of a measure or dimension based on a condition. A context filter is a filter that creates a subset of data that other filters can use.
https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_tablecalculations.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm Data source filters in Tableau apply to the entire data source, affecting all sheets that use that data source. The Edit Data Source Filters dialog box allows you to add filters that operate at the data source level, which is different from context filters, top N filters, or table calculation filters that are applied at the worksheet level.
HOTSPOT (Drag and Drop is not supported)You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.
Sales: B. ColumnsProfit: D. RowsCustomer Name: C. Detail on the Marks cardCategory:A . Color on the Marks cardTo create the visualization, you need to drag Sales to Columns, Profit to Rows, Customer Name to Detail on the Marks card, and Category to Color on the Marks card. This will create a scatter plot that shows the relationship between Sales and Profit for each Customer Name, with different colors for each Category.
https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/buildexamples_scatter.htm
Post your Comments and Discuss Salesforce Certified Tableau Data Analyst exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the Certified Tableau Data Analyst content, but please register or login to continue.