Tableau CRM

Overview

Tableau CRM, a component of the Salesforce platform, provides an integrated analytics and business intelligence solution tailored for CRM data. Launched in 2014, it was initially known as Salesforce Analytics Cloud and later rebranded as Einstein Analytics before adopting its current name. The platform is designed to allow Salesforce users to analyze existing CRM data, uncover trends, and generate predictions without exporting data to external systems Salesforce CRM Analytics documentation.

The primary use cases for Tableau CRM include sales forecasting, pipeline analysis, customer service insights, and marketing campaign optimization. It integrates directly with Salesforce objects and data models, which allows for contextual analytics within sales, service, and marketing clouds. For example, sales teams can analyze pipeline health and identify at-risk opportunities, while service teams can predict case volumes or identify factors leading to customer churn. Marketing departments can use the platform to optimize campaign performance by analyzing customer segments and engagement metrics.

Tableau CRM is positioned for organizations that are already operating within the Salesforce ecosystem and require advanced analytical capabilities that leverage their existing CRM data. It includes capabilities such as data preparation, interactive dashboards, and AI-driven insights through Salesforce Einstein Discovery. Einstein Discovery applies machine learning to identify patterns and generate predictions from business data, offering explanations for those predictions and suggesting actions to improve outcomes Salesforce Einstein Discovery capabilities. The platform is designed for both business users who need to consume insights and data analysts who build and deploy analytical applications.

The platform's deep integration with Salesforce means that data governance and access control are managed within the Salesforce security model. This ensures that users only see data they are authorized to access, maintaining compliance with internal policies and external regulations like GDPR and HIPAA Salesforce compliance details. Developers familiar with the Salesforce environment can extend Tableau CRM's functionality using Apex, Lightning Web Components, and REST APIs, allowing for custom data integrations and specialized analytical applications.

Key features

• AI-Powered Insights (Einstein Discovery): Leverages machine learning to identify patterns, generate predictions, and provide prescriptive recommendations from business data.
• Interactive Dashboards: Provides customizable, interactive dashboards to visualize key performance indicators (KPIs) and explore data directly within the Salesforce interface.
• Data Preparation: Tools for cleaning, transforming, and integrating data from various sources within Salesforce and external systems.
• Predictive Analytics: Forecasts future trends and outcomes, such as sales revenue or customer churn, based on historical data.
• Mobile Access: Delivers analytics and insights to mobile devices, enabling on-the-go data exploration and decision-making.
• Natural Language Query (NLQ): Allows users to ask questions in plain language to retrieve data and insights without complex query building.
• Pre-built Templates: Offers industry-specific and role-specific templates for common analytical use cases in sales, service, and marketing.
• Data Governance and Security: Inherits Salesforce's robust security model, ensuring data access is controlled and compliant with regulations.

Pricing

Tableau CRM offers custom enterprise pricing, with specific tiers designed for different levels of functionality and scale. The primary offerings include CRM Analytics Growth and CRM Analytics Plus, along with specialized intelligence solutions for revenue and service.

Common integrations

• Salesforce Sales Cloud: Deep integration for analyzing sales pipeline, forecasting, and account performance Salesforce CRM Analytics integrations.
• Salesforce Service Cloud: Provides insights into customer service metrics, case resolution, and agent productivity Salesforce CRM Analytics integrations.
• Salesforce Marketing Cloud: Connects to marketing campaign data for performance analysis and optimization Salesforce CRM Analytics integrations.
• External Data Sources: Connects to various external databases, data warehouses, and cloud storage solutions via connectors and APIs.
• MuleSoft: Integrates with MuleSoft Anypoint Platform for connecting to a broader range of enterprise applications and data sources.

Alternatives

• Microsoft Power BI: A business intelligence service by Microsoft that provides interactive visualizations and business intelligence capabilities with an interface simple enough for end-users to create their own reports and dashboards.
• Looker (Google Cloud): A business intelligence platform acquired by Google, offering a unified platform for data analytics, embedded analytics, and data-driven workflows.
• Qlik Sense: A self-service data discovery and analytics platform that allows users to create flexible, interactive visualizations and dashboards.

Getting started

While Tableau CRM is primarily configured through a point-and-click interface within the Salesforce platform, developers can extend its capabilities using Apex, Lightning Web Components, and REST APIs. The following example illustrates how to query a Tableau CRM dataset using the Analytics REST API in Apex.

// Example: Querying a Tableau CRM Dataset via Apex REST API
public class CRMDashboardQuery {

    public static String queryDataset(String datasetName, String query) {
        String endpoint = URL.getSalesforceBaseUrl().toExternalForm() + '/services/data/v58.0/wave/query';
        HttpRequest req = new HttpRequest();
        req.setEndpoint(endpoint);
        req.setMethod('POST');
        req.setHeader('Content-Type', 'application/json');
        req.setBody(generateQueryBody(datasetName, query));

        Http http = new Http();
        HTTPResponse res = http.send(req);

        if (res.getStatusCode() == 200) {
            return res.getBody();
        } else {
            System.debug('Error querying dataset: ' + res.getStatusCode() + ' - ' + res.getBody());
            return null;
        }
    }

    private static String generateQueryBody(String datasetName, String query) {
        // This is a simplified example. Real queries can be complex SAQL or SOQL.
        // For detailed SAQL queries, refer to Salesforce Analytics Query Language (SAQL) documentation.
        // Example query might look like: 'q = load "0Fbxxxxxxxxxxxx"; q = group q by \'CloseDate_Year\'; q = foreach q generate \'CloseDate_Year\' as \'CloseDate_Year\', count() as \'count\';'
        
        String saqlQuery = 'q = load \"' + datasetName + '\"; q = group q by \"LeadSource\"; q = foreach q generate \"LeadSource\" as \"LeadSource\", count() as \"count\";';

        Map<String, Object> bodyMap = new Map<String, Object>{
            'query' => saqlQuery
        };

        return JSON.serialize(bodyMap);
    }

    // To execute this, you would call:
    // String result = CRMDashboardQuery.queryDataset('MyOpportunityDataset', 'SELECT LeadSource, COUNT(Id) FROM Opportunity GROUP BY LeadSource');
    // System.debug(result);
}

This Apex class demonstrates a basic interaction with the Tableau CRM (Wave) REST API to execute a SAQL (Salesforce Analytics Query Language) query. The queryDataset method constructs an HTTP POST request to the /services/data/vXX.0/wave/query endpoint, sending a SAQL query in the request body. The generateQueryBody method creates a simple SAQL query string. Developers would typically obtain the specific dataset ID and construct more complex SAQL queries based on their analytical requirements Salesforce Analytics REST API documentation. Authentication is handled automatically by the Salesforce platform when Apex is executed within a Salesforce context.