Remove the time from a datetime in SQL

2018-05-07T20:18:57+00:00April 27th, 2011|SQL|

There are a few ways to remove the time from a datetime in SQL. This article descibes 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

2011-04-11T13:04:56+00:00April 11th, 2011|Tableau|

I’ve done a bit of research on how to unhide sheets in Tableau and have come to the conclusion there isn’t a quick and easy way to do it. When your hidden sheets are on a dashboard you need to individually select and unhide each sheet which can be cumbersome dependent on the number of [...]

Report Design – turn data into information

2018-05-07T08:27:16+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 opinions, as the report designer/developer, don’t really matter. You won’t be using the report every day, [...]

Report Design – Design Reports for the Audience

2018-05-07T08:15:58+00:00April 5th, 2011|Reporting Theory|

For reports to be used they have to be designed for the audience. When you design reports you need to 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 [...]