Monthly Archives: April 2011

Remove the time from a datetime in SQL

2020-03-19T14:39:36+00:00April 27th, 2011|SQL|

There are a few ways to remove the time from a datetime in SQL. This article describes a couple of them. This is the code: DATEADD(dd,0,DATEDIFF(dd,0,DateToRemoveTime)) I'll explain how this works as it was quite confusing initially. Part 1: DATEDIFF(dd,0,DateToRemoveTime) What this is doing is finding the number of whole days (without time) from the [...]

Unhide Sheets in Tableau

2020-03-07T10:33:08+00:00April 11th, 2011|Tableau|

I’ve researched how to unhide sheets in Tableau and concluded there isn’t a quick and easy way to do it. When the hidden sheets are on a dashboard you have to individually select and unhide each sheet. This can be time consuming if there are many hidden sheets in the workbook. The bigger problems occur [...]

Report Design – turn data into information

2020-03-09T14:12:20+00:00April 7th, 2011|Reporting Theory|

The purpose of reports is to convey information. A report converts underlying data into information. There are a number of things you need to consider when designing reports, all inter-related. One important thing that’s often overlooked is that your opinion, as the report designer/developer, is not that important. You won’t be using the report every [...]

Report Design – Design Reports for the Audience

2020-03-09T13:39:28+00:00April 5th, 2011|Reporting Theory|

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 trying to answer. This will enable you to decide the best reporting software and the correct reporting level. I have delved into this subject in more depth in another post [...]