Grace Murphy
Grace graduated with a Bachelor of Biotechnology (Hons) from the University of Newcastle in 2014. During her PhD she realised that the best thing about doing research was crunching data and building a story with it. Aiming to work in data consulting rather than biological sciences, she came across The Data School Down Under and had to apply. Away from the computer Grace enjoys cats, drawing and British TV sitcoms.
Leaving the Nest – Reflective Blog
The last four months whizzed by faster than you can say “level of detail”. Never in my adult life have I learned more than in my time at The Data School. Perhaps better than the content, however, was the chance to spend every day with 7 brilliant analysts. Alex,...
Time Series Forecasting in Alteryx (Part 2)
The precursor to this blog introduced time series forecasting in Alteryx with the ARIMA and ETS tools. This blog looks at configuring these tools to generate an effective time series forecast. The data set I’ve used contains monthly beer production in Australia from...
Time Series Forecasting in Alteryx (Part 1)
If you’re not a statistician, Alteryx’s time series palette is incredibly useful for producing fast forecasting without too much time spent on Stack Exchange. This blog examines four tools in the palette; ETS, ARIMA, TS compare and TS Forecast. Part 1 will cover the...
Dashboard Week Day 5: Journalist Deaths Abroad
Yesterday morning marked a sad end to the whirlwind thrill ride that is dashboard week. The day 5 data set was sourced from the Committee to Protect Journalists and contained information on world-wide journalist deaths since 1992. Each row of the data was a...
Dashboard Week Day 4: The World’s Anti-Vax Problem
Day 4 of dashboard week started once again with a presentation of the previous day’s work and a reveal of today’s dataset. I’ve come to enjoy these briefings; you can forget about the stress of yesterday and start fresh with new ideas. New dataset, new me. I was...
Dashboard Week Day 3: Lefties in the Cricket World Cup
Day 3 of dashboard week brought with it the return of Tableau. The dip into power BI yesterday was exciting but it was good to get back into familiar territory. It was only fitting that the subject matter of the dataset we received was far from familiar: Cricket....
Dashboard Week Day 2: Mr Clooney and single use coffee pods
Day 2 of dashboard week started with a briefing about George Clooney’s continued ambassadorship for Nespresso® – the coffee pod producing mega giant. As most Nespresso® pods end up in landfill, we were told to use multiple datasets about the world’s growing plastic...
Dashboard Week Day 1: Domain Group Property Listings
Dashboard week kicked off today with instructions to use Domain Group’s free API to find real-estate data on agents or property listings. Domain's API documentation is comparatively comprehensive so it wasn’t long before we were sending POST requests in Alteryx to...
Splitting to columns with Regex_replace in Alteryx
The text to columns tool in Alteryx can sometimes be a little clunky. It’s a quick fix when you need each element of ‘Element1/Element2/Element3’ to be in it’s own column, but what if the string was ‘Element1/ Element2_ Element3 ’? This requires multiple...
Quick and easy date parsing in Alteryx
Dealing with time series is a huge part of data analytics. A date field that’s well formatted and consistent will typically transition seamlessly into whatever reporting tool you’re using. A date field that is consistent, but incorrectly formatted, can normally be...