Blog

Tags
Search

NESTED RANKS FOR MULTIPLE DIMENSIONS IN TABLEAU

Rank is a very powerful concept in Tableau and one of the widely used Table Calculations. It can be used in many situations along with other Helper functions like Index(), First(), Last() and Size(). It can also be very effectively leveraged for Pagination. In this blog, we will focus on the Top Ranks using multiple Dimensions within the same visualization for the same measure.

POPULATION PYRAMID IN TABLEAU – 2 METHODS

Population pyramid is a histogram type of graphical representation that shows population by gender where values are stacked top to bottom from high to low or low to high values. Some analysts call it a step chart because it looks like a flight of stairs. From a broader view, it represents a triangle or a pyramid structure. In this blog, we shall be discussing two methods of creating this chart in Tableau. The first method is a crude method which has multiple pieces assembled on a Dashboard. The second method is a more powerful one where all changes are done in the same visualization.

CUSTOM COLOR FOR BULLET CHARTS IN TABLEAU – 2 METHODS

Bullet chart was introduced by the data visualization pioneer Stephen Few to overcome some of the older visualization techniques and charts like Gauges, Speedometers and Thermometers. Bullet chart is one of the best charts to show progress of a metric with respect to an existing standard. This blog aims at creating a Bullet Chart with customized color segments for the defined ranges.

SPLIT STRING FIELDS BASED ON DELIMITERS IN TABLEAU – 2 METHODS

Split function introduced in Tableau 9 was a very good addition to the existing automatic functions available in Tableau in other lower versions. The split function has two features. One is an Auto split which identifies a common delimiter and creates only two new columns. The second one is a custom split where the Tableau developer specifies the delimiter and the number of columns required.

SPLIT FILE INTO EQUAL OUTPUTS USING ALTERYX – 4 METHODS

Data staging is a very important phase during database upgrades or database migration or for use in parallel processing. Some architects take the dump of entire data either as JSON format or Text format. Then the file is cut into multiple pieces so that the new data warehouse can be populated in small incremental steps. This helps in identifying errors and is also easy for debugging if the process fails at any stage. In this blog, we will be discussing different methods to split a sample file into equal pieces.

DEFICIT ANALYSIS CHART IN TABLEAU (PIE CHART)

Deficit/Surplus Analysis is a very interesting concept in data analytics. It has deep impact on a company’s growth and progress. The word Deficit can be used as the noun form of Deficient (Deficiency) meaning less nourishment which is not restricted to food. The common way of representing Deficit or Surplus would be a simple Percent Change calculation. In the previous blog, we used a modified waterfall chart. In this blog, we will build a special Deficit Donut chart (a slightly modified Pie Chart).

ONE CLICK PDF DOWNLOAD FROM TABLEAU SERVER

PDF download is among the common features requested by end users and Tableau has a good built-in feature for this. But sometimes users might get lost in navigation. Leveraging simple HTML & JavaScript code would allow users to download a PDF link by a single click.

FINDING LEAP YEARS IN TABLEAU – 3 METHODS

We know that leap year occurs once every 4 years. For some firms, accounting the extra day can have its own positive and negative impact. There are few companies that allocate budget on a day to day basis. For them, the extra day can become an issue. For some financial companies, it works well as it generates an extra day of revenue.When it comes to reporting, we find inconsistency in comparison values involving a Leap year. We don’t realize it in the beginning. When we do some investigation with the data, we find the leap. In this blog, we will discuss 3 very simple methods to identify if a year is a Leap year.

DEFICIT ANALYSIS CHART IN TABLEAU (BAR CHART)

Population pyramid is a histogram type of graphical representation that shows population by gender where values are stacked top to bottom from high to low or low to high values. Some analysts call it a step chart because it looks like a flight of stairs. From a broader view, it represents a triangle or a pyramid structure. In this blog, we shall be discussing two methods of creating this chart in Tableau. The first method is a crude method which has multiple pieces assembled on a Dashboard. The second method is a more powerful one where all changes are done in the same visualization.

FORMATTING NUMBERS TO REQUIRED UNITS IN TABLEAU – 2 METHODS

Number formats are very important for reporting, especially when representing huge numbers like population, stock volume, balances, manufacturing units etc.. Also, formatting is a feature of best practices since end users are not interested in every units and tens place. They are more worried about the Billions and Millions and Thousands. Also, this does not inundate the end users with a bunch of numbers.

SHOWING MIN & MAX AND START & END IN TABLEAU – 2 METHODS

End Users are very keen to understand the time trend of the business. Chronological progression in time reveals a lot about the journey. If the time series has a lot of fluctuations, it is easier to read only the crests and troughs. But some end users just want to look at the highest value (may be the best value) and lowest value (may be the weakest value). At the same time, there will be requests to show what the start value was and what the end value is. Showing all the four values – Start, High, Low and End depicts a very good journey of data. In this example, we will show the labels for all the 4 above mentioned data points on a Time Series on Tableau. There are different ways to achieve this. In this blog, we shall discuss 2 different methods.

1 2