Blog - The Data School Australia

Fuzzy Match

by Alice Rooney | Jan 23, 2019 | 0 Comments

The Fuzzy Match tool is a handy tool for matching of non-identical values. There are two different modes that the tool can perform in; Purge, which is used for a single file and compares all records and, Merge, which compares records of different sources. Steps to...

How to create a bikini chart (Population Pyramid) in Tableau

by Alekh Srivastava | Jan 20, 2019 | 0 Comments

Here are the steps to make a bikini chart (or population pyramid) for Age-Sex population. There is an extra section for adding a mark to compare which gender has the higher number in each age bracket. Steps Place Age in rows and Female on columns. Place Male just...

How To Use Level Of Detail in Tableau: INCLUDE Function

by Pris Lam | Jan 20, 2019 | 0 Comments

This blog is part of the How To Use Level of Detail blog series. Today’s blog will cover the INCLUDE Level of Detail expression and function. The INCLUDE level of detail expression calculates the specified Dimension/s in your syntax in addition to the dimensions...

5 Tips when Adding Colours in Tableau

by Blake Stroh | Jan 20, 2019 | 0 Comments

Here’s a list of the top 5 tips involving adding colour to charts in Tableau. It's not about choosing the actual colours, but the process to get nice meaningful colouring in to your viz. Using these quick techniques will allow for a lot more flexibility with colouring...

How To Use Level Of Detail in Tableau: LODs In General

by Pris Lam | Jan 20, 2019 | 0 Comments

What is a Level of Detail and how do I use them? Released in Tableau 9.0, LODs Expressions can be a daunting topic to wrap your head around - especially if you don't come from a maths or SQL background. Over the next blogs I will explain what are LODs, the difference...

Union tool – To blend different sources of data in Alteryx

by Atule Sheorn | Jan 20, 2019 | 0 Comments

The Union tool appends two or more datasets with similar structures and gives a file with all the information of both datasets together. For the scenarios, where we need to combine two different inputs, UNION tool comes in handy. With huge datasets sometimes its a...

How to create a Custom dates in Tableau?

by Harshita Yejella | Jan 19, 2019 | 0 Comments

In this blog, I will take through how to create custom dates for yearly, monthly, quarterly, Weekly, Daily, Last month, Last week Yesterday. Step 1 – Create Parameters for Date Range: Create a parameter with a data type of string and create list for the above...

How to understand the process of creating a macro?

by Neal Wang | Jan 16, 2019 | 0 Comments

How to understand the process of building a macro? When I first learn macro, my biggest challenge is understanding the principle of macro. I knew that the aim of macro is to generalise a workflow so that it can work on any input as long as the input matches the input...

Alteryx Macro Input Tool

by Neal Wang | Jan 15, 2019 | 0 Comments

Alteryx Macro is a tool which isolates a alteryx workflow and packs in one tool. By definition, a Macro Workflow is a workflow that has the flexibility to be run as a single tool within another workflow. Macros save with an *.yxmc extension. Macro Input In a normal...

How Include/Fixed/Exclude Tableau LOD expressions are calculated

by Alekh Srivastava | Jan 14, 2019 | 0 Comments

Want to know what's going on behind the scenes when using LOD fields? This guide will breakdown the differences between how include, fixed and exclude and how they are calculated Calculated LOD fields: {Include [Player] : AVG([Score])} {Fixed [Player] : AVG([Score])}...