Category: Tableau

Tableau Prep – Connecting to REST API

Tableau Prep or Tableau does not have A built in rest API connector, but we can download data from rest API using  Power Shell and pass it to  Tableau Prep Flow. We will be using  IEX Share price API for the purpose of this demonstration. Try the below one liner...

Tableau Tip: All about Leading and Trailing Zeros

Handling numbers as text for the first time in Tableau  is a frustrating experience. Depending on your requirements, you might have to add /remove  trailing/ leading zeros, modify number of decimal places etc. This post is an attempt to address the  most common scenarios. Note:  If the final result required...

Automatically loading the latest file from a folder in to Tableau

If you have a folder where files are added daily, how do you load the latest file automatically in to tableau? I recently answered a stack overflow question  and this post is an attempt to explain the other aspects that is not covered on that answer. Basic Setup If you...

Using Open StreetMap in Tableau

The default map in Tableau is good for showing overall locations, but it cant be used to zoom in to specific streets or buildings in your locality. But dont worry, you can use Open StreetMap for that. Download this file and save it under Mapsources folder in your Tableau repository.  Default location...

Predicting Dam Water Levels Using Tableau

My home state is going through a crisis right now as the largest arch dam in Asia , Idukki Dam is reaching its full reservoir capacity due to unprecedented monsoon rains.  All 5 shutters were opened on 10th August and is still releasing water at a rate of 0.75 million liters ...

JIRA to Tableau in two lines of Python

Recently, I had to create one  status dashboard for a JIRA project.  Tableau does not connect to JIRA out of the box and you need to purchase a connector to get  this functionality.  Since JIRA has a  REST API, my initial instinct was to build a web data connector. But ...

Tableau – Using SQL queries to get data

Tableau allows to connect to a wide variety of database systems and most of the operations like joins, filtering and ordering can be done without writing a single line of SQL. But what can be done  if the data required is not readily available in the database tables? There are...