Salesforce Certified Tableau Data Analyst Analytics-DA-201 Exam Questions

Salesforce Certified Tableau Data Analyst Exam Objectives

1. 1

   1.0 Connect To and Transform Data (24%)

   • 1.1Connect to data sources
   • 1.2Identify data source
   • 1.3Determine live connection vs. extract
   • 1.4Connect to extracts
   • 1.5Connect to files
   • 1.6Connect to relational databases
   • 1.7Connect to published data sources from a Tableau Server or Tableau Cloud site
   • 1.8Replace the connected data source with another data source for an existing chart or sheet
   • 1.9Prepare data for analysis
   • 1.10Assess data quality (completeness, consistency, accuracy)
   • 1.11Perform cleaning operations
   • 1.12Organize data fields into folders
   • 1.13Use multiple data sources (establish relationships, create joins, union tables)
   • 1.14Prepare data by using Data Interpreter, pivot, and split
   • 1.15Create extract and data source filters
   • 1.16Perform data transformation in Tableau Prep
   • 1.17Choose which data transformation to perform based on a business scenario
   • 1.18Combine data by using unions
   • 1.19Combine data by using joins
   • 1.20Shape data by using aggregations
   • 1.21Perform filtering
   • 1.22Shape data by using pivots
   • 1.23Determine which output type to use
   • 1.24Customize fields
   • 1.25Change default field properties (types, sorting, etc.)
   • 1.26Rename columns
   • 1.27Choose when to convert between discrete and continuous
   • 1.28Choose when to convert between dimension and measure
   • 1.29Create aliases
2. 2

   2.0 Explore and Analyze Data (41%)

   • 2.1Create calculated fields
   • 2.2Write date calculations
   • 2.3Write string functions
   • 2.4Write logical and Boolean expressions
   • 2.5Write number functions
   • 2.6Write type conversion functions
   • 2.7Write aggregate functions
   • 2.8Write basic spatial calculations
   • 2.9Create table calculations
   • 2.10Moving average and window average
   • 2.11Percent of total
   • 2.12Running total
   • 2.13Difference and percent of difference
   • 2.14Percentile
   • 2.15Index
   • 2.16Ranking
   • 2.17Apply quick table calculations
   • 2.18Customize table calculations
   • 2.19Create and use filters
   • 2.20Apply filters to dimensions and measures
   • 2.21Configure filter settings including Top N, Bottom N, include, exclude, wildcard, and conditional
   • 2.22Add filters to context
   • 2.23Apply filters to multiple sheets and data sources
   • 2.24Create parameters to enable interactivity
   • 2.25In calculations
   • 2.26With filters
   • 2.27With reference lines
   • 2.28Set parameters to dynamically refresh
   • 2.29Structure the data
   • 2.30Sets
   • 2.31Bins
   • 2.32Hierarchies
   • 2.33Groups
   • 2.34Map data geographically
   • 2.35Create symbol maps
   • 2.36Create density maps
   • 2.37Create choropleth maps (filled maps)
   • 2.38Create mark layers
   • 2.39Summarize, model, and customize data by using the Analytics pane
   • 2.40Totals and subtotals
   • 2.41Reference lines
   • 2.42Reference bands
   • 2.43Average lines
   • 2.44Trend lines
   • 2.45Distribution bands
   • 2.46Forecast by using default settings
   • 2.47Customize a data forecasting model
   • 2.48Create Level of Detail (LOD) calculations
   • 2.49Write FIXED LOD calculations
   • 2.50Write INCLUDE LOD calculations
   • 2.51Write EXCLUDE LOD calculations
   • 2.52Write nested LOD calculations
3. 3

   3.0 Create Content (26%)

   • 3.1Create charts
   • 3.2Create basic charts from scratch (bar, line, pie, highlight table, scatter plot, histogram, tree map, bubbles, data tables, Gantt, box plots, area, dual axis, combo)
   • 3.3Sort data (including custom sort)
   • 3.4Create dashboards and stories
   • 3.5Combine sheets into a dashboard by using containers and layout options
   • 3.6Add objects (containers, images, text)
   • 3.7Create stories using story points
   • 3.8Add interactivity to dashboards
   • 3.9Use filter in a dashboard
   • 3.10Add filter, URL, and highlight actions
   • 3.11Create interactivity using dynamic zone visibility
   • 3.12Add navigation buttons
   • 3.13Create interactivity using set and parameter actions
   • 3.14Create show/hide buttons for dashboard objects
   • 3.15Format workbooks, worksheets, and dashboards
   • 3.16Apply color, font, shapes, styling
   • 3.17Add custom shapes and color palettes
   • 3.18Add annotations
   • 3.19Customize tooltips
   • 3.20Apply padding
   • 3.21Format gridlines, row-level and column-level bands, and shading
   • 3.22Create a responsive design for specific device layouts
4. 4

   4.0 Publish and Manage Content on Tableau Server and Tableau Cloud (9%)

   • 4.1Publish Content
   • 4.2Publish a workbook
   • 4.3Publish a data source from Desktop or Prep
   • 4.4Export content
   • 4.5Publish a flow
   • 4.6Schedule data updates
   • 4.7Schedule data extract refreshes
   • 4.8Manage published workbooks
   • 4.9Create alerts
   • 4.10Create subscriptions
   • 4.11Create and save custom views
   • 4.12Understand user roles and permissions
   • 4.13Customize and distribute a published workbook