An accomplished problem-solver with a desire to make valuable insights in data and a passion for data visualisation, Philip comes from a strong analytical background, having two Master’s degrees in Theoretical Physics and a Distinction in Clinical Science. He then spent three years working for the NHS where he gained Python and MATLAB experience by analysing image datasets.
In 2017, he joined the Data School to acquire formal training in Alteryx and Tableau to become a proficient problem-solver in the challenging world of BI.
In his spare time, Philip enjoys 5 aside football, cryptic crosswords and table tennis.
The Data School has been a trying and testing four months of my life. The experience has largely been what I expected reading the previous data schools’ blogs of their own time here and from my own guesswork… with three main differences.
A testing “Dashboard Week” at The Data School culminated in creating a visualisation of Mr Andy Kriebel’s marathon training. Find out how I mapped the Runkeeper data with additional mile markers in Tableau here.
For any repeatable and/or tedious task in Alteryx you probably require a macro. Further, if you want to run that task for a list of different inputs and set controls on how it deals with those inputs then it may be prudent to turn that macro into a Batch Macro. Read how to batch it here.
A macro is simply a combination of instructions ran as a single command. In Alteryx this translates to packaging up multiple tools into one tool. This is how you do it.
The increasingly useful API is used ubiquitously to send and receive data. Alteryx makes short work of obtaining data using a web API and parsing it into something useful. Furthermore, the workflow is very similar when using any API. Learn how to use APIs in Alteryx here.
The custom admin views allow all administrators on Tableau Server the ability to see the server’s usage statistics. To see the original ‘uncustomised’ admin views, login to your server select the site name at the top of the screen to reveal a drop-down box. Then...
The tabcmd command line utility is an immensely powerful tool for manipulating the content of Tableau Server. This can include things like creating a project, adding a user, publish a workbook or refreshing an extract. Learn how to accomplish this here.
Proper administration of your Tableau Server requires regular backups. This can be done using the tabadmin command-line client. Find out how it can be done here.
How should you format your data to create the spray /hub and spoke/wagon wheel/network chart? Make each row a single point, give connected points the same ID and sequentially order by path. Click to find out more.
So you want to use KML Files in Tableau? Tableau comes with a list of recognisable geospatial areas and regions straight out of the box. But this list is limited and oftentimes you will want to create your own custom geocoding to create a filled map. How can you map KML shape files both in Tableau 10.1 and 10.2 using Alteryx. Read to find out.
This is my summary for the first week at The Data School. It contains lots of talks, drawings and a little bit of Tableau.