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 Hostname  and  HTTP Path  of the Azure Databricks cluster. Authenticate t

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-click Category & Sub-Category on Rows, and then clear  Show Header . Note:  The c