Meri Kirihimete from OptimalBI

by | Dec 18, 2019

Kia ora koutou and welcome to the last OptimalBI newsletter of 2019 – hasn’t this year flown by!

We have enjoyed supporting our customers to create amazing outcomes for their organisations this year with a range of really interesting projects – payment integration, internet of things data collection, many cloud migration and cloud based integration projects, data architecture, data modeling and solution designs alongside a range of data wrangling, transformation and insights initiatives.
Thank you to everyone we have worked with and who has supported us this year, whether you attended a workshop or engaged us for a large outcome based project – thank you for your support.
We have loved working with you all and look forward to an amazing, collaborative data driven 2020.
Safe travels and happy holidays. Ngā mihi nui, Victoria.

Did you know

BEAM* allows you to model collaboratively!  This helps with scope, prioritisation, by helping the business identify events and determine how they’re to be measured, and most importantly – the collaboration creates shared ownership of the solution.

There’s a 1 day introduction to defining data requirements and data modelling course (a.k.a          BEAM*) scheduled for Thursday 13 February in Wellington.


Reporting Jira data in PowerBI


Our most popular blog of the year!

  • Understand what data is available from Jira REST API’s
  • Get data into PowerBI and transform it
  • Build a prototype report

Read it here.


How to identify rips

Summer means lots of swimming and beach trips!  Keep safe by choosing a patrolled beach and stay between the flags.

Brush up on how to spot a rip, and what to do if you do get caught in one before you hit the water.


Apache Superset on Linux

An innovative open source eco system surrounding PrestoDB built by Airbnb, which supports visualisation, data exploration and collaboration.

Read Thomas’ blog to find out more.


Data Vault and the Ensemble Logical Model

Our partners, Genesee Academy, will be back during the week of March 16 to certify more people in Data Vault and also run an ELM workshop in Wellington.

Early bird registrations are available until February 11.



Data Science Pioneers

We recently hosted 3 sold-out-screenings of the Data Science Pioneers documentary in Wellington as part of the All about BI Meetup group and spread the data science joy in Christchurch as well!

If you missed out, don’t worry, just drop us a line – we can host a screening and Q&A session at your workplace ( in the new year.

Watch the trailer here.

One theme that is discussed in the documentary is data privacy.  There’s a Netflix show called The Great Hack you should watch, and also listen to RNZ’s Kim Hill interview of Cambridge Analytica whistleblower, Brittany Kaiser, who’s just released a book:  Targeted.


Meet Steve


Meet Steve, he’s been part of the OptimalBI team for almost a year, where he makes sure our customers are happy.  Steve loves sunshine so much, he’s ditched wet and windy Welly for the Kapiti Coast and will spend the summer planting natives, exploring some coastal walks and BBQing.  Sounds awful!

Connect with Steve Thomas on LinkedIn.



What’s up?

  • Start 2020 off with some training.  There’s a BEAM* 1 day workshop on February 13, an ELM workshop on March 16, plus a Data Vault Certification course on March 18.
  • If you missed out on the Data Science Pioneers documentary screening, why not arrange one with a Q&A session at your workplace in the New Year?  Just email and we can help.
  • The end of the year, that’s what!  We hope you all have an enjoyable holiday break, stay safe, and see you in 2020!

Have a great day and summer,

~ The OptimalBI team.


Our BEAM* training is perfect for Business Analysts, Designers, Developers and Report Developers wanting to bridge the technical/business divide.  Read 4 reasons why BEAM* is great for those who work with data or register for the next course on February 13, 2020.

Submit a Comment

Your email address will not be published. Required fields are marked *