Tableau Certified Data Analyst Practice Tests: 6 Practice Tests and 360 Questions
Tableau Data Analyst
360
Connect To and Transform Data | Live vs extract, relationships, joins, unions, blending, Data Interpreter, pivot and split, Tableau Prep flows and field properties (24%)
Explore and Analyze Data | Calculated fields, table calculations, filters, parameters, sets, bins and groups, maps, the Analytics pane and LOD expressions (41%)
Create Content | Charts, sorting, dashboards and stories, actions, dynamic zone visibility, formatting and device layouts (26%)
Publish and Manage Content on Tableau Server and Tableau Cloud | Publishing workbooks, data sources and flows, extract refreshes, alerts, subscriptions, custom views and permissions (9%)
Explore and Analyze Data
A view shows SUM(Sales) by Region. You need the average of each customer's total sales within each region, without adding Customer to the view. Which expression should you use?
AVG({ INCLUDE CustomerID : SUM(Sales) })
{ FIXED Region : AVG(Sales) }
AVG({ EXCLUDE CustomerID : SUM(Sales) })
WINDOW_AVG(SUM(Sales))
A
INCLUDE computes SUM(Sales) at Region plus Customer, then AVG averages those customer totals back up to each region in the view. FIXED Region with AVG(Sales) averages order lines rather than customer totals, EXCLUDE removes a dimension that is not in the view, and WINDOW_AVG averages the regions shown.
https://exametics.com/product/tableau-certified-data-analyst-practice-tests/
Course Content
Supporting Documents – Tableau Certified Data Analyst
You don't currently have access to this content
Tableau Certified Data Analyst – Practice Test #1
You don't currently have access to this content
Tableau Certified Data Analyst – Practice Test #2
You don't currently have access to this content
Tableau Certified Data Analyst – Practice Test #3
You don't currently have access to this content
Tableau Certified Data Analyst – Practice Test #4
You don't currently have access to this content
Tableau Certified Data Analyst – Practice Test #5
You don't currently have access to this content
Exam Mode: Tableau Certified Data Analyst – Practice Test #6
You don't currently have access to this content
