Tableau Format Month
Do you want to know how to abbreviate the month name in Tableau? Maybe the Month name taking up too much space on your Tableau …
Tableau Year on Year calculation
In Tableau there are two main methods for calculating a year over year change: YoY Growth Table Calculation method Using standard calculated fields to calculate …
Tableau hiding null values in line chart
In a Tableau line chart, Tableau automatically places null values to 0 (zero) on the X axis. This is technically incorrect; NULL means the value …
SQL Calculating the row number
To label the row number in SQL there’s a useful SQL function you need to know about: ROW_NUMBER() As the name suggests, it numbers all …
Remove the time from a datetime in SQL
There are a few ways to remove the time from a datetime in SQL. This article describes two of them. I am deliberately ignoring ways …
Unhide Sheets in Tableau
This post about how to unhide sheets in Tableau was first written in 2011. Tableau has evolved significantly since then and unhiding sheets is far …
Report Design – turn data into information
The purpose of reports is to convey information. A report is one of the only user-facing steps when converting data into useful information. Reports and …
Report Design – Design Reports for the Audience
For reports to have good usage they should have appropriate design and structure. When designing reports think about the audience and the questions they are …
Tableau Parameter to Display Measures Selected by User
The introduction of parameters with Tableau 6 have made Tableau far more powerful. Intelligent use of these have made many things possible that we couldn’t …
Tableau vs Xcelsius vs SSRS
All of the reporting software I’ve used has it’s strengths and weaknesses. Here is a quick overview of Tableau vs Xcelsius and SSRS. Xcelsius – …