Jonathan Waerner
Jonathan graduated from the University of Wollongong with a Bachelor’s in Mathematics. When looking for graduate positions but not quite ready to stop learning, he thought the Data School was too good to be true. Jonathan’s passion for data sparked discovering vlookup and is excited to find this is just the tip of the iceberg! Outside of work, Jonathan enjoys playing soccer, cooking up a storm, and spending time with his family and friends.
The Data School Training Period – Reflections and Highlights
The four months of training at The Data School have been hard work, there has been some long days, some tricky content and big expectations. There are many things that I love about The Data School, by enjoying what I was doing I was able to take the challenges in my...
7 Apps and Websites I used while at the Data School
Towards the end of my time as a Data Schooler in Training, I’d like to share some of the resources I found to be helpful to my training. Some of these will be great to use in any profession, while others are more specific. 1. Notepad++ Has been my text editor...
Using Calgary in Alteryx
Last week we were working with a large data set of sales information, which equated to >200 million rows of data. The first couple of hours the team was fairly stuck in the mud, when trying to explore the data in Alteryx. In order to speed up the reading and...
Web-Scraping using Batch and Iterative Macros
A couple of weeks ago we were connecting our blog website’s Google Analytics Data. We had a great time comparing who the tops bloggers are, between and within Cohorts. During this week, I had a go at web-scraping our blog pages to get a URL for each blog, the tags,...
Dashboard Week, Day 5 – Journalist Deaths
For the final day of dashboard week, we looked at a data-set of every recorded death of a Journalist where the cause of death was a direct result of the work. The data set is from The Committee to Protect Journalists (CPJ). We were also challenged by Craig to only use...
Dashboard Week, Day 4 – Gapminder Data, Visualizing Life Expectancy
Today we focused on using Data-sets available from Gapminder. These Data Sets cover a huge range of global measures, and it was awesome to explore them! I was especially excited to see many data-sets that covered many countries and went back so far in time (some back...
Dashboard Week, Day 3 – ICC Cricket World Cup Data
Today we worked on making dashboards using the cricket data Craig has been working on recently. I thought I’d use this opportunity to make a dashboard showcasing some radar charts. I have been meaning to write a blog on these charts for a while, I think they are great...
Dashboard Week, Day 2 – Coffee Pods and Plastic Waste
Today we were given a much cleaner set of tables, but were challenged instead by being restricted to using Power BI. Since we have only done an introductory session on Power BI, I feel like this was a “thrown in the deep end” type of challenge. It’s also a great way...
Dashboard Week, Day 1 – Domain API
The first day of Dashboard Week kicked off with an API challenge. We were all required to connect to the Domain API, which gave us data for property listings and agents. I decided my Dashboard should focus on giving the user a way to explore many properties at once...
Learning to Code – Starting from Scratch
Both Tableau and Alteryx provide a great visual user interface and provide complex outcomes with simple drag and drop actions, meaning that people from all backgrounds can try their skills at Data Analysis. However, they still occasionally require typed commands. This...