The Data School Blog
I Recreated and Enhanced the Pearson Correlation Tool in Alteryx
Recently I had a project where the client wanted to know if there was correlation between many fields in their data set. It was survey data and every row had some NULL values or zeros which meant there was no data rather than the answer to that question was 0. In...
read more
Macro and Analytical App Basics
INTRODUCTION For this blog, I wanted to focus on a topic that I am perhaps not so confident with: Macros and Analytic Apps. I will give an example of each to further my knowledge and the readers. MACROS The premise behind macros is to save time. By this, I mean that...
read more
Everything Table Calculations
INTRO In this blog, I will be describing all things to do with Table Calculations. The pretence behind this blog is to help with a teaching session I will give soon about Table Calculations. So, what are Table Calculations? Directly from Tableau help, “Table...
read more
I Created an HTML/XML Parser Tool in Alteryx Using Python SDK
During the training at The Data School we had many projects which involved scraping websites. Although there are ways to scrape websites in Alteryx, I always missed to have a tool dedicated to the task. In this post I will show how I created a brand new Alteryx tool...
read more
Beta Buffering in Tableau 2020.1
Watch this Spatial! Tableau is constantly adding new features with every update. As a beta member, was able to play around with the new buffer calculation in the 2020.1 release. In the Data School we have learnt how to use spatial tools in Alteryx to create trade...
read more
LOD – Fixed, Include, and Exclude
Level of Detail (LOD) For this blog post, I thought I would write about the difference between different levels of detail (LOD). I wanted to do it in as few words as possible as a lot of websites give lengthy explanations and I think the end result is confusion and...
read more
The Normal Distribution and Z Scores
Introduction to Stats A couple of weeks ago in our training at the Data School, we had some lessons on Predictive analysis. The topic of Standard deviations and normal distributions came up, coming from a statistics background I really enjoyed it. But a lot of the...
read more
Keyboard Shortcuts in Tableau
Recently I hit the G key by accident on Tableau, to my surprise something happened, gridlines appeared on my screen. This got me thinking what are the Tableau Keyboard shortcuts that people do not know about, and more importantly which are the ones you should know....
read more
The Alteryx Summarize Tool – More Than Just Summarize
During last week’s client project, I had the chance to work with Alteryx to solve some survey data problems. One thing that I learned was the summarize tool is very useful to check results, especially making sure joins are correctly performed. Taking the...
read more
Quick Tip: Missing Time Series Data
"Lost time is never found again." – Benjamin Franklin. So said the man on the US $100 bill. Fortunately, a lot has changed since the 18th century, including the ability to find lost time in time series data. In the first of my new quick tip series, we'll look at how...
read more