ANALYTICS-DA-201 Practice Questions

:

:

:

:

. Explanation: To add a distribution band on Profit to show the standard deviation from -1 to 1, you need to do the following steps: Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the SalesVSProfit worksheet. Click on the SalesVSProfit tab at the bottom of the workbook to open the worksheet. You will see a scatter plot that shows the relationship between Sales and Profit for each Sub-Category. Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet. Drag Distribution Band from the Analytics pane to Profit on the Rows shelf. This will add a distribution band on Profit that shows the average and confidence interval for each Sub-Category. Click on the Edit button on the distribution band to open the Edit Distribution Band dialog box. You will see options to customize your distribution band. Change the Band From value to -1 and the Band To value to 1. This will change the distribution band to show the standard deviation from -1 to 1, which means one standard deviation below and above the average. Click OK to apply the changes. You will see that the distribution band now shows a narrower range of values for Profit. Reference: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_distributionband.htm https://help.tableau.com/current/pro/desktop/en-us/analytics_distributionband_edit.htm

. Explanation: To create a filled map to show the distribution of total Sales by State across the United States, you need to do the following steps: Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source. Click on the Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks. Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map. Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales. Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map. Reference: https://help.tableau.com/current/pro/desktop/en-us/maps.htm https://help.tableau.com/current/pro/desktop/en-us/maps_howto_filled.htm https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_color.htm

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Salesforce_Analytics_DA_201/page_54_img_1.jpg

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Salesforce_Analytics_DA_201/page_66_img_2.jpg To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and [Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result. Reference: Finding the Month-to-Date Values for the Prior Year [DATEADD Function] [DATETRUNC Function]

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Salesforce_Analytics_DA_201/page_92_img_1.jpg There are different ways to prepare the data in Tableau Prep, but one possible answer is: Answer area: Join the tables. Aggregate the data by Sales Team. Add the following filter to the Employees table: Sale Team - Team Alpha. To analyze sales trends over time for every sales team, you need to combine the data from the Orders and Employees tables. You can do this by joining the tables on the Rep ID column, which is a common identifier for both tables. This will create a single table with all the columns from both tables. Next, you need to aggregate the data by Sales Team, which is the level of analysis you want. You can do this by grouping the data by the Sales Team column and applying an aggregation function (such as sum, average, count, etc.) to the other columns that you want to measure (such as Total Amount, Rep Tenure, etc.). This will create a summary table with one row for each sales team and the aggregated values for the other columns. Finally, you need to filter the data to focus on a specific sales team, such as Team Alpha. You can do this by adding a filter to the Employees table and selecting only the rows where Sales Team equals Team Alpha. This will remove the rows for other sales teams and keep only the data for Team Alpha. Reference: [Tableau Certified Data Analyst Exam Prep Guide], page 9, section “Preparing Data” [Tableau Help: Join Your Data] [Tableau Help: Aggregate Your Data] [Tableau Help: Filter Your Data]

https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Salesforce_Analytics_DA_201/page_107_img_1.jpg