The Data School Blog
Using LOD Calculations to “Duplicate” Data
During Teaching Week at Data School AU, we were tasked with preparing for and conducting a teaching session. One of the exercises was based on week 35's Workout Wednesday Challenge by Tableau Zen Master, Rosario Guana. Whilst developing the solution, I...
read more
Forecasting with Alteryx
In this post I will examine the The 24th Alteryx Weekly Challenge which was to forecast the number of units that a retailer would sell in the six weeks following the available data based on a historical trend using ARIMA. The Challenge The source data contained weekly...
read more
Using Parameter Actions for Dynamic Date Ranges in Tableau
For a recent client project I created a KPI dashboard that was able to show varying date ranges such as the last month, the last 3 months, last 6 months as well as data for each year in the data set. I thought it would be a good use case for parameter actions to...
read more
Colouring with Calculated Fields in Tableau
When building a Tableau dashboard, the colour scheme is always a key consideration. We know that for discrete values, Tableau will assign a different colour to each member of the field. For continuous values, it will assign a continuous range of colour. Using...
read more
Presenting with Confidence
At Data school we have to present on every Friday, either to Client or for the Friday challenges. In the last couple of weeks, we have seen some good improvements in Presentation skills of our cohort. Every week we are being critiqued not only on the content we...
read more
Basic Workflow Using Predictive Tools in Alteryx
In this blog, I demonstrate a simple Alteryx workflow used for predicting the chance of survival of passengers travelling on the Titanic. Variants of the data set I used can be found on the Kaggle website. However, before I begin with explaining the workflow, it is...
read more
Alteryx Advanced Certification Guide and Resources
The Alteryx Certification Exams are a great challenge when learning how to use Alteryx Designer. Being quite new to Alteryx, I found them helpful to focus on what tools to learn. After having recently passed the Alteryx Advanced Certification I thought I would share a...
read more
Explain Data – AI makes it in to Tableau Desktop with 2019.3
Keeping up with their promise of a release every quarter, Tableau's 2019.3 version has just been released, and there are lots of new features to be excited about. From the Tableau Catalogue, available with the Data Management add-on for Tableau Server to Prep...
read more
Tableau tips and Viz in Tooltips
Meet & Greet events at the Data School are a great way for prospective applicants to learn more about the work at the School. At the most recent event, I volunteered to demonstrate some of the capabilities of Tableau. The experience was also a chance for me to...
read more
The First Client Project
After 4 weeks of intensive training in Tableau and Alteryx, we started our first client project on the 5th Monday. Client projects are great opportunities to work with real data on real business problems, delivering solutions within short period of time using agile...
read more