Automating my Former Job Using Alteryx

Background Before joining the Data School, I worked as a Pricing and Revenue Analyst for a car rental company. The job title was fancy, and the advert intriguing. Promising analysis of previous and current market trends, development of competitive pricing strategies...

Uploading and Updating to Alteryx Server

To upload a workflow to Alteryx server first connect to the server through Options > Manage Server Credentials and then completing the login to the server using the correct URL. You can then begin saving the workflow to the server by choosing File > Save As > Add a...

What Are Data Joins?

For a long time I didn’t understand how joins work, and had to wing it when combining data sets. That time is no more and I am writing this blog to share my new knowledge and confirm to myself that I actually do understand data joins. A data join is when two...

Using Tableau Prep to Clean Personality Test Data

This week at the Data School we learned how to use Tableau Prep to prepare data. After training with the tool in the morning we were given the afternoon to find a data set and use Tableau Prep to clean it before visualising it in Tableau. I chose the results of online...

Tableau: How to Swap Sheets in a Dashboard

To swap sheets in a dashboard parameters must be used. First make the sheets that need to be swapped, I’ve made a scatter plot and a map. Then create a parameter, I’ve named mine “View Map or Scatter.” The data type should be a string and the allowable values should...