Alteryx Joins and its comparison with SQL

Jul 12, 2022 Pooja Srivastava | www.thedataschool.co.uk

Join is used to combine rows from two or more tables based on a related column. In a real-world relational database, data is structured in a large number of tables and which is why, there is a constant need to join these multiple tables based on l...

Español,#ButterflyChart,#GráficodeMariposa

Aggregate vs Non-Aggregate Fields

Jul 12, 2022 Zachary Ryan | www.thedataschool.co.uk

Aggregate vs. Non-Aggregated fields are ones that always trip you up in calculated fields. At least when you’re just starting. Here’s how I’ve started to remember which one is which. I think.

Español,#ButterflyChart,#GráficodeMariposa

The Date Interface Tool in Alteryx

Jul 11, 2022 Marcelo Ramos | www.thedataschool.co.uk

I was doing an Alteryx challenge where you make an App to find how many years, months, weeks, days and hours difference there is between the present and a chosen date. At first I used a Text Box tool as shown:

Introduction to Analytical Apps in Alteryx

Jul 11, 2022 Imogen Emmett | www.thedataschool.co.uk

How to create a basic analytical app in Alteryx.

(Inter)FaceTime

Jul 11, 2022 Ozlem Sigbeku | www.thedataschool.co.uk

Interface tools are daunting. But this introductory guide to action tools, a key interface tool, may help you understand these tools just a little bit better.

How to read in and sort a file using Alteryx interface tools

Jul 11, 2022 Reuben Clayman | www.thedataschool.co.uk

Sorting numeric and date fields in Alteryx using interface tools.

How to make a dynamic sorting APP?

Jul 11, 2022 Longyan Chen | www.thedataschool.co.uk

We did Macro and APP for today’s training and I am going to make a dynamic sorting APP for one of the exercises we had earlier.

How to create a dropdown menu of values in Alteryx APPS

Jul 11, 2022 Joel Akaje-Macauley | www.thedataschool.co.uk

How to create a dropdown menu of values in Alteryx APPS using transformation tools

How to create "Reset Filters" button in Tableau

Jul 11, 2022 Kristine Wiesner | www.thedataschool.co.uk

Most of the times, we create our dashboards with several filters, which we imagined the end-user will be able to select and view the information they want to see.  But as we apply layers and layers of filter, it can become complicated to cancel th...

How I solved Alteryx Challenge #5.

Jul 11, 2022 Sophie Higson | www.thedataschool.co.uk

! SPOILER ALERT ! My take on solving Alteryx challenge #5.

Data School Roundup - July 4-10, 2022

Jul 11, 2022 Andy Kriebel | www.thedataschool.co.uk

In this roundup, the focus is heavy on spatial since we had two full-day training sessions. There was also a bit of Regex and what life is like in the first week of the DS.

Creating paths in Tableau

Jul 11, 2022 Reuben Clayman | www.thedataschool.co.uk

Using storm data to create paths in Tableau

Alteryx 101: Analytical App

Jul 11, 2022 Maha Hussari | www.thedataschool.co.uk

Creating an App in Alteryx - with a beginner walkthrough example.

Four Ways to Perform a Top N in Tableau

Jul 11, 2022 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

As a regular contributor on the Tableau Forums, one of the most common questions I see is how to perform a Top N filter. In addition to the basic how-to questions, I also see many people struggling to get their Top N method to meet the...

DataViz,How-To,Tableau

Spatial Match in Alteryx

Jul 10, 2022 Marcelo Ramos | www.thedataschool.co.uk

With a spatial match, you can create a relationship between two geographical objects. An example of this would be finding points in London city, such as bus stops, that are inside specific London boroughs to then use that for further analysis.

Introduction to RegEx in Alteryx

Jul 10, 2022 Imogen Emmett | www.thedataschool.co.uk

What is RegEx and how is it used in Alteryx?

How do you join spatial files in Tableau?

Jul 9, 2022 Sophie Higson | www.thedataschool.co.uk

Confused when to use a spatial join, how to do it, or what the outcome is? Look no further.

Welcome to the data school: week 1

Jul 8, 2022 Bridget Ama Boateng | www.thedataschool.co.uk

