Salesforce Certified Tableau Consultant Analytics-Con-301 Exam Questions

Salesforce Certified Tableau Consultant Exam Objectives

1. 1

   1.0 Evaluate Current State (22%)

   • 1.1Map current state of analytics to future state
   • 1.2Map business needs to Tableau capabilities.
   • 1.3Translate analytical requirements into Tableau context by using best practices.
   • 1.4Recommend whether to use Tableau Server or Tableau Cloud, including migration.
   • 1.5Recommend and plan a Tableau Server upgrade.
   • 1.6Evaluate current data structures
   • 1.7Evaluate whether existing data supports business needs.
   • 1.8Evaluate lineage of existing data structures.
   • 1.9Evaluate existing data structures for performance risks and enhancement opportunities.
2. 2

   2.0 Plan and Prepare Data Connections (22%)

   • 2.1Plan for data transformation
   • 2.2Recommend an appropriate data transformation strategy.
   • 2.3Specify the requirements for minimum level of granularity.
   • 2.4Design a row-level security (RLS) data structure
   • 2.5Implement RLS and an entitlement table.
   • 2.6Identify group functions versus user functions.
   • 2.7Compare RLS approaches.
   • 2.8Plan and implement advanced connections to data
   • 2.9Recommend an appropriate method to connect to data, such as Web Data Connectors, web extract APIs, custom SQL, or ODBC.
   • 2.10Create connections by using Tableau Bridge.
   • 2.11Specify aggregation level and strategy for data sources in Tableau products (Tableau Desktop, Tableau Prep, Tableau Cloud, Tableau Server).
3. 3

   3.0 Design and Troubleshoot Calculations and Workbooks (40%)

   • 3.1Design analytics for advanced use cases
   • 3.2Recommend when to use an advanced chart type, such as Sankey, chord, radar, tile map, small multiples, and data densification.
   • 3.3Identify the effect of the Tableau order of operations on calculations.
   • 3.4Troubleshoot issues caused by the Tableau order of operations.
   • 3.5Plan and implement advanced techniques to build interactivity into dashboards, such as dynamic URL actions, parameter actions, and filter actions.
   • 3.6Design workbooks to optimize performance
   • 3.7Identify and resolve resource-intensive queries.
   • 3.8Maximize caching for Tableau Server.
   • 3.9Identify and resolve performance issues caused by calculations such as string comparisons, IF THEN statements, and Level of Detail (LOD) expressions.
   • 3.10Recommend calculations that should be moved upstream of Tableau.
   • 3.11Interpret and resolve issues by using performance recordings.
   • 3.12Identify and resolve performance issues caused by design elements such as number of sheets, number of filters, and image size.
   • 3.13Implement advanced calculations that include multiple steps
   • 3.14Implement aggregations that include dimensions.
   • 3.15Implement advanced table calculations, such as window, nested table, or multi-directional.
   • 3.16Implement advanced date functions, such as fiscal calendars.
   • 3.17Implement advanced LODs, such as nested LODs.
   • 3.18Implement combinations of advanced calculations.
   • 3.19Troubleshoot advanced calculations.
4. 4

   4.0 Establish Governance and Support Published Content (16%)

   • 4.1Recommend and apply a Tableau governance strategy
   • 4.2Map an organization's governance requirements to Tableau features and capabilities.
   • 4.3Recommend a strategy for securing access to content.
   • 4.4Recommend a strategy for ensuring data quality, including certifying data sources, minimizing data proliferation, and configuring data quality warnings.
   • 4.5Leverage administrative views
   • 4.6Specify insights that require an administrative view.
   • 4.7Recommend the appropriate administrative views and data sources for a given scenario.
   • 4.8Recommend a content distribution strategy
   • 4.9Map publishing requirements to features and capabilities of Tableau.
   • 4.10Recommend an approach for the workbook lifecycle, including building, testing, deployment, distribution, and maintenance.