Monday, 11 February 2013

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.

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.