Our blog - INFObytes, is an endeavor to contain, share and propagate ideas from Analytics enthusiasts and evangelists. If you live and breath Analytics, you have found your ultimate destination. Be ready to indulge in opinions and float in a pool of ideas.

Happy Reading!

Happy Data Geeks

USEReady’s mission is to help organizations succeed by fast tracking their business performance. We relentlessly strive towards value-driven innovation and digital transformation using advanced business intelligence, data management, and infrastructure security solutions.

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.

Deficit/Surplus Analysis is a very important concept in the financial world. It has deep impact on a company’s growth and progress.

Though Deficit and Surplus go hand in hand, analysts in general refer to it as Deficit Analysis. The concept is very simple and straight forward. We usually have a Start Value or the Threshold and an End Value or the Actual. We are interested in finding the difference between these values.

Deficit Analysis can be used for a lot of situations. The most common are Calorie Intake and Nutrition Deficit, Revenue and Expenditure, Imports and Exports – Trade Deficit, Budget Deficit, Stock Volume – Break Value, Profit and Loss, Income and Expenses, Equity – Assets – Liabilities and list goes on.

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.

Comparison charts are very common and most important charts for any data. Tableau also can create some very special comparison charts. One such widely used and popular chart in excel and other BI tools is a Dual Axis Chart or referred to as Combo Chart (Involves the combination of 2 charts).

We focus on 2 measures where one measure is superimposed over another measure. Many of us assume that the second measure is placed above the first measure. It is not above, it is on (One behind another).

Any other comparison chart that we build in Tableau needs the same scale for comparison. But Dual Axis (The word itself is very intuitive – 2 Axes: one for each measure) allows for the use of different measures. In many cases, Dual Axis is used for Time Series.

Tableau can create some very special comparison charts. One such chart that has gained wide recognition in the recent past is 'Bar in Bar' Chart. In this blog, we share some of the best practices on how to create a Bar in Bar Chart in Tableau.

ANALYTICS WEEKLY NEWSLETTER

Subscribe to our email newsletter for a weekly digest of our best blog content and other news, updates and trends from the world of Big Data and Analytics