Skipper Jack's Tales of Yellowfin and Data Comparison

Hello again shipmates. Welcome to another fishing tale from a Yellowfin Business Intelligence perspective.

Yellowfin is a superb web based tool that we can use on our iPads whilst fishing off the Cornish coast. Back on dry land, my missus uses our Yellowfin reports and dashboards to help us sell the fish we catch by making smarter decisions based on our fishing data.

I’m Skipper Jack and me and my first mate Gerald own a fishing trawler working out of Fowey in Cornwall.

Recently, we’ve upgraded to version 6.2 and got straight into the new Storyboard feature. Be sure to watch the Yellowfin Storyboard training webinars in February.

Webinar 1: Thursday, February 28, 2013, 9:30AM – 10:30AM Australian EDT >
Webinar 2: Thursday, February 28, 2013, 5:30PM – 6:30PM Australian EDT >

We needed Storyboard because recently we’ve been contacted by the Angling Research Society of England. They wanted to know about the declining numbers of Plaice compared with other fish in British waters, specifically Cornwall. We wanted to produce not only relevant data from our Yellowfin reports, but a way forward for sustainable fishing of this species.

Gerald was able to produce a Combination chart in no time at all that measured this information.

It was done by using a Combination Chart with a dual axis, in a report with an advanced append sub query.

Firstly, ensure you have selected the Sub Queries element in the Analysis section. We need a sub query because we want to compare two sets of data, one with a filter equal to Plaice, and the other with a filter different from Plaice.

When creating the sub query, ensure that ‘Advanced’ for the style, and ‘Append’ for the type are selected.

The columns for the report should look like the image below.

Join the queries together by a field that won’t affect the desired result of the report. I.e. in my situation, I would not link the queries on my ‘Fish Species’ field because of the nature of the filters in each query. With one filter being exactly opposite to the other, no records would have been returned in my report.

The filter from the Master Query delivers all rows where the fish species is ‘Different from’.

And the Append query delivers rows where the fish species is ‘Equal to’.

When creating the Combination chart, ensure that in the Chart Settings you add a Secondary Axis for Chart 2. This will create the right hand scale.

This chart will allow you to compare two sets of the same data where the values or numbers are vastly different. It is very useful for comparing the performance of one item against all other items.

That’s all for now except that I’ve always been a fan of the TV show ‘Rex Hunt’s Fishing Adventures’ and so I decided to have a few adventures of my own down under at the Yellowfin Think Tank held in Melbourne on the 4^th and 5^th of March.

Glen Rabie, the CEO of Yellowfin has this to say:

“The 2013 Yellowfin Global Conference is a tremendous opportunity to share in our joint experiences, underpin our future successes, and better understand how Yellowfin can help achieve your business goals”

I might get a bit of fishing in as well … hopefully.

Thanks to ALL OF YOU fellow data fishermen and fisherwomen for reading these blogs.

Until next time ….

Skipper Jack

  

For more information, visit www.yellowfin.co.uk