Day 1- Welcome the data school! friendly faces, warm welcomes and meeting my cohort.

Data,cloud,data,datalake,datastreaming,datawarehousing,Snowflake,unstructureddata

Is transparency the new standard?

Jul 8, 2022 Peter Hajnal | www.thedataschool.co.uk

Beside understanding the basics of Alteryx and Tableau Prep, as a newbie, my first week was all about settling in, and getting familiar with the company’s culture. Many new faces, few familiar ones from interviews and Meet & Greets.  One thing...

Data,analytics,BI,BIAdvice,WhatMakesGoodAnalytics

How to: Quadrant charts with sets

Jul 8, 2022 Ben Mangel | www.thedataschool.co.uk

In this post I want to explain how to build a quadrant chart. So what makes a quadrant chart? Imagine you want to know how a specific group of your customers is composed. For example: You are the CEO of the Tableau Superstore and you want to know ...

Data,cloud,data,datalake,datastreaming,datawarehousing,Snowflake,unstructureddata

Applying For The Data School? Don't Get Too Fancy.

Jul 8, 2022 Tristan Kelly | www.thedataschool.co.uk

When working on the initial application, you are undoubtedly going to want to stand out among the crowd. The application can be competitive so this is entirely understandable, but do yourself a favor and avoid the fancy charts! There are many ways...

Data,cloud,data,datalake,datastreaming,datawarehousing,Snowflake,unstructureddata

All Data, All Workloads: The Future of Data Processing with Snowflake

Jul 8, 2022 Chaitanya Joshi | interworks.com

Disclaimer: The author is solely responsible for views and opinions in this article. Snowflake Summit 2022 was a success. Enough has already been written about what came out of it and the exciting new announcements, so I will not be repeating any ...

Data,cloud,data,datalake,datastreaming,datawarehousing,Snowflake,unstructureddata

Week 1: Alteryx or Tableau Prep?

Jul 7, 2022 Gerda Staurylaite | www.thedataschool.co.uk

Starting the Data School and getting into two different programs leaves you with questions. So Alteryx or Tableau Prep?

Data,analytics,BI,BIAdvice,WhatMakesGoodAnalytics

So Far at the Data School

Jul 7, 2022 Zachary Ryan | www.thedataschool.co.uk

The first four days at the Data School for the new kids on the block, DS 33.

Data,analytics,BI,BIAdvice,WhatMakesGoodAnalytics

First impressions on Tableau Prep

Jul 7, 2022 Ana-Casiana Tarita | www.thedataschool.co.uk

Tableau Prep is the perfect tool for data preparation and analyzing. In Tableau Prep you can connect many types of data at the same time and join them together.

Data,analytics,BI,BIAdvice,WhatMakesGoodAnalytics

Filter, action filter, set's, parameter and contextfilter

Jul 7, 2022 Daniel Glasenapp | www.thedataschool.co.uk

Earlier this week I downloaded the dataset“USA_Census_Populated_Places_USA_Census_Populated_Places” downloaded from data.World.

Data,analytics,BI,BIAdvice,WhatMakesGoodAnalytics

Experiencing Week 1

Jul 7, 2022 Sundus Jamaal | www.thedataschool.co.uk

The first week at a new job can be very daunting and overwhelming. However, the information lab eases you into the training and makes it a much smoother transition. Everyone is very welcoming and friendly and your first week is very informative.

Data,analytics,BI,BIAdvice,WhatMakesGoodAnalytics

Alteryx vs Tableau Prep - Joins

Jul 7, 2022 Beau Foletti | www.thedataschool.co.uk

Alteryx and Tableau Prep are two programs designed to prepare data ready for visualisation. After a first look, what is the standout difference between the two?

Data,analytics,BI,BIAdvice,WhatMakesGoodAnalytics

What Makes Good Analytics: Monitoring Your BI Stack

Jul 7, 2022 Sergej Barkar | interworks.com

Monitoring comes up very often with our customers. Even though monitoring is frequently considered very common in other parts of the tech world, usually when software engineering efforts are present, generally less emphasis seems to be put on the ...

Data,analytics,BI,BIAdvice,WhatMakesGoodAnalytics

