Salesforce Analytics-101 Real Exam Questions [October 2026 Update]

The 48% passing score is the most strategically consequential fact about the Analytics-101 exam – and most candidates underuse the advantage it provides. Standard certification exams require 65-75% to pass, demanding proficiency across the majority of content. Analytics-101 requires correctly answering only 20 of 40 questions, making it a breadth-of-awareness assessment rather than a mastery examination.

The two largest domains – Exploring and Analyzing Data at 37% and Sharing Insights at 25% – together represent approximately 25 questions. A candidate who answers every question in these two domains correctly achieves 62% – well above the 48% threshold – before answering a single question in the other two domains. This does not mean ignoring Connecting to Data or Tableau Concepts; it means preparation priority is clear: confirm the two largest domains are solidly covered first, then close the most significant gaps in the smaller domains.

Candidates who spread preparation time evenly across all four domains – spending as much time on the Tableau Concepts domain (6 questions) as on calculated fields and table calculations in the Exploring domain (15 questions) – are misallocating their most limited resource. The 48% threshold and the domain weights together create a deliberate preparation strategy that most generic study plans miss.

Exam Snapshot

Four Domain Weights

Domain 1: Understanding Tableau Concepts (15%)

Dimensions vs. measures: Dimensions are categorical fields (Region, Product Name, Order Date) – they appear in blue by default and are typically discrete. Measures are numeric fields that can be aggregated (Sales, Profit, Quantity) – they appear in green and are typically continuous.

Discrete vs. continuous: Discrete fields produce individual headers. Continuous fields produce an axis with a range. Date fields illustrate the difference: Year as discrete creates one column header per year; Year as continuous creates a date axis spanning the full range.

Aggregation and granularity: Tableau aggregates measures to the level of detail defined by the dimensions in the current view. Adding a dimension disaggregates the aggregate – a total Sales SUM becomes per-Category Sales when Category is added. Removing a dimension re-aggregates.

Level of Detail (LOD) expressions: FIXED, INCLUDE, and EXCLUDE compute aggregations at a different level of detail than the current view. The exam tests LOD expressions at the recognition and concept level – what each keyword controls – rather than requiring construction of complex formulas.

Domain 2: Connecting to and Preparing Data (23%)

Live connection vs. extract: Live connections query the data source directly on every interaction – always current, performance depends on the source. Extracts create a compressed local .hyper file – dramatically faster for most interactions, current as of the last refresh.

Joins vs. relationships vs. blending:

Joins combine tables at the row level into a flat result set before the view is built. Inner join returns only matching rows; left join returns all left rows with nulls where no right match exists. Can produce duplicate rows when tables have different granularities.

Relationships are Tableau’s modern approach – tables are queried separately at the appropriate granularity for the current view and combined in context. Avoids duplicate row problems. Preferred over joins for most multi-table data sources.

Data blending combines data from different source connections – sources that cannot be joined because they are in different databases or have no compatible join key. Uses a linking field to aggregate secondary source data to match the primary source’s level of detail.

Data preparation in the data source view: Pivoting from wide format to long format, splitting fields, hiding irrelevant fields, and renaming fields for display clarity.

Domain 3: Exploring and Analyzing Data (37%)

Chart types by analytical purpose: Bar chart – category comparison. Line chart – trend over time. Scatter plot – correlation between two numeric measures. Maps – filled maps for geographic area values, symbol maps for point-location values. The exam tests which chart type is most appropriate for a described analytical requirement.

Filters and context filters: Dimension filters include or exclude dimension members. Measure filters restrict rows by a measure’s value range. Context filters are the most precisely tested filter type: when a filter is added to Context, all other filters apply only after the context filter has restricted the data. Without context, a Top N filter across all data ignores other active filters – adding the restricting filter to Context makes the Top N calculate within the restricted subset.

Calculated fields:

Basic calculations: IF/THEN/ELSEIF/END for conditional logic, string functions (CONTAINS, LEFT, RIGHT, LEN), date functions (DATEADD, DATEDIFF, DATETRUNC), and aggregation functions (SUM, AVG, MIN, MAX, COUNT, COUNTD).

Table calculations: Operate on values already in the view after aggregation. Running Total accumulates values across a partition. Percent of Total expresses each value as a percentage of the total. Difference shows the change between consecutive values. The “Compute Using” setting controls the calculation’s direction and scope.

Groups, sets, and hierarchies: Groups manually combine dimension members into higher-level categories. Sets define dynamic or fixed subsets of dimension members – In Set (meeting the condition) vs. Out Set (not meeting it). Hierarchies define drill-down relationships, enabling users to expand and collapse levels of detail.

Domain 4: Sharing Insights (25%)

Dashboard layout: Tiled layout arranges views in a fixed grid. Floating layout allows views to be positioned anywhere and overlap. Device-specific layouts display the dashboard differently on Desktop, Tablet, and Phone.

Dashboard actions – the most tested Sharing topic:

Filter actions: Selecting a mark in one view filters data in other views in the same dashboard. Configurable to run on hover, click, or menu selection.

Highlight actions: Selecting a mark highlights related marks in other views without removing non-selected marks from view.

URL actions: Clicking a mark opens a URL in a browser – linking to external resources or drill-down reports.

Stories: A Tableau story sequences multiple sheets or dashboards into a narrative presentation – like an interactive slide deck where the slides are live Tableau views.

Publishing platforms: Tableau Server (on-premises) and Tableau Cloud (Salesforce-hosted) both allow workbooks to be published for web browser access. Generative AI features including Tableau Pulse are available only on Tableau Cloud – not on Tableau Server regardless of version. Tableau Public is the free public platform where all published content is visible to anyone on the internet.

5 Study Tips for Salesforce Analytics-101

• Prioritise the Exploring and Analyzing domain (37%) and Sharing Insights domain (25%) – together they provide enough questions to pass even with weaker performance in the other two domains.
• Study joins vs. relationships vs. blending as three distinct approaches with different use cases – this distinction is consistently tested in the Connecting and Preparing domain.
• Study context filters specifically – candidates who know filtering generally but have not studied context filters lose Top N filter questions consistently.
• Study dashboard actions (filter, highlight, URL) as three distinct types with different effects – filter actions change what data is shown; highlight actions change which marks are emphasised without removing others.
• Practice with Cert Empire’s Analytics-101 exam questions weighted proportionally – 37% Exploring and Analyzing, 25% Sharing Insights, 23% Connecting and Preparing, 15% Tableau Concepts.

Best Study Resources

• Cert Empire Analytics-101 exam questions PDF and practice simulator (2026 edition).
• Salesforce official Analytics-101 exam guide (Trailhead Academy – trailheadacademy.salesforce.com).
• Tableau Free Training Videos (tableau.com/learn/training) – official training covering all exam domain topics.
• Tableau Desktop free trial – 14 days of hands-on practice in the actual product.
• Salesforce Tableau documentation (help.tableau.com) – authoritative reference for all exam content.

Why Candidates Choose Cert Empire for Salesforce Analytics-101 Preparation

Free Practice Tests

Sample our Analytics-101 questions before purchasing. Test your Tableau Desktop knowledge across all four domains and identify which areas need focused preparation.

Regular Updates

Tableau releases new features with each version. Our Analytics-101 question bank is continuously reviewed and updated to stay aligned with current Tableau Desktop capabilities and the official exam objectives.

Free Exam Guides

Every purchase includes our free Analytics-101 exam guide explaining the 48% passing threshold strategy, all four domain weights with approximate question counts, and a study plan prioritising domain coverage proportionally.

PDF Exam Questions – Study Anywhere, Anytime

Download your Analytics-101 questions instantly after purchase. Study on any device or print the PDF for offline review. No login required. No expiry on the downloaded file.

24/7 Chat Support

Available around the clock for questions about your materials, your order, or specific Tableau Desktop concepts – including joins vs. relationships, context filters, and dashboard action types.

3 Months of Unlimited Access

Three full months of unlimited access to the Analytics-101 question bank and simulator. Retake domain-specific practice sessions as many times as needed to build confidence across all four domains before exam day.

Official Vendor Resources – Learn from the Source

Every solution in our Analytics-101 question bank links directly to the relevant official Tableau documentation at help.tableau.com or the official Tableau training resources – so you verify every answer at an authoritative source.

Deep Knowledge – Every Answer, Every Option, Fully Explained

Every Analytics-101 question includes a complete explanation covering not just why the correct chart type, filter type, or dashboard action is right, but precisely why each incorrect option fails – whether it is a join producing duplicate rows, a filter that ignores context, or a dashboard action that highlights rather than filters. Each explanation references the specific official Tableau documentation behind the answer.

Interactive Practice Simulator – Think Like the Exam

Our simulator presents Tableau scenario questions exactly as the real Analytics-101 exam does – describing an analytical requirement and testing which visualisation type, data combination approach, or sharing mechanism correctly addresses it. Per-question feedback walks through the full reasoning behind every correct and incorrect choice.

Backed by a Full Money-Back Guarantee

If our Analytics-101 exam questions do not help you pass, you receive a full refund – no questions asked, no conditions.

FAQ’s

What is the Salesforce Analytics-101 certification?

Analytics-101 is the Salesforce Certified Tableau Desktop Foundations exam. It validates foundational knowledge of Tableau Desktop – connecting to data, building visualisations, creating dashboards, and sharing insights. It is Tableau’s entry-level certification for individuals with at least three months of hands-on Tableau Desktop experience.

What is the passing score for Analytics-101?

The English version requires 48% – just 20 of 40 scored questions answered correctly. The Japanese version requires 55%. This is the lowest passing threshold of any Salesforce certification.

Does Analytics-101 include a free retake?

Yes. The $75 registration fee includes one free retake attempt, making it one of the most financially accessible Salesforce certifications.

How long is the Analytics-101 exam?

70 minutes for 40 scored questions – approximately 1 minute and 45 seconds per question. The generous timing allows careful reading without rushing.

What is the difference between a join and a relationship in Tableau?

Joins merge tables into a flat result set at the row level – they can produce duplicate rows across tables with different granularities. Relationships keep tables separate and query each at the appropriate granularity for the current view, avoiding the duplicate row problem. Relationships are preferred for most multi-table data sources.

What are dashboard actions in Tableau?

Dashboard actions create interactivity between views. Filter actions cause selections in one view to filter data in other views. Highlight actions cause selections to emphasise related marks without removing others. URL actions open a specified URL when a mark is selected.

What is a context filter and why does it matter?

A context filter restricts the data pool before other filters apply. Without one, a Top N filter calculates the top N across all data regardless of other active filters. Adding the restricting filter to Context makes the Top N calculate within the already-filtered subset – the correct behaviour for most Top N scenarios.

Is Analytics-101 a good first Tableau certification?

Yes – it is specifically designed as the entry point to the Tableau certification path. The low passing score, short duration, free retake, and accessible $75 fee make it ideal for Tableau users wanting their first official certification.

Related Certifications Worth Exploring

Candidates who earn the Analytics-101 and want to advance their Tableau credentials will find the TABLEAU TDA-C01 (Tableau Certified Data Analyst) exam questions page covers the next-level analytics credential focused on preparing, exploring, analyzing, and visualizing data in Tableau, making it a natural progression from foundational Tableau Desktop skills. For those working in data-heavy Salesforce implementations, the Salesforce Analytics-Admn-201 (Salesforce Certified Analytics Administrator) exam questions page covers CRM Analytics administration, including datasets, dashboards, data integration, security, governance, and platform management skills that complement Tableau analytics expertise.