About this exam
Analytics-Con-301 is the Salesforce exam Salesforce Certified Tableau Consultant.
Paid practice material for this exam is not available yet, but you can try its free sample questions.
- Exam code
- Analytics-Con-301
- Vendor
- Salesforce
- Practice questions
- Not available yet
- Free sample questions
- 5
- Question bank last updated
- Not available yet
Try 2 sample questions
Taken from the free sample set for Analytics-Con-301.
Question 1
A client has many published data sourcesin Tableau Server. The data sources use the same databases
and tables. The client notices different departments
give different answersto the same business questions, and the departments cannot trust the data.
The client wantsto know what causes data sourcesto return
different data.
Which tool should the client use to identify this issue?
- AOption A:
Tableau Prep Conductor
- BOption B:
Ask Data
- COption C:
Tableau Catalog
- DOption D:
Tableau Resource Monitoring Tool
Show answer and explanation
Correct answer: C
The Tableau Catalog is part of the Tableau Data Management Add-on and is designed to help users
understand the data they are using within Tableau. It provides a comprehensive view of all the data
assets in Tableau Server or Tableau Online, including databases, tables, and fields. It can help identify
issues such as data quality, data lineage, and impact analysis. In this case, where different
departments are getting different answers to the same business questions, the Tableau Catalog can
be used to track down inconsistencies and ensure that everyone is working from the same, reliable
data source.
Reference: The recommendation for using Tableau Catalog is based on its features thatsupport data
discovery, quality, and governance, which are essential for resolving data inconsistencies across
different departments12.
When different departments report different answersto the same business questions using the same
databases and tables, the issue often lies in how data is being accessed and interpreted differently
across departments. Tableau Catalog, a part of Tableau Data Management, can be used to solve this
problem:
Visibility: Tableau Catalog gives visibility into the data used in Tableau, showing users where data
comes from, where it’s used, and who’s using it.
Consistency and Trust: It helps ensure consistency and trust in data by providing detailed metadata
management that can highlight discrepancies in data usage or interpretation.
Usage Metrics and Lineage: It offers toolsfor tracking usage metrics and understanding data lineage,
which can help in identifying why different departments might see different results from the same
underlying data.
Reference:
Tableau Catalog Usage: The Catalog is instrumental in providing a detailed view of the data
environment, allowing organizationsto audit, track, and understand data discrepancies across
different users and departments.
Question 2
A stakeholder has multiple files saved (CSV/Tables) in a single location. A few filesfrom the location
are required for analysis. Data transformation (calculations)
is required for the files before designing the visuals. The files have the following attributes:
. All files have the same schema.
. Multiple files have something in common among their file names.
. Each file has a unique key column.
Which data transformation strategy should the consultant use to deliver the best optimized result?
- AOption A:
Use join option to combine/merge all the files together before doing the data transformation
(calculations).
- BOption B:
Use wildcard Union option to combine/merge all the files together before doing the data transformation (calculations).
- COption C:
Apply the data transformation (calculations) in each require file and do the wildcard union to combine/merge before designing the visuals.
- DOption D:
Apply the data transformation (calculations) in each require file and do the join to combine/merge before designing the visuals.
Show answer and explanation
Correct answer: B
Moving calculations to the data layer and materializing them in the extract can significantly improve
the performance of reports in Tableau. The calculation ZN([Sales])*(1 - ZN([Discount])) is a basic
calculation that can be easily computed in advance and stored in the extract, speeding up future
queries. This type of calculation is less complex than table calculations or LOD expressions, which are
better suited for dynamic analysis and may not benefit as much from materialization12.
Reference: The answer is based on the best practices for creating efficient calculations in Tableau, as
described in Tableau’s official documentation, which suggests using basic and aggregate calculations
to improve performance1. Additionally, the process of materializing calculations in extracts is
detailed in Tableau’s resources2.
Given that all files share the same schema and have a common element in their file names, the
wildcard union is an optimal approach to combine these files before performing any transformations.
This strategy offers the following advantages:
Efficient Data Combination: Wildcard union allows multiple files with a common naming scheme to
be combined into a single dataset in Tableau, streamlining the data preparation process.
Uniform Schema Handling: Since all files share the same schema, wildcard union ensures that the
combined dataset maintains consistency in data structure, making further data manipulation more
straightforward.
Pre-Transformation Combination: Combining the files before applying transformations is generally
more efficient as it reduces redundancy in transformation logic across multiple files. This means
transformations are written and processed once on the unified dataset, rather than repeatedly for
each individual file.
Reference:
Wildcard Union in Tableau: This feature simplifies the process of combining multiple similar files into
a single Tableau data source, ensuring a seamless and efficient approach to data integration and
preparation.
See all 5 free sample questions