Tableau Analytics

Connect Tableau and Azure Databricks: Tableau 2019.3 onwards Requirements Tableau 2019.3 (Desktop, Server, or Online) or above Simba ODBC Driver version 2.6.4 or above.  Download the supported Simba ODBC driver . If you aren’t running a supported driver, Tableau displays a message in the connection dialog with a link to the driver download page, where you can find driver links and installation instructions. Connect to Azure Databricks clusters Get the hostname and HTTP path of your Azure Databricks cluster. In Azure Databricks, click  Clusters  in the left menu and select the cluster from the list. On the cluster detail page, go to  Advanced Options  and click the  JDBC/ODBC  tab. It displays the hostname, port, protocol, and HTTP path. Launch Tableau, go to the  Connect > To a Server  menu, and select the  Databricks  connector. On the  Databricks  dialog, enter the  Server Hostnam...

Can I get a student discount for the Tableau Desktop Specialist Certification? We are currently offering a 20% discount on the Tableau Desktop Specialist Exam to students. We do not offer discounts on the other exams at this time. Please check out the  Certification site  for more information. The discount is automatically applied if you were successfully verified from SheerID when you applied for a student license. If the discount does not work, please feel free to reach out to  tft@tableau.com  for a discount code.  In the case of a discount error, please wait to purchase until Academic Programs has resolved the error, as retroactive discounts and refunds are not possible.

Contains (Like) operator in Tableau SInce there is no like operator in Tableau it provides CONTAINS operator.  Little different syntax is there but not too complex. Syntax for contains is:  Below is the example for using CONTAINS operator in a calculated field in Tableau. Ex: IF (CONTAINS([campaign_name],"Intent")) OR (CONTAINS([campaign_name_derived],"Intent")) THEN "Yes"   ELSE "No" END   Another Ex: IF (CONTAINS([Runresults],"Failed")) OR (CONTAINS([Runresults],"Missed")) THEN [Total Runs] ELSE 0 END ex2: IF (CONTAINS([Lead Unit],"ARV")) OR (CONTAINS([Lead Unit],"SARM")) OR (CONTAINS([Lead Unit],"LEX") OR (CONTAINS([Lead Unit],"TEX"))) THEN "SAX" ELSEIF (CONTAINS([Lead Unit],"AMTK")) OR (CONTAINS([Lead Unit],"AMK")) OR (CONTAINS([Lead Unit],"AMTK.L.CDTX") OR (CONTAINS([Lead Unit],"CDTX"))) THEN "AMK" ELSEIF  (C...

Un-merge row headers Tableau Option 1 Open Tableau Desktop and connect to Superstore sample data. Drag the Category and Sub-Category dimensions to the Rows shelf. Double-click Sales in the Measures pane. Ctrl-click Category and Sub-Category in Dimensions, right-click the highlighted fields, and then select  Create  >  Combined Field . Drag the combined Category & Sub-Category field to the far left on Rows. Right-click Category & Sub-Category on Rows, and then clear  Show Header . Option 2 Open Tableau Desktop and connect to Superstore sample data. Drag the Category and Sub-Category dimensions to the Rows shelf. Double-click Sales in the Measures pane. Click  Analysis  >  Create Calculated field...  Name the calculated field, enter the following formula and click  OK :  [Categories]+[Sub-categories] Drag the new calculated field to the far left on Rows. Right-clic...

Showing percentage for pre calculated fields in Tableau. In Tableau measures sometimes displays the percentage in four digits like 3343% instead of usual max 100%. This is because the field is already calculated in database and the value for the percent is available like 3, 4, 8 etc which needs a % sign beside them like 3%, 4%,5% etc. In order to do this the simple trick is that: Go to Tableau - > Right click on the measure Click on  Format  for the Measure..

Convert a Field to a Date Field Each database stores Date fields in slightly different ways. Tableau does its best in interpreting the date fields, but sometimes a field will be imported to Tableau as a text string or numerical field. If this happens, there are a few steps we can take to resolve the issue. Verifying Date Fields The date field might appear as a string when connecting to the Data Source... Or as a string in the Dimensions Pane. When dates are interpreted as strings, you will lose all of the features and conveniences of working with date fields, such as drilling down, using date calculations, and switching between Continuous and Discrete measures. If your dates aren't interpreted correctly, take the following steps in order: Change the data type of the field Create a calculation using the DATEPARSE function Create a calculation using the DATE function Change the data type of the field The first step in resolving a date field inter...

Horizontal Scroll Bar Missing When interacting with a text table that has multiple dimensions on either the Columns or Rows shelf, the horizontal scroll bar does not appear. Furthermore, the dimensions on either shelf are cut off. Resolution To help resolve this issue, follow the steps below. Place only the absolute necessary dimensions on the Rows or Columns shelf. Drag any remaining dimensions to  Detail  on the Marks Card. Cause Tableau shows a horizontal scroll bar for measures, but not for dimensions. When only dimensions are included on either the Columns or Rows shelf, the lower horizontal scroll bar will not display. Dimensions are treated as headers for measure aggregations and do not generate a horizontal scroll bar when they exceed the width of the view. Additional Info: As an alternative, you can drag dimensions to  Detail . When you drag dimensions to  Detail , they will appear in the marks' tooltip...