My Indian Advizture

So (what now seems an age ago) I took my annual holiday, and went back (for the 5th time) to my favorite country…India.

While digging out the back-pack from the back of the wardrobe, I came across our stash of photo’s…about 5 albums of old holidays, and a huge box of photos in the pending/holding-queue! (this will mean nothing to anyone under 30, who may never have owned a physical photograph 😀 ). I also have copious amounts of pen-drives, hard-drives and clouds of other holiday photos, which rarely get an outing. So while we were away…travelling about, having a wicked time, taking snaps I was trying to think of a better way to create a holiday album Continue reading My Indian Advizture

The Importance of Granularity (…to Blend or not to Blend?)

The ‘Granularity’ (or ‘Grain’) of the data is the most important thing I consider for any data analysis. When I get a new data-set, my first question What is the Granularity? When designing a new (Tableau) visual model, my first consideration What Granularity do I need? When calculating a measure (or KPI), my first questions: What is the Granularity? and What Granularity do I need?

I’d go as far as saying “Understanding the Grain of your data is 99% of the solution”… Continue reading The Importance of Granularity (…to Blend or not to Blend?)

Sheet Swapping using Dashboard Actions (or the Illusion of a Full Outer Join on Blended Data)

As the title suggests, this nifty trick has the dual purpose of allowing you to trigger sheet swaps using Dashboard Actions and, when two data sources contain different levels of Granularity, it lets you analyse at both levels (the Granularity of the Primary and Secondary data source). This is the ‘illusion of a Full Outer Join’…All seems a little cryptic and techie. Let’s run through an example…

Sheet Swapping on Action