About davekeys

This author has not yet filled in any details.
So far davekeys has created 26 blog entries.

New face at Key Data: Sam Batchelor


Here at Key Data we are expanding our horizons and would like announce that Sam Batchelor has recently joined the team.

Sam has moved from Auckland, New Zealand with her husband and son, and brings a wealth of knowledge around data and especially Tableau. Previously at Fonterra as their Data Analytics Manager, Sam enjoys working with people to make sure that they can get the most value from their data.  Sam has a wealth of experience in large organisation Tableau and Analytics enablement which beautifully compliments our offerings.

Sam is very excited to meet our clients in Brisbane and looks forward to the longer months of good weather available in the “sunshine state”.

New face at Key Data: Sam Batchelor2018-02-26T03:46:39+10:00

Key Data Consulting wins the Tableau’s 2016 Services & Training Partner of the Year Asia Pacific Award


I am incredibly proud to announce that Key Data Consulting has won Tableau’s 2016 Services & Training Partner of the Year Asia Pacific.

With over 200 partners in the Asia Pacific region the award recognizes our team’s performance and achievements in helping customers to see their data differently, using Tableau.

In the past year, we have delivered a blend of services and training to customers throughout Asia-Pacific and beyond, including India, Papua New Guinea, Singapore, Indonesia, Malaysia, Hong Kong, the United States and almost every State in Australia. This accolade shows that our efforts, expertise and approach are making a real difference to our Tableau clients.

We work hard to differentiate ourselves with our experience, deep understanding and service offerings over end to end Analytics platforms including sourcing data from raw data sources to ETL to Data engines and Data Warehousing, Best Practises in Data Preparation, Visualisation and of course the Tableau front end.  This allows us to offer Tableau services & training within the broader organisational context of how to get the very best from Tableau’s fantastic capabilities.

Receiving the award at the annual APAC Partner Summit was a great honour—and a strong motivator to continue our focus on delivering best-of-breed analytics solutions to all KDC clients.  We are ecstatic with the award!




Key Data Consulting wins the Tableau’s 2016 Services & Training Partner of the Year Asia Pacific Award2017-03-06T12:26:41+10:00

How to Save $10,000 on Digital Tech Purchases


If you’re part of a small business in Queensland, it’s a good time to purchase software and get the training you need to use it. Until 9 December, the Queensland Government is offering small businesses matched funding of up to $10,000 for hardware, software and services as part of its small business digital grants programme.

So, if you’ve been thinking about purchasing data discovery or any other business-specific software or associated training; or you need new hardware to do your business more easily and innovatively, the time is now.

What you need to know

  • You must be a Queensland-based business, with fewer than 20 employees.
  • You’ll need to show that the digital technology or service purchased and adopted will enhance the digital capabilities of your business, help you to be more competitive or employ more staff.
  • Up to 20% of your co-contribution amount can be an in-kind element for personal time spent being trained in new technologies.
  • All purchases must be completed within three months of the date of approval.
  • Applications close 9 December 2016.
  • If you’d like to apply  help with the cost of purchasing Key Data Consulting services or products, get in touch. We’ll get you the quotes and information you need to complete your application.

Full details on eligibility, applications and reimbursement are available here.

Best of luck!


How to Save $10,000 on Digital Tech Purchases2016-11-22T14:55:43+10:00

Viz of the Day – Congratulations Sian!


Thrilled to hear Griffith University’s Policy Innovation Hub has been awarded Viz of the Day on Tableau Public!

A big congratulations to Sian Robinson et al from everyone here at Key Data Consulting! Sian’s work visualised the Queensland electorates using census data. It is difficult to get an appearance on Viz Of The Day as it is selected globally and you have been using Tableau for about 3 months! I’m happy to have been able to help get you started with Tableau and this project.


Viz of the Day – Congratulations Sian!2016-06-17T11:39:03+10:00

Open Data Viz Starter


This coming Wednesday 25 May 2016 the Brisbane Tableau User Group have an Open Data competition vizfest (lets just get people building viz’s).

Here are some resources and examples to make creating an Open Data Viz super easy!

Some suggestions:

  • It all starts with the data,
    • If you want to include maps tableau recognises postcodes and LGA’s “out of the box” (for LGA use Geographic Role = County)
    • Look for deep narrow data – instead of lots of columns look for lots of rows
  • You can connect to the sources below and publish to Tableau Public using the freely available Tableau Public client or Tableau Desktop
  • I have put a very simple quick video below

Here are some great Open Data sources about Queensland:

Non State Schools Accreditation Board

Education Statistics and Information – Enrolments

Department of Housing and Public Works

Qld Health – Preventative Health Survey Results

State Library of Queensland Open Data Portal

Department of Natural Resources and Mines Data

plus several other great links below










Remember to publish the viz and get the url link to place in the meetup notice board.



BTUG Open Data

Open Data Viz Starter2016-05-19T23:29:03+10:00

Sports Viz – Australian Dragon Boat Championships


Here is a Viz I developed for the 2016 Australian Dragon Boating Championships.

Tableau can help athletes and trainers to understand their sports data in an intuitive way.
For Dragon Boaters – and data lovers. Enjoy!



Sports Viz – Australian Dragon Boat Championships2016-05-15T08:48:07+10:00

Our size, services, and reputation are growing!


Tableau Partner Summit 2016

Our size, services, and reputation are growing!

It’s still early in the year but already I have plenty of news to share.

Firstly, I was thrilled to discover Key Data Consulting was one of only three Tableau Partners nominated for Services Partner of the Year at the 2016 Asia Pacific (APAC) Summit.

The nomination at APAC recognised our small team’s excellence in delivering Tableau powered solutions and training for our customers, not just in Australia but across the whole Asia-Pacific region.

