The winners of the “Visualise the Numbers” bounty, sponsored by Department of Finance is Team Marika.
The problem they were trying to address?
The main challenge was to display numerical data visually using one of the GovCMS data visualisation modules.
The team connected to many Excel files with hundreds of rows of data in order to display graphs and charts using a GovCMS module called Data Visualisation Framework (DVF).
The challenge required it to run on GovCMS which is based on Drupal version 8 or 7.
The team chose to deploy on a virtually-free tier of Microsoft Azure.
One of the challenges faced was installing Drupal 8 and the module DVF.
The team ran into some problems installing and configuring the Drupal Core and the module DVF on Azure. Getting these going took re-installation and was time consuming.
GovCMS has many features and functions. The team did not aim to build a fully-functional website. Instead, they focused just on the Data Visualisation Framework.
What data was used?
The team converted the original dataset from the Labour Market Information Portal (http://lmip.gov.au) on Occupational Projections into csv format and explored various graphical display options in the DVF module.
The size of the dataset was also reduced to a minimum. The aim is not to analyse the data but to explore how numbers are presented visually using the DVF module.
Another data source was about “Sea level change over time”.
The team wanted to promote the message of “Young Women in Tech” by showing a young girl with a magnifying glass examining stacks of data
Dean Nguyen, Head Teacher IT Ultimo TAFE, Carolle Piedade, Teacher IT Ultimo TAFE, and the other two were students Michal Lachowicz & Charles Montojo.
Dean was a bit disappointed that more students didn’t come but now that they’ve won, he’s planning to publicise it for next time.
Three of the team were on site on Friday night, the fourth couldn’t be there because he was working during the weekend. The team met, listened to Tony, (the chief judge), and went home to review the challenges. The team was overwhelmed with all of the different challenges available, different state and national projects, and various date lines to submit something by.
It was a real challenge to get even the small team to work together. One of the team only worked after midnight until the wee hours of the morning. To work together like this the team created a Slack group.
The team had some videos of the installation and configuration of Drupal and the module, and a slide presentation but didn’t time to put them together.
On Sunday afternoon, with only a few minutes before 5pm they said “we have to put something together” so they saved the presentation as a video and submitted it.
In 48 hours they did the best they could, learned a lot, but found the large number of challenges confusing.
Feedback from the team, including the member who only worked after midnight, (an International student), was that GovHack was an amazing experience. He’s already told his mum and dad about the competition and, as he’ll be back home next year, he would like to participate from abroad if that’s possible.
Team project page – https://hackerspace.govhack.org/projects/govcms_data_visualisation_161
The video: https://youtu.be/U8AUk8oz2zU
Interview by Peter Marks for GovHack