The Data School Blog
Update Raw XML in Alteryx Macros
One of the best features of Alteryx is its hackability. If getting a macro to do what you want looks impossible, think again! I've started using "Update Raw XML with Formula" on the Action tool to get that little bit extra out of my macros. If you're new to macros in...
I Present My New Text Analysis Tool for Alteryx
I had been planning to create a text analysis tool for a while, when Alteryx introduced its Intelligence Suite in version 2020.2. It includes seven text mining tools. They appear in the new Text Mining category on the tool palette. However, if you want to use them you...
Connecting Tableau Metadata in Alteryx (Part 2 – API’s)
In the previous blog post, I explored how to connect to the Tableau PostgreSQL port 8060 (a database that stores tableau server metadata) using Alteryx. I also went through some examples of why you would want to connect through Alteryx. For today’s blog, I wanted to...
Connecting to Tableau Metadata in Alteryx (Part 1)
Alteryx and Tableau are a match made in heaven, and for today’s blog, I will showcase just one other beautiful pairing of these. Connecting to Tableau metadata (or more broadly the process of connecting to databases). Before we go through the process, however, I want...
5 more tableau tips and tricks
This blog post is a direct follow on from my other post about tableau tips and tricks String fields as hours and minutes 1. How to make hours and minutes in Tableau using having time, or date-time type fields in Tableau. First, some data prep is required. Ensure you...
8 Tableau hacks you wish you knew before
Hi all, this blog is about the small things in Tableau that I know, that I think beginners to Tableau might not. Selecting all of the items in a tableau action 1. Ctrl+A on the action screen can save a little bit of time. If you want everything selected, in order for...
How to Become a Pro at Tableau Dashboards
Over the past few months, one of my responsibilities at the Data School Down Under has been to review Tableau dashboards. This task has raised the question of how I approach building Tableau dashboards. In today’s blog, I wanted to share one of my preferred...
Reflection – This Is Just the Beginning
It's the end of an intense four months... four months of professional data analytics and consulting training at The Data School. Make no mistake, The Data School is definitely not your average school. Here, we learn all the knowledge and skills necessary to become a...
Reflection on My Data School Journey so far
It is indeed a wonderful experience at Data School and at the end of 4-month training I felt very satisfied. I was able to gather so much of information and knowledge learned through different modes and it is high time to recollect and recall one by one that would put...
Tableau Padding and container tips
Hi all, in this blog I’m going to go through the basics of Tableau padding and container tips that I've learnt from using Tableau for a bit. Padding To begin with, I want to talk about tableaus automatic padding when you drag a sheet onto the dashboard. Tableau...
Training at The Data School: Reflection
16 weeks have passed in usual fashion - quickly. However, these past 16 weeks have been unusual, or perhaps better described as unique. That is the best way I can summarise the four month training component of The Data School - unique. My time so far in The Data...
Reflection: The End of Training, Never End of Learning
I can't believe it is the end of the training section in Data School! How time flys! Before joining the data school, I was a data analyst. I wanted to join data school to pursue my career in Sydney and learn market-leading analytical tools and skills. After 16 weeks,...