Most Recent Salesforce Analytics-Con-301 Exam Dumps

The most user-friendly solution is to use Dynamic Zone Visibility in combination with a Show/Hide Button. This approach allows the dashboard to dynamically display only the relevant quick filters based on the viewer's selection of shops or warehouses, thus reducing clutter and focusing the user's attention on applicable filters. The Show/Hide Button further enhances the user experience by allowing viewers to toggle the visibility of the filter container, providing a clean and organized dashboard interface1.

The Explorer (can publish) site role in Tableau is designed for users who need to access, edit, and create visualizations based on published data sources, even when they are outside the company network. This role allows users to perform web editing and save their work, making it suitable for sales users who need these capabilities. It is also a cost-effective option as it does not require the full capabilities and associated costs of the Creator license.

The most efficient method for toggling between two views (forecast summaries and year-on-year metrics) while keeping main KPIs visible involves using a parameter and calculated fields for controlling visibility:

Create a Boolean Parameter: This parameter will have two aliases representing the two views ('Forecast View' and 'Year-on-Year View'). This allows the user to select which view they wish to see directly from the dashboard.

Calculated Field: Create a calculated field that always returns True. This field acts as a constant placeholder to enable the visibility control tied to the parameter.

Dashboard Setup: Place both the forecast summary and the year-on-year metrics sheets on the dashboard. Set the year-on-year metrics sheet as a floating object over the forecast summary.

Visibility Control: Use the 'Control visibility using value' option in the Layout tab for the floating year-on-year metrics view. Tie this setting to the Boolean parameter so that changing the parameter will show or hide this view without affecting the main KPIs displayed on the dashboard.

Interactivity: Implement a 'Change Parameter' dashboard action where selecting different options in the dashboard (e.g., clicking on certain parts) triggers the parameter to change, thus toggling the visible view.

Reference

This method leverages Tableau's dashboard interactivity features including parameters, calculated fields, and visibility settings, as recommended in Tableau's user guide on dynamic dashboard design.

To compute the required calculations and update the worksheet in Tableau Desktop, follow these steps:

Compute Average Sales by Segment for Each Category and Year:

Open the CC workbook and navigate to the Categorical Sales worksheet.

Drag the 'Sales' field to the Rows shelf if it's not already there.

Drag the 'Segment' field to the Rows shelf as well, placing it next to 'Category' and 'Year'.

Right-click on the 'Sales' field in the Rows shelf and select 'Quick Table Calculation' > 'Average'. This will compute the average sales for each segment within each category and year.

Create a Calculation for Year-over-Year Percentage Change:

Right-click in the data pane and select 'Create Calculated Field'.

Name the calculated field something descriptive, e.g., 'YoY Sales Change'.

Enter the formula to calculate the year-over-year percentage change:

(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))

Click 'OK' to save the calculated field.

Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab:

Remove the original 'Sales' measure from the view by dragging it off the Rows shelf.

Drag the newly created 'YoY Sales Change' calculated field to the Rows shelf where the 'Sales' field was originally.

Format the 'YoY Sales Change' field to display as a percentage. Right-click on the field in the Rows shelf, select 'Format', and adjust the number format to percentage.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.

Tableau Help: Offers guidance on creating calculated fields and using table calculations.

Tableau Desktop User Guide: Provides instructions on formatting and saving worksheets.

These steps allow you to manipulate data within Tableau effectively, using table calculations to analyze trends and changes in sales data by category and segment over years.

Topic 3, Knowledge-Based Section B

The calculation DATEPART('iso-weekday', [Order Date])=1 or DATEPART('iso-weekday', [Order Date])=7 is recommended because the ISO standard considers Monday as the first day of the week (1) and Sunday as the last day (7). This calculation will correctly identify Saturdays and Sundays regardless of the locale settings of the workbook's data source, ensuring that the report includes these days as specified by the client.

To accurately identify weekends across different locale settings, using the 'iso-weekday' component is reliable as it is consistent across various locales:

ISO Weekday Function: The ISO standard treats Monday as the first day of the week (1), which makes Sunday the seventh day (7). This standardization helps avoid discrepancies in weekday calculations that might arise due to locale-specific settings.

Identifying Weekends: The calculation checks if the 'iso-weekday' part of the date is either 1 (Sunday) or 7 (Saturday), thereby correctly identifying weekends regardless of the locale settings.

Handling Locale-Specific Settings: Using ISO standards in date functions allows for uniform results across systems with differing locale settings, essential for consistent reporting in global applications.