Can you make a bullet chart?

Jul 7, 2022 Donna Coles | donnacoles.home.blog

Kyle returned this week to set this challenge to create a bullet chart which compared Win % for baseball teams in a year (bar) to the previous year (line), along with call out indicators (red circles) if the difference was greater than a user defi...

How to Make Airline Routes?

Jul 6, 2022 Longyan Chen | www.thedataschool.co.uk

Let’s say we want to build Airline Routes for the airports in the US.

TableauGeneralKnowledge

Discrete vs. Continuous in Tableau (Blue or Green?)

Jul 6, 2022 Ollie Linley | onenumber.biz

Do you know the difference between measures and dimensions in Tableau? How about discrete and continuous fields? These are common points of confusion for Tableau Desktop users. Knowing the difference allows you greater control and customization as...

TableauGeneralKnowledge

Reframing Your Designs: User Centered Dashboard Development

Jul 6, 2022 Kendra Allenspach | interworks.com

User Centered Dashboard Development (or UCDD) is a methodology for approaching analytics product development that combines elements from human centered design, design thinking, system thinking and product management to guide BI development teams t...

Data,Dashboard,development,TC22,UCDD,UserCentered

How to Create a Hexbin Map in Tableau

Jul 5, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this tip, I show you how to create a hexbin map in Tableau. But first, let me explain the purpose, benefits and drawback of a hexbin map.There are countless times when I have been asked to display way too much data on a map. Sometimes I’ve been...

bins,calculatedfield,color,density,geographic,hexagon,hexbin,location,map,mapping,parameter,rank,shape,tableau,tip

What did it take to get into DS32?

Jul 5, 2022 Robbin Vernooij | www.thedataschool.co.uk

S32 is in their first month of training, so it’s a great time to look at what it took for them to get into The Data School and track their progress!

Tableau day by the Zen Master

Jul 5, 2022 Ronaldo Licaj | www.thedataschool.co.uk

Today, was a heavy day in terms of Content but when you have the best teaching you the whole experience is transcending. It is one of these days that you feel like you have gained so much and given so little, happiness. Mr. Andy Kriebel, or better...

Tableau Dimensions and Measures - What Are They?

Jul 5, 2022 Sophie Higson | www.thedataschool.co.uk

Is it important to know the difference between the blue and green fields in Tableau? Yes, extremely.

Summarise Spatial Objects in Alteryx

Jul 5, 2022 Ben Mangel | www.thedataschool.co.uk

Alteryx has a Spatial only tab on it’s interface. But why should you stick to it if there are other tools which can manipulate spatial data too?

Spatials on Alteryx and Tableau

Jul 5, 2022 Heinrich Preuß | www.thedataschool.co.uk

Today we enjoyed the first training with Tableau visionary Andy Kriebel, covering the topic of Spatials in our two favorite tools, Tableau and Alteryx.

Spatial Training

Jul 5, 2022 Kerstin Horscht | www.thedataschool.co.uk

Today we talked about Spatial in Tableau and Alteryx for the first time. In both tools, there are great many ways to analyze the locations, relationships, attributes, and approximations in geospatial data to gain insights using geographic modeling...

Regular Expressions in Alteryx

Jul 5, 2022 Viktoria Von Laer | www.thedataschool.co.uk

Did you ever needed to extract a specific string or number from a bigger string?

How to use parameter action to drill down?

Jul 5, 2022 Longyan Chen | www.thedataschool.co.uk

I would like to build bar chart with a drill down in category and let users to change a parameter value through direct interaction with my Viz by clicking different categories and explore more detail information in sub-category.

Basics in SQL

Jul 5, 2022 Charalambos Pavlou | www.thedataschool.co.uk

SQL Basics

Alteryx Tips: Streamlining workflows with RegEx

Jul 5, 2022 Ben Connor | www.thedataschool.co.uk

A quick overview of why Regex is an important skill to learn for parsing complex strings!

Alertyx Spatial

Jul 5, 2022 Daniel Glasenapp | www.thedataschool.co.uk

In today’s Spatial session, I learned some specifics in Alteryx and Tableau. In this post, I’ll take a look at how to create routes in Alteryx.