Visualisation

Is the Sunburnt Country Burning Up?

2018-03-18T22:27:58+00:00

At KeyData, we are passionate about using data to understand problems and share information.  Analyst Sam Gillespie has created an interactive visualisation using data available from the Bureau of Meteorology to help illustrate what is happening at temperature stations across Australia.  Using this infographic, you can explore how temperature varies across Australia, and see how it’s changing over time. Check out some statistical analysis of the trends to work out just how much the temperature is changing across the face of the country.

With Tableau, making interactive visualisations is a breeze.  Explore Australia’s temperature data below!

Is the Sunburnt Country Burning Up? 2018-03-18T22:27:58+00:00

New face at Key Data: Sam Batchelor

2018-02-26T03:46:39+00:00

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 Batchelor 2018-02-26T03:46:39+00:00

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

2017-03-06T12:26:41+00:00

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!

Links:

www.techtradeasia.info

www.smechannels.com

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

Viz of the Day – Congratulations Sian!

2016-06-17T11:39:03+00:00

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+00:00

Open Data Viz Starter

2016-05-19T23:29:03+00:00

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

http://qldspatial.information.qld.gov.au/catalogue/custom/index.page

https://data.brisbane.qld.gov.au/

http://au.okfn.org/2014/03/11/open-data-in-queensland-lots-of-planning-and-705-state-datasets-available/

https://translink.com.au/about-translink/open-data

http://www.racingqueensland.com.au/Industry-Services/Open-data

https://www.business.qld.gov.au/business/support-tools-grants/services/mapping-data-imagery/data

https://www.communities.qld.gov.au/gateway/communities-open-datasets

https://www.ecq.qld.gov.au/about-us/corporate-documents/open-data

http://www.bpeq.qld.gov.au/BPEQ/Resources/Open_Data_2/BPEQ/Navigation/Resources_-_Open_Data.aspx?hkey=59eb26ae-2c7f-42b9-844f-8b154fddb582

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

https://youtu.be/_hTsJ_7an7M

 

BTUG Open Data

Open Data Viz Starter 2016-05-19T23:29:03+00:00

Sports Viz – Australian Dragon Boat Championships

2016-05-15T08:48:07+00:00

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 Championships 2016-05-15T08:48:07+00:00

How analytics leads to behavioural change

2015-10-18T06:48:14+00:00

Contrast_Paddlers

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 change 2015-10-18T06:48:14+00:00

How to get good at Tableau – in 8 easy steps

2015-09-16T19:31:32+00:00

[columns] [span4]

KeySkillsLogo

 

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 steps 2015-09-16T19:31:32+00:00

Making waves with data driven performance

2015-04-29T09:05:04+00:00

Analytics is the tool of choice for improving performance in almost any field. Used properly, analytics makes obvious differences to elements that influence results. It works in sport and it can work for your business, too.

Last week my sporting club, Manly Dragons, competed in the Australian Dragon Boating championships and WOW what a result!

[columns] [span6]

Manly Dragons wins 2015 ADBF Masters Championships

Manly Dragons wins 2015 ADBF Masters Championships

[/span6][span6]

Club President, Jeff Hammane put it this way; Well Manly, that does it. 59 paddlers, 38 events, and 75 races covering 33,100 metres of paddling to deliver 3 Bronze, 6 Silver, 8 Gold medals and one Masters Championship. All this from a club that won its first medal only 4 years ago. Beyond awesome.’

This was an excellent result that as a club we are ecstatic about! We are now officially the best Masters club in our sport in Australia. So how have we achieved this in such a short period of time?

[/span6][/columns]

  • Individuals have very high commitment to the sport and team. This is undoubtedly the biggest single factor.
  • Excellent coaching. We are fortunate to have a powerful blend of strategic thinking and a disciplined coaching crew.
  • We built on these strengths by using analytics to:
    • ­Help our athlete’s visualise their progress in training throughout the year with our ERG ladder
    • ­Discover and visualise technique differences (See Tableau example workbook below) between paddlers using paddles with built-in Accelerometers and positioning devices.
    • ­Understand and improve team technique in the boat e.g. by using accurate GPS and accelerometer positioning devices for our starts.

The team is justifiably proud of our achievements this year. And I am very proud of our data-driven performance!

ERG Ladder

Club members put ERG test results (how many metres can you paddle in 2 mins on a machine?) into a repository on the team website. We use Tableau Public to display results. This has had a big influence on the behaviour of club members including myself!  We now have an active internal competition working our way up the ERG ladder. Many members test themselves on a weekly or more frequent basis. This is a huge contrast to the minimalist approach most team members (including myself) took previously.

 

Technique visibility

Manly Dragons has a ‘magic’ paddle that provides amazing data on how a paddler uses the paddle, however, the data is not presented in a useful manner. It is designed by engineers to supply data but its application is not intuitive. Enter Lavastorm and Tableau. Using these tools, I can take the raw data from the product and interpret the data to easily compare power and paddle styles.  An example of how Paddlers can compare and understand differences in their style is included below.

 

 

 

Making waves with data driven performance 2015-04-29T09:05:04+00:00

Tableau on Tour Presentation – Sports Science: Using Multiple Disparate Complex Data Sources to Win

2015-03-11T10:52:46+00:00

Last week I presented at the Tableau on Tour conference in Melbourne, my topic was “Sports Science: Using Multiple Disparate Complex Data Sources to Win”.

Truth is I am not a sport scientist but wish I was, this stuff is just fascinating and has the advantageous sideline of forming the basis for those potential clients asking about what we can do for them with their data, it allows me to show capabilities without compromising anyone’s private data, it also means I don’t need to explain business processes etc, people just get sport but have to think much harder about foreign business processes. It makes it easy for me to add value to our club as a data geek / sports science wannabe!

This is based on our dragon boating club and how we are collecting and using data to fine tune and shape our technique and training routines.  There is some material that would ideally have the advantage of words I use during the presentation to add context, if you hit one of those feel free to email or comment and ask!

Enjoy!

 

Tableau on Tour Presentation – Sports Science: Using Multiple Disparate Complex Data Sources to Win 2015-03-11T10:52:46+00:00

Recent Posts

Head Office

Level 7, 127 Creek St Brisbane, 4000

Phone: 1300 532530

Web: Key Data Website