You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.

Go to chinese website
Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations

Blog post

Adding Tableau CRM to your Tableau Public visualization

By Adam Mico

Einstein Discovery Desktop and Server extensions allow you to interact with the model you developed in Tableau CRM. You can do so much with that model utilizing real-time interactions, model refreshes, and brilliant insights. However, users without a Tableau CRM license will not be able to interact with the visualization. In addition, the Einstein Discovery extension cannot be accessed in Tableau Public - this makes it challenging for our community to engage with the exciting new Tableau/Salesforce feature. Aside from the two visualizations shared on our Tableau Public page, I am unaware of any other examples of Tableau CRM in Tableau Public.

There is a way to get some of these features in Tableau Public. Unfortunately, it doesn’t contain all of the potential Tableau CRM with a Desktop/Server extension offers. Still, you can apply its AI potency with your data to answer your question and interact fluidly with the rest of your visualization.

Tools Needed:

  • A Tableau CRM Data Model (free sandbox version)

  • Tableau Prep (two weeks free every quarterly release)  

  • Tableau Desktop (two weeks free every quarterly release)

This article is intended for those that have or plan to learn how to develop a Tableau CRM model. (1)

Important: The model data from Tableau CRM and data in Tableau need to be consistent. Multiple data sources can be used in Tableau, but one should contain the fields in Tableau CRM to be appropriately linked. 

Tableau Prep

Once the model is deployed in Tableau CRM, linking to Tableau becomes possible.  The method shared here will not use any extensions on Tableau Desktop. However, Tableau Prep is necessary to access Tableau CRM and append it to the original data source. If you haven’t used Tableau Prep before, there is nothing to fear; since version 2021.1. Tableau makes it easy to bring in the data.

Data Source

Open Tableau Prep and access the data source which includes the Tableau CRM fields. Next, click the plus sign to the right of the step and select ‘Prediction.’ This piece engages Tableau CRM. Note: In this example, the data is already cleaned, so ‘Clean Step’ is unnecessary.

Prediction Step

Once accessed, you can begin working with the prediction step from Tableau CRM. Here are the points to complete the prediction step:

  1. Select ‘Prediction’ to highlight.

  2. Go to ‘Settings’ and make sure ‘Top Predictors’ and ‘Top Improvements’ are not checked. (2) 

  3. Make sure every field in Tableau CRM (Model Fields) has a corresponding field in Tableau ‘Flow Field.’ 

  4. When all three points are covered, you can select ‘Apply’ to complete the ‘Prediction’ step.

New Data Source

Output

Since we incorporated the Prediction Step, we can create a new data source in Tableau. 

  1. Select ‘Output’ to edit its settings.

  2. We want to create a file to use as a data source, so select ‘File.’

  3. Additional Settings to update:

    1. Add a name to the data source. In this case, it’s named ‘My New Data Source.’

    2. Select file location.

    3. Determine the file type. In this case, I am saving as a .csv.

    4. Select ‘Run Flow’ to save the file.

Adding Tableau CRM Data to Tableau Desktop

Now you can apply the data from Tableau CRM in Tableau! Again, we want to answer the primary question and interact with the ‘Prediction’ field using filters. Note: This tutorial doesn’t cover building a Tableau visualization but walks you through adding the Tableau CRM context in an existing viz with a new sheet.

To make the visualization resemble how the Einstein Discovery extension works in Tableau, I attached a copy of the worksheet below.

Beneath, I included the filters and sheet actions to work with the data, how I want it calculated, and showing the impacted rows.

The field will always default to ‘Prediction.’ In most cases, you will want to get an average of the measure because the data works with each row separately. In addition, you will want to access the count of rows or records impacted as it tells the user the number of items it’s basing its prediction. Once done, simply add the sheet to the dashboard like any other sheet.

For my visualization, I wanted to add a little more information to explain this resource to the user and use a floating object to show what the extension would look like and a show/hide button with the sharp Einstein logo.

Here is the interactive visualization applying Keyrus’ technique:

Extra credit

Share your enhanced visualization in social media and tag #Keyrus and Adam Mico. We would love to see what you come up with and develop with this sensational new feature!

Footnotes:

  1. For those who haven’t yet, but are interested, please check out these free Trailhead training paths: 

    1. Einstein Discovery Training

    2. Tableau CRM Training

  1. Note: ‘Top Predictors’ and ‘Top Improvements’ are helpful with the Einstein Discovery extension because it interacts with the model, but less effective if using as a static data source. In this use case, we want to interact with the primary question asked.

whatsapptwitter
linkedinfacebookworkplace
newsletter.svg

Never miss an insight

Stay updated on the latest articles, events, and more

Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.

Continue reading

Press release

Keyrus named amongst Top B2B Companies on Clutch

December 12, 2022

The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader. 

Webinar

PDF Parsing with Alteryx Intelligence Suite

December 1, 2022

In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.

Webinar

Modern Cloud Analytics in Action: Keyrus and Red Ventures

November 11, 2022

The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.

Event

Pharma/Biotech GTN Summit 2022

October 27, 2022

Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit

Press release

Keyrus Achieves AWS Data and Analytics Competency Status

October 6, 2022

Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.

Webinar

Live Webinar: Lessons on workforce capacity planning and optimization from Optum (UnitedHealthcare)

October 19, 2022

Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)

Webinar

Tableau Embedded Analytics: Optimizing insights from Salesforce data

September 20, 2022

Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.

Success story

How C&S Wholesale Grocers maximized ROI with an analytics center of excellence

September 7, 2022

C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.

Success story

Implementing a cloud security automation tool at a global consulting firm

September 2, 2022

Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.

Success story

Leveraging Salesforce to improve operations at Pajama Program

July 25, 2022

Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.

Logo - Keyrus
New York City

252 West 37th st., Suite 1400 New York, NY 10018

Phone:+1 646 664 4872

LinkedInInstagram
PlaybookServicesInsightsPartnersCareersAbout us
Company purposeInnovation & TechnologiesCommitted KeyrusRegulatory complianceInvestorsManagement teamBrandsLocations
Legal notice & Terms of use
Privacy policy
Data protection