I was excited to attend the summit, meet other Tableau Partners, and access previews of next-generation programs. I was even more excited when I learned we’d been nominated for the 2016 Asia Pacific Services Partner Award!

The nomination shows just how quickly we’re gaining a positive reputation in our industry. It was truly humbling to see our name up against some of the industry giants including the winner, RXP Services.

Recognition at APAC came just after I learned we’d been successful in our bid to become an approved Panel Member for the provision of ICT services to Queensland Government agencies.

Panel Membership puts us in the best possible position to help government agencies harness the full potential of their data. I’m looking forward to developing new working partnerships with government this year.

Last but not least, our size and services are growing! Our analytics services are expanding as our team is growing too. Stay tuned to find out who’s joining the KDC team and our new service offerings in the very near future!


Our size, services, and reputation are growing!2016-02-23T11:04:16+10:00

ODIQ – What a year!


The Open Data Institute of Queensland had its first Annual Celebration and review in December combined with a “Data as Art” Exhibition.  I was sad to have missed this event as I was overseas but enjoy supporting this organisation.

In the past year Key Data Consulting have supported ODIQ behind the scenes and as a Lunchtime Lecture presenter, we plan to continue this close association as Open Data moves more and more to become an essential element for Business, Government and Personal interests analysis.

I have included links to ODIQ’s first annual report and website below.  If you are Brisbane based and looking to get the most from your data. . .get involved!

If you need help in working out how to best use open data for your business then we can help. Simply get in touch!

ODI7052 2015 Annual Report Final

ODIQ – What a year!2016-01-04T14:21:56+10:00

How analytics leads to behavioural change



Analytics is about making differences obvious in a way that enables changes in behaviour and outcomes

At the 2015 Australian Tableau Conference, I gave a presentation on the application of Sports Science using Tableau and new generation ETL tools like Lavastorm and Alteryx. Using these tools helped my (Manly Dragons) Dragon Boating Club team to analyse team and individual technique and make positive changes to training routines. I got some great feedback on the presentation and Tableau has now kindly made a video of it available on their Customer Stories page. 

If you take a look, you can also see the Viz I created that compares different paddling styles. Using this, the team’s paddlers could envisage and understand the differences between their technique and their teamates’. An old coach used to say “there are 3 paddlers in everyone, the paddler they think they are, the paddler everyone else thinks they are and the paddler they actually are.” She was exactly right. The Viz removes two of those perceptions, leaving only the true paddler.

The Viz really does make differences obvious in a way that enabled changes in behaviour and outcomes for the team. In the example the behaviour is use of a paddle, but it can easily be variance in a production line or ANY business process. When I am developing analytics, my thought process is:

How can this information be portrayed to make desired change obvious?

Will it be easy for the audience to understand why or how that desired change is needed or should be done? 

This is more important than technical skills necessary to complete the work— they are a means to an end. The real skill is the ability to create change by presenting information in a way that minimises change inertia, whatever the cause of that inertia. You also need insight into causes of inertia if you are trying to change something; what is obvious to you may not be obvious to the people involved in the process.

It’s exciting to see the story and video on the Tableau site. I am also very excited to be going to Las Vegas next week for the 2015 Tableau Conference. I look forward to coming home with new insights, tricks and geeky stuff for the Brisbane Tableau User Group on November 11. I hope to see you there!

How analytics leads to behavioural change2015-10-18T06:48:14+10:00

How to get good at Tableau – in 8 easy steps


[columns] [span4]



I get a lot of people asking me how they can become good at using Tableau. It’s a rapidly growing market and it’s natural to want to keep up with the latest technology.

If you want to fast track your Tableau learning curve here are my top tips:

  1. Find something you are passionate about. It needs to be something that has a good amount of available data. A lot of the subjects people are really passionate about have publicly available data, e.g. sporting data. You can use Open Data released by governments simply by searching ‘subject name’ and ‘data’. See what comes back!  We recently had a member of our User Group present on the TV show “Survivor” using data off Wikipedia and the internet, he was passionate, he had put in the effort and it was fascinating!
  1. Get Tableau. If you have Tableau Professional or Personal, that’s great. If not, download Tableau Public (it’s free). You can publish your discoveries about your passion to the world on Tableau Public.
  1. Subscribe to Viz of the day– the examples aren’t always perfect, but some are fantastic. Viz of the day can give you a great idea of how other people are using Tableau. There is a huge variety of ways that people attack data issues so when you see a good or interesting Viz, download it and look at how the author created it.
  1. Get familiar with and use the Tableau online learning tools, these are first rate.
  1. Go to a publicly available Tableau training course. These are excellent, well thought out classes. Training can take you to a higher ability level very quickly.

Extra tip: If you buy the product and use it frequently in the month before the course, you’ll absorb more useful information at the course. Don’t waste your absorption capacity on basic stuff!

  1. Read up on Stephen Few’s tips on Visual Design at perceptualedge.com. Or even better, attend one of his excellent courses.
  1. Join your local Tableau User Group. If you can, present the work you did on your chosen topic of passion. You never know, your enthusiasm might be contagious! It is ALWAYS more interesting listening to someone talk about a topic they love. I am lucky I have several to choose from where I have done deep analytical analysis.
  1. Stretch yourself. Focusing on a subject you love makes it easier to reach a deeper level of thinking and to find time for data discovery. You will find yourself stretching your learning further with ease.

For myself, I have been lucky to have had a string of topics I am passionate about. Each has taken me to a new learning level as they required a subtly different approach to get the best insights from the data using Tableau. The broader your experience, the more you have to call on when a new question arises.

Lastly, if you only do one thing, find something you’re passionate about and apply it to Tableau. Oh, I already mentioned that!


How to get good at Tableau – in 8 easy steps2015-09-16T19:31:32+10:00