CRM Analytics
CRM Analytics is Salesforce's enterprise analytics platform for building interactive dashboards, exploring large data sets, and embedding analytical insights directly into Sales Cloud and Service Cloud records.
Definition
CRM Analytics is Salesforce's enterprise analytics platform for building interactive dashboards, exploring large data sets, and embedding analytical insights directly into Sales Cloud and Service Cloud records. It is the product previously branded as Tableau CRM (and earlier as Einstein Analytics and Wave Analytics) before consolidating under the CRM Analytics name. The platform handles analytical workloads that exceed what standard Salesforce reports and dashboards can serve: tens of millions of rows, complex joins across data sources, statistical analyses, and embedded dashboards inside record pages.
CRM Analytics ingests data from Salesforce orgs, external databases, data lakes, and uploaded CSV files. The data lives in CRM Analytics datasets optimized for analytical queries. Users build lenses (visualizations), dashboards (collections of lenses), and explorations (ad-hoc analytical workflows). Each dashboard supports interactive filtering, drill-down, and bindings that link components together. Einstein Discovery layers on top to provide AutoML-driven predictive analytics. CRM Analytics is licensed separately from base Salesforce; many enterprise orgs use it alongside Salesforce's standard reporting for the analytical scenarios standard reports cannot handle.
How CRM Analytics handles enterprise-scale analytics
When standard reports fall short and CRM Analytics fits
Standard Salesforce reports cap at 50,000 rows for export and have limited cross-object joining. They work well for operational reporting (pipeline by stage, cases by owner) but struggle with analytical workloads. CRM Analytics handles tens of millions of rows, joins across Salesforce and external data sources, computes complex aggregations, and supports interactive exploration. The threshold is usually: standard reports for under 100,000 rows on single-object data, CRM Analytics for everything beyond.
Datasets, lenses, and dashboards
CRM Analytics organizes content in three layers. Datasets hold the ingested data in a columnar store optimized for analytical queries. Lenses are individual visualizations: a chart, table, or KPI. Dashboards combine multiple lenses with interactive filtering and navigation. Explorations are saved analytical workflows where users drilled into specific questions. Each lens references a dataset and a query; each dashboard layout combines lenses into a coherent narrative. The separation lets analytics teams reuse datasets across many dashboards.
Data ingestion via Connectors
Connectors ingest data from many sources. Salesforce Connector pulls from local org or remote orgs. Snowflake, Amazon Redshift, Google BigQuery, Microsoft Azure Synapse, and other warehouse connectors bring in analytical data. CSV uploads handle ad-hoc data. The Replication step runs on a schedule (hourly, daily, weekly) to refresh datasets. For real-time use cases, the External Direct Data connector queries the source live without ingestion, with some latency cost.
Dataflows and Recipes
Dataflows and Recipes are the data preparation layer. Dataflows are older JSON-defined ETL pipelines that transform source data into datasets. Recipes are the newer visual data preparation tool with a drag-and-drop interface for join, filter, aggregate, transform operations. Most new analytics work uses Recipes; existing Dataflows continue to run. Both are scheduled processes that refresh datasets on the cadence the analytical use case requires.
Embedding dashboards in Sales and Service Cloud
CRM Analytics dashboards embed inside Lightning record pages via the Embedded Dashboard component. An Opportunity record can show a pipeline-context dashboard alongside the standard fields. A Case record can show a customer-history dashboard. Bindings let the embedded dashboard receive context (the current record ID, the user, the page state) and filter accordingly. Embedded analytics is the differentiator versus standalone BI tools because the insights appear in the workflow where decisions happen.
Einstein Discovery integration
Einstein Discovery is CRM Analytics'' AutoML product. Point Discovery at a CRM Analytics dataset, pick the outcome to predict, and the platform builds and evaluates models automatically. Outputs include Prediction fields (the predicted value), Improvement insights (what to change to improve the outcome), and embedded predictions in Sales Cloud and Service Cloud screens. Discovery is the accessible alternative to building custom ML pipelines for Salesforce-specific predictions.
Tableau integration and the broader analytics strategy
Salesforce owns both CRM Analytics and Tableau (acquired in 2019). The two products coexist: Tableau for general-purpose enterprise BI across many data sources, CRM Analytics for Salesforce-native analytical and embedded use cases. Salesforce integration patterns include Tableau Cloud, Tableau Server, and Tableau dashboards embedded in Salesforce via Lightning components. The product strategy positions Tableau as the broader BI platform and CRM Analytics as the Salesforce-specific layer.
How to set up CRM Analytics
Setting up CRM Analytics is a multi-month exercise spanning data ingestion, modeling, dashboard design, and rollout. Plan with an experienced analytics architect; the depth and complexity exceeds what casual Salesforce admins can handle alone. Start with one focused use case before expanding to enterprise analytics.
- Identify analytical use cases and audience
List the analytical questions that standard reports cannot answer well. Sales productivity across many years, multi-org pipeline rollup, service operations metrics, finance close-cycle analysis. Each use case drives data source and dashboard design.
- Provision CRM Analytics and configure connectors
Setup > CRM Analytics > Setup. Enable the product. Configure connectors to Salesforce orgs and external data sources. Plan ingestion schedules based on data freshness needs.
- Build data preparation Recipes
Open Analytics Studio > Data Manager > Recipes > New. Use the visual editor to join, filter, aggregate, and transform source data into datasets. Schedule the recipe to run on the right cadence.
- Create datasets from the prepared data
Each Recipe produces one or more datasets. Datasets are the columnar stores that lenses query against. Review the schema, field types, and dimension/measure designations.
- Build lenses for individual visualizations
Analytics Studio > Lenses > New. Pick a dataset, define the query (group by, aggregate, filter), choose the visualization type. Save the lens for reuse across dashboards.
- Assemble dashboards from lenses
Dashboards > New. Drag lenses onto the canvas. Configure layouts, filters, and bindings between components. Bindings let one lens filter another based on user interaction.
- Embed dashboards in Sales/Service Cloud
Add the Embedded Dashboard Lightning component to record pages. Configure bindings so the dashboard receives the record context. Verify dashboard renders correctly in the embed.
- Configure sharing and roll out
CRM Analytics has its own sharing model. Share apps and dashboards with the right user populations. Train users on dashboard navigation, filtering, and drill-down. Monitor usage and iterate based on adoption.
Salesforce, Snowflake, Redshift, BigQuery, CSV, and other sources. Determines what data flows into CRM Analytics datasets.
Recipes are the modern visual data prep tool. Dataflows are the older JSON-driven alternative. Use Recipes for new work.
Embedded dashboards live in Lightning record pages. Standalone dashboards live in Analytics Studio. Most production deployments use both.
- CRM Analytics is licensed separately. Confirm licensing before designing solutions; consumption-based add-ons for Einstein Discovery and other features add cost.
- Dataset refresh schedules drive data freshness. Hourly refresh costs more compute than daily; pick based on actual use case latency needs.
- Embedded dashboards depend on bindings. Misconfigured bindings produce dashboards that show wrong or empty data when embedded in record pages.
- The query language (SAQL and SQL through Recipes) differs from SOQL. Salesforce admins moving to CRM Analytics need to learn the new query model.
- Migration from older Tableau CRM / Einstein Analytics terminology persists in documentation and community resources. Stay current with the unified CRM Analytics naming.
Trust & references
Cross-checked against the following references.
- CRM Analytics Product PageSalesforce
- CRM Analytics DocumentationSalesforce Help
- Data ManagerSalesforce Help
Straight from the source - Salesforce's reference material on CRM Analytics.
- RecipesSalesforce Help
- Build DashboardsSalesforce Help
- Einstein DiscoverySalesforce Help
About the Author
Dipojjal Chakrabarti is a B2C Solution Architect with 29 Salesforce certifications and over 13 years in the Salesforce ecosystem. He runs salesforcedictionary.com to help admins, developers, architects, and cert/interview candidates sharpen their fundamentals. More about Dipojjal.
Test your knowledge
Q1. How can CRM Analytics help improve sales performance?
Q2. Who benefits most from CRM Analytics in an organization?
Q3. What type of data does CRM Analytics typically work with?
Discussion
Loading discussion…