Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Tableau Certification Exam------------Tableau Certification Exam, Exams of Advanced Education

University of OxfordAdvanced Education

Tableau Certification Exam------------Tableau Certification Exam

Typology: Exams

2025/2026

Available from 02/24/2026

Toperthetop
Toperthetop 🇬🇧

3

(6)

27K documents

1 / 9

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Tableau Certification Exam
viewer license - correct answer users view and interact with workbooks in Tableau
Server - they can add comment to workbooks, explore visuals in various formats,
download workbook summary data, create subscriptions, and receive data-driven
alerts
explorer license - correct answer include all capabilities included with viewer license
BUT allows access to authoring capabilities using a web browser + full set of
collaboration features
creator license - correct answer wide range of capabilities within Tableau Server,
and grants use of Tableau Desktop and Tableau Prep Builder; can create and publish
new workbooks from a new data source, edit embedded data sources in the Data
pane, and create and publish new data connections
IT use cases - correct answer Hardware/software asset inventory, helpdesk call
volume/resolution time, resource allocation and security patch compliance
finance use cases - correct answer budget planning and spend, accounts payable,
travel expenses
marketing use cases - correct answer campaign engagement, web engagement,
leads
HR use cases - correct answer turnover rate, open headcount, new hire retention,
employee satisfaction
sales use cases - correct answer Sales/quota tracking, pipeline coverage, average
deal size, win/loss rate
data source v Tableau data source - correct answer - data source: database or excel
spreadsheet
pf3
pf4
pf5
pf8
pf9

Partial preview of the text

Download Tableau Certification Exam------------Tableau Certification Exam and more Exams Advanced Education in PDF only on Docsity!

Tableau Certification Exam

viewer license - correct answer users view and interact with workbooks in Tableau Server - they can add comment to workbooks, explore visuals in various formats, download workbook summary data, create subscriptions, and receive data-driven alerts explorer license - correct answer include all capabilities included with viewer license BUT allows access to authoring capabilities using a web browser + full set of collaboration features creator license - correct answer wide range of capabilities within Tableau Server, and grants use of Tableau Desktop and Tableau Prep Builder; can create and publish new workbooks from a new data source, edit embedded data sources in the Data pane, and create and publish new data connections IT use cases - correct answer Hardware/software asset inventory, helpdesk call volume/resolution time, resource allocation and security patch compliance finance use cases - correct answer budget planning and spend, accounts payable, travel expenses marketing use cases - correct answer campaign engagement, web engagement, leads HR use cases - correct answer turnover rate, open headcount, new hire retention, employee satisfaction sales use cases - correct answer Sales/quota tracking, pipeline coverage, average deal size, win/loss rate data source v Tableau data source - correct answer - data source: database or excel spreadsheet

  • Tableau data source: access to data and all the customization made in tableau published data sources allow for... - correct answer centralization and scaling of curated data sources data source considerations - correct answer - location and access
  • shape and cleanliness
  • data model / combining data
  • metadata and customization
  • scalability, security, and discoverability
  • performance and freshness methods of combining data - correct answer - relationships
  • joins
  • blends
  • unions relationships - correct answer default data combination method - establish potential for joins between 2 tables on related fields (does NOT merge data together to create new, fixed table), maintains appropriate level of detail, doesn't lose data, keeps appropriate aggregations, and handles nulls joins - correct answer merges multiple tables based on a join clause and join type, forming a new fixed table of data; can be used to add new columns of data across same basic row structure (may cause data loss or data duplication) blends - correct answer work across two or more separate Tableau data sources - data remains separate and Tableau queries that data sources independently and visualizes results together in the view (based on the linking fields established for that sheet) unions - correct answer merge two or more tables of data to form a new, fixed table of data - used to append data across the same basic column structure
  • packed bubble charts
  • line charts show deviation (how values differ from baseline) - correct answer - bullet charts
  • bar charts
  • combination charts show distribution (frequency of events within a population) - correct answer - histogram
  • population pyramid
  • pareto chart
  • box plots show ranking - correct answer - bar chart with rank calculation
  • top N sets
  • KPIs part to whole - correct answer - pie chart
  • area chart
  • stacked bar chart
  • treemaps spatial graphs - correct answer - filled maps
  • point distribution maps
  • symbol maps
  • density maps flow graphs (convey movement over time) - correct answer - flow maps
  • Sankey diagrams

when to use bar chart - correct answer - compare data across categories

  • highlight differences
  • show trends and outliers
  • reveal historical highs and lows at a glance when to use a line chart - correct answer - view trends in data (especially over time)
  • connects several distinct data points, presenting them as a continuous evolution
  • visualize changes in one value relative to another when to use a scatterplot - correct answer - investigate relationship between different variables - if one variable is a good predictor of another or not
  • can be enhanced with analytics like cluster analysis or trend lines when to use bubble chart - correct answer - to add detail to scatterplots or maps to show the relationship between three or more measures
  • visually compelling charts that present large volumes of data at once when to use a treemap - correct answer - relate different segments of data to the whole
  • efficient use of space + can show percent total for each category when to use a 100% stacked bar chart - correct answer - relative percentage of multiple data series + total of each stacked bar always = 100%
  • use when you want to see how proportions change over time candlestick charts - correct answer look similar to box-and-whisker plots, but are used for financial analysis to show metrics about a financial instrument over a period of time newspaper / Z-layout - correct answer most important content is either put at the top or the left of the dashboard

FINDNTH function - correct answer returns the position of the nth occurrence of substring within the specified string FIND function - correct answer searches for a specified string of text in a larger string of text and returns the position number where the specified text begins CONTAINS function - correct answer returns "true" if the given string contains the specified substring moving calculation - correct answer table calculation that determines the value for a mark in the view by performing an aggregation across a specified number of values before and/or after the current value (used to see long-term trends) percent from calculation - correct answer computes a value as a percentage of some other value - typically a percentage of the previous value in the table percent of total calculation - correct answer computes a value as a percentage of all values in the current partition percentile quick table calculation - correct answer computes a percentile rank for each value in a partition rank quick table calculation - correct answer computes a ranking for each value in a partition running total quick table calculation - correct answer aggregates values cumulatively in a partition fixed LOD expressions - correct answer compute a value using the specified dimensions, without reference to the dimensions in the view include LOD expressions - correct answer compute values using the specified dimensions in addition to whatever dimensions are in the view

exclude LOD expressions - correct answer declare dimensions to omit from the view level of detail - often used for 'percent of total' or 'difference from overall average' scebaruis why publish your dashboards? - correct answer - collaborate and share with others

  • centralize data and database driver management
  • support mobility what can you publish on Tableau? - correct answer - data sources: can contain a direct connection to your database OR an extract you can refresh on a schedule
  • workbooks: contain views, dashboards, stories, and data connections how do you change the chart type used in a view? - correct answer in the marks card, choose a different mark type in which of the following situations would a blend be the best way to combine data?
  • correct answer the data to combine is at different levels of detail the Product field has the format "ID-Name-Description." A product manager wants just one new column for the Description. Which of the following actions will get the desired results? - correct answer custom split the last 1 column of the Product field with "-" as a separator what chart type would be used to show the best fit line when investigating the correlation between 2 measures? - correct answer trend lines to present data using a clean, efficient dashboard design, an analyst creates a parameter control that she can use to swap out chart views, rather than squeezing them all into the dashboard. what formatting technique should she use to effectively hide unselected sheets? - correct answer insert a layout container for the swapped sheets Which quick table calculation calculates a percentage for the current value compared to the same period one year ago? - correct answer year over year growth