Salesforce CRM Analytics Consultant Exam Tips (Winter '26): How to Pass

Quick Answer: What CRM Analytics Consultant Tests

• Dashboard design — Building lenses and dashboards with steps (query), widgets (charts, tables, numbers), filters, and bindings. Understanding the CRM Analytics dashboard designer, how steps connect to widgets, and how to use faceting for cross-filter interactions.
• Data integration and preparation — Dataflows for connecting Salesforce data to analytics datasets, Recipes for more visual data preparation, and the augment/append/join transformation types. Row-level security (predicates) for controlling which data users can see in dashboards.
• SAQL and Einstein Discovery — Reading and writing SAQL queries for calculated fields and custom step logic. Setting up Einstein Discovery models, understanding prediction scores and key influencer output, and writing back predictions to Salesforce records.

Highest-Weight Exam Sections

Scenario Strategy: How to Approach CRM Analytics Consultant Questions

Questions describe an analytics requirement and ask which dashboard component, dataflow transformation, security approach, or SAQL expression addresses it. Trace the question from the data requirement back to the CRM Analytics component that delivers it.

• For security questions: row-level security in CRM Analytics uses security predicates — SAQL conditions applied to every dataset query that restrict which rows a user can see. Predicates reference user attributes (user ID, role, profile). For dynamic security based on user hierarchy, use the row-level security dataset with a join in the predicate.
• For dataflow vs. recipe questions: Dataflows are JSON-configured ETL processes (more flexible, code-like configuration). Recipes are visually configured in a UI (more accessible for non-developers). For complex multi-dataset joins, Dataflows may be required; for standard preparation tasks, Recipes are preferred as best practice.
• For SAQL questions: read the question's output requirement first. SAQL group by determines the grain; foreach determines which measures to compute; order by and limit control the result set. When a step needs a calculated field (e.g., win rate = closed won / total), it requires a custom SAQL step — not a standard step type.

Mock-Test Benchmark Before Booking

75%+ on 3 timed full mocks before booking

Build at least 3 complete CRM Analytics dashboards with dataflows, row-level security, and custom SAQL steps before booking. The SAQL and security predicate questions are very difficult to answer correctly without hands-on experience — theoretical study alone is insufficient.

Frequently Asked Questions

What is the Salesforce CRM Analytics Consultant exam format?

The CRM Analytics and Einstein Discovery Consultant exam has 60 multiple-choice questions, a 105-minute time limit, a 65% passing score, and a $200 fee ($100 retake). It tests implementation of CRM Analytics (formerly Tableau CRM / Einstein Analytics): dashboards, lenses, dataflows, recipes, SAQL queries, and Einstein Discovery predictive analytics.

What are the highest-weight CRM Analytics Consultant exam sections?

Building and Customising Dashboards (28%) and Data Integration (22%) together account for 50% of the exam. Creating dashboards with steps and widgets, writing SAQL queries for custom calculations, configuring dataflows and recipes to prepare data, and setting up row-level security are the most heavily tested areas.

What is SAQL and how important is it for this exam?

SAQL (Salesforce Analytics Query Language) is CRM Analytics' proprietary query language for dashboard steps. It is similar to SQL but has unique CRM Analytics syntax for groupby, order, limit, and custom calculations. The exam includes questions where you must read SAQL and identify what it returns, or identify the correct SAQL for a given data requirement.

What is Einstein Discovery and what does the exam test about it?

Einstein Discovery is CRM Analytics' automated machine learning feature that finds patterns in data and generates predictions and recommendations. The exam tests how to set up a story (now called a model), interpret key influencers, understand prediction scores, and embed Einstein Discovery predictions back into Salesforce records using writeback.

What concepts do most CRM Analytics candidates get wrong?

The most commonly misunderstood topics for the CRM Analytics exam are: (1) Dataflows vs Recipes — Two Different Data Preparation Tools; (2) XMD (Extended Metadata) — Formatting Is Not Stored in the Dataset; (3) SAQL vs Equals Filters — When to Use Each in Step Configuration. Candidates are most confidently wrong on these — learn the distinctions early to avoid losing marks on questions you expect to get right.

Why do most Crm Analytics candidates fail questions about Dataflows vs Recipes?

Dataflows are the legacy CRM Analytics data preparation tool that runs on a schedule and outputs datasets. Recipes are the newer drag-and-drop interface for transforming data into datasets. New implementations should use Recipes. Candidates use Dataflow JSON syntax for Recipes or vice versa. Know that Recipes replaced Dataflows for most use cases — Dataflows are still used for specific advanced...

Why do most Crm Analytics candidates fail questions about XMD (Extended Metadata)?

XMD controls display properties: field labels, formatting (currency, percent), colours, and display order in lenses and dashboards. It is separate from the dataset schema. Candidates modify dataset schemas to change display formatting — the exam expects XMD modifications for presentation changes. Changing a field's label in XMD does not change the underlying field name in SAQL.

Why do most Crm Analytics candidates fail questions about SAQL vs Equals Filters?

Equals Filters (the UI configuration) handle simple value comparisons in dashboard steps. SAQL (Salesforce Analytics Query Language) is needed for complex logic: date arithmetic, string manipulation, conditional aggregation. Candidates write SAQL for simple equality filters — the exam expects Equals Filters for those and SAQL only when the logic cannot be expressed in the UI filter interface.

Related Exam Tips