Skip to main content
Log inGet a demo

The Definitive Guide to Tableau CRM

Learn how you can leverage Tableau CRM for data integration, predictive analytics, and cloud-based visualization.

Luke Kline.

Luke Kline

August 24, 2022

8 minutes

The Definitive Guide to Tableau CRM.
  • Datasets include data that is stored in a denormalized form and optimized for interactive exploration.
  • Lenses represent views into specific datasets and they’re quite similar to Salesforce reports.
  • Dashboards use the data from datasets or lenses to create a curated set of tables, charts, and metrics for visualization.
  • Apps function very similar to folders and they can store lenses, dashboards, and datasets in any combination.
  • These different collections make it really simple for you to share and grant access to your business teams so they make decisions that move the needle forward. However, if you don’t want to query your data directly in Salesforce, CRM Analytics also provides direct connections to CDPs (customer data platforms) and other data platforms like Snowflake and BigQuery so you can embed that data into your interactive dashboards without ever ingesting it into Salesforce through single sign-on.

    Embedded Analytics

    For embedded analytics, CRM Analytics provides Einstein Discovery. Einstein Discovery is a proprietary AI/ML offering that gives you the ability to proactively identify patterns and dependencies in your data. You can answer key questions about what, when, how, and why something happened so you can proactively make predictions, improvements, and compare differences.

    Einstein Discovery lets you generate predictive, descriptive, and prescriptive insights. You can even explore relationships between your chosen input variables and your chosen outcome variables to generate AI-driven insights.

    For example, you could calculate the likelihood of a deal closing by providing Einstein with both positive and negative attributes. Once you’ve provided this information Einstein can then analyze all of your current deals and calculate how likely it is for each of your opportunities to close. This same use case can be applied to basically any scenario that you define whether it’s numerical, binary, or even multiclass (e.g., multiple outcomes/results.)

    Once you’ve built this predictive model Einstein will make recommendations on how you can achieve your goal and also point out possible red flags. You can also apply Einstein Discovery at the individual record level to make even more real-time predictions and recommendations.

    How Is Tableau CRM Different from Salesforce Reporting?

    Basic Salesforce reporting is relatively limited and you have no ability to transform or model your data in the way that makes the most sense to your business. You also can’t merge other data sources together and you definitely can’t build predictive models to inform your decision-making. CRM Analytics enables you to combine and consolidate data from multiple different sources so you can generate actionable insights across your entire organization.

    Tableau CRM Pricing

    CRM Analytics is actually surprisingly expensive and pricing starts at $75 per month for each individual user and can get as high as $150 per user if you want to unblock all of the features just described. The base version only comes equipped with Einstein.

    Problems with Tableau CRM

    The entire premise of CRM Analytics is to perform analytics jobs within your Salesforce instance and remove the need to ever go to another platform. CRM Analytics was created solely to compete against the major cloud providers. The problem is, your data team doesn’t live in Salesforce, and Salesforce is not an analytics tool or true single source of truth.

    All of your data (including your Salesforce data) likely already lives in a data warehouse like Snowflake, BigQuery, or Databricks. After all, this is where your data engineers and analysts manipulate, transform, and model your data to define key metrics like ARR, LTV, MRR, churn rate, etc.

    The main value of CRM Analytics is that it enables you to combine data from multiple sources and calculate your core metrics within Salesforce. There’s no such thing as an “everything” platform though. Salesforce is a fantastic CRM (we use it internally), but it's not an analytics platform designed to store, manipulate, and query structured and unstructured data. Warehouses provide faster query speeds because they're built for this exact use case and this is not even taking into account the cost optimization.

    The question you have to ask yourself is: Should Salesforce be your source of truth? If you’re a data-driven organization the answer is absolutely no!

    Marketing - Salesforce vs. Warehouse.jpg

    With Salesforce you can’t take advantage of SQL or any other development language for that matter. You also can’t use transformation/modeling tools like dbt or modern development practices via Git. You can do everything that CRM Analytics offers and more in your data warehouse faster, more efficiently, and more accurately.

    If you want to enrich your Salesforce instance with other data sources, ultimately, you just need a way to sync the data models you defined in your warehouse to fields in Salesforce, rather than building and storing your models in Salesforce.

    Alternatives to Tableau CRM

    Reverse ETL is the easiest way to sync data from your warehouse to any downstream SaaS application (e.g., Salesforce). Reverse ETL tools like Hightouch run on top of your warehouse and query against it.

    With Hightouch you can leverage all of your existing data models, or write simple SQL. All you have to do is connect to your source and your destination.

    Hightouch Architecture.jpg

    From there, you map the columns in your model to the appropriate fields in your destination and schedule, when, how, and where you want your syncs to run.

    salesforce mapping ht.png

    There’s even a visual audience builder for your non-technical users (e.g., marketing teams and sales teams), giving you the ability to segment audiences using the parameters your data team has set in place.

    HT Audience.png

    With Reverse ETL, all of your core business logic is defined and stored in your warehouse. There’s no reason to create a separate source of truth in Salesforce. Create a free Hightouch workspace today and start syncing your data to Salesforce.

    More on the blog

    • What is Reverse ETL? The Definitive Guide .
  • Friends Don’t Let Friends Buy a CDP.
  • Snowflake

    Marketplace Partner of the Year

    Gartner

    Cool Vendor in Marketing Data & Analytics

    Fivetran

    Ecosystem Partner of the Year

    G2

    Best Estimated ROI

    Snowflake

    One to Watch for Activation & Measurement

    G2

    CDP Category Leader

    G2

    Easiest Setup & Fastest Implementation

    Activate your data in less than 5 minutes