Our Blogs

WE LOVE TO SHARE

So here are our latest blogs sharing what we have learnt lately, we hope it will make your life easier.

Offset date filters in Yellowfin

Yellowfin uses filters to return just the data you need for a report and when you have multiple datasets you can link those filters together and in our example with an offset date to filter them differently. This means within a report you can filter your dataset x...

BEAMing with excitement! Lawrence Corr comes to town

For a while we've been delivering our 1-day Optimal Introduction to BEAM workshops. Originally we had a problem, similar to most people, there was a gap between building a Data Warehouse and understanding what was actually needed from it. Before BEAM, requirements...

Recipe for a Yellowfin GeoPack

The peeps at OptimalBI have been proving our productisation process and one of our outputs was to create an NZ GeoPack for our Yellowfin partner and thought we'd share the approach we took to deciding on it's content. If you're not sure what a GeoPack is then check...

Map your data with Yellowfin

With the recent release of Yellowfin 7.1 mapping and geospatial capabilities were greatly enhanced and Yellowfin introduced us to GeoPacks, which are a brilliantly simple way to map your data and add to it. As they describe it 'making world class mapping available to...

Contexts and custom fields in JIRA

We're working through a series of tasks to migrate our time keeping and workload management into JIRA. For this we needed to set up some extra custom fields so we could gather all the data we need to integrate with our other apps. JIRA allows you to add extra fields...

BEAM and the Agile BA

A while back we had a problem, a disconnect between what people were asking for and what they really wanted. At Optimal we're all about data but more importantly how people get insight from it, if a customer doesn't get value from what we've provided then we're not...

Importing Agile Stories into JIRA

We've started using JIRA to manage our projects. This is how we got our data into JIRA. We wanted to get our data in without lots of manual intervention, so we put it into a CSV and imported it - here's the details if you're looking to do the same thing. It seems that...

Using a custom Header and Footer in Yellowfin

We use Yellowfin as the reporting layer for our MagnumBI platform for many reasons, one of them is customisation. Yellowfin have designed their product so you can change it to match your own style and brand it.   PRE-REQUISITES Before you get started there's a...