Do you want to disable sorting permanently?

Dec 28, 2022 Michael Apau | www.thedataschool.co.uk

Sorting can be done from different spots when a sheet is created. However, after creating a sheet and sorting it based on your task, you may want to deactivate sorting and that can be done by a simple step.

TableauGeneralKnowledge,TableauDates

Cartesian Join. Alteryx 101 - Append Fields Tool.

Dec 28, 2022 Anita Longa | www.thedataschool.co.uk

Append Toll is useful when you want to append values to all rows. This tool performs a Cartesian Join, it means that each row of your dataset will be duplicated enough times to accommodate the new values. Let’s have a look at very simple visualiza...

TableauGeneralKnowledge,TableauDates

Cake Works: Using Data Analytics to Become Data-Driven

Dec 28, 2022 Lyon Abido | www.thedataschool.co.uk

This article will be the start of a four-part series detailing a small hypothetical project involving a company that wants to use historical data to become data-driven and drive business growth.

TableauGeneralKnowledge,TableauDates

Alteryx Preparation Tools (Core)

Dec 28, 2022 Morgan A Rennie | www.thedataschool.co.uk

A run-through and breakdown of the 10 preparation tools required to pass the Alteryx core certification.

TableauGeneralKnowledge,TableauDates

How to Build a Circle Timeline Chart in Tableau

Dec 28, 2022 Eric Parker | onenumber.biz

When it comes to displaying data over time, it’s easy to fall into the trap that you should always use some form of line graph. While line graphs are a great default when displaying chronological data, they aren’t always your best option!

TableauGeneralKnowledge,TableauDates

Intersects Spatial Function

Dec 28, 2022 datavis.blog | datavis.blog

The new INTERSECTS() spatial function, introduced in 2022.4, makes it possible to determine if two spatial objects overlap without needing to perform a spatial join. This post walks through a few examples with points, polygons (buffers) and lines.

Spatial,Intersects,Tableau

XML parse tool in Alteryx

Dec 27, 2022 Stanley Chan | www.thedataschool.co.uk

In the previous blog, I discussed what XML is and its basic structure. Today I am going to talk about how to use the XML parse tool to put the information wrapped by specific tags into columns. Please make sure you are familiar with the terminolog...

Passion Talks: Naps

Dec 27, 2022 Erlina Cahyadi | www.thedataschool.co.uk

Here at The Data School New York, we have something called Passion Talks. It’s an activity invented by Ann Jackson, DSNY’s personal head coach, designed to lift spirits when we are low on energy, provide a platform where we can share interests and...

How to add custom shapes to your charts

Dec 27, 2022 Eugenia Losada Gamst | www.thedataschool.co.uk

When originally applying to the data school i looked at previous applications and what it too to get in. Many of these had a lot of customization down to the smallest detail, and I found that really cool.

Approaching #MOM in the most efficient way

Dec 27, 2022 Eugenia Losada Gamst | www.thedataschool.co.uk

Every week Andy posts a new Make over Monday (#MOM), and every week instead of approaching the challenge in the most effective ant time efficient way I jump straight into the data and start dragging fields onto the canvas in hopes something will l...

The Alteryx Multithreading Engine

Dec 24, 2022 Frederik Egervari | www.thedataschool.co.uk

The AMP (Alteryx Multithreaded Processing) Engine is a feature in Alteryx that enables Workflow to be executed faster. This is done by using multiple threads at the same time to process the data.

Wildcards in the Data Input tool in Alteryx

Dec 23, 2022 Jack Arnaud | www.thedataschool.co.uk

Data input is one of the first tools used in Alteryx by any beginner. Dragging and dropping an excel file into the canvas, or selecting a data source from the file explorer, is often sufficient for the user to get started on any analysis they want...

Using Highlighters in Bump charts.

Dec 23, 2022 Michael Apau | www.thedataschool.co.uk

In my last blog my bump chart looked incomplete since I had not placed my dimensions which were countries on colour. In instances where we want to stick to one colour for all the countries, we can use highlighters to show the trend for each countr...

Tableau filters (for dummies)

Dec 23, 2022 Jack Arnaud | www.thedataschool.co.uk

Early on in your Tableau journey, you may have mastered dragging fields into the columns and rows shelfs. As you find yourself facing a myriad of new charts, you may ask yourself, “How can I only show part of a field?”. For this, we’ll need a filt...

Set Actions

Dec 23, 2022 Tara Robinson | www.thedataschool.co.uk

This blog is going to look at what a set action is and an example of when you might use it

Select Records on Alteryx

Dec 23, 2022 Jack Arnaud | www.thedataschool.co.uk

Using Alteryx inevitably leads to troubleshooting and problem-solving, no matter your skill level. Often you’ll want to examine a known set of rows quickly and without constructing a filter, to see if the content matches your expectation. To that ...

SQL 101: The Basic Functions

Dec 23, 2022 Shahbaz Khan | www.thedataschool.co.uk

SQL, or Structured Query Language, is a programming language used to manage and manipulate data stored in relational database management systems (RDBMS). It is the standard language for interacting with databases and is used by a wide range of app...

Quick Table Calculations Part 1 - Running Totals

Dec 23, 2022 Serena Purslow | www.thedataschool.co.uk

I’m starting a new series on table calculations in Tableau. Join me as I go through creating a Running Total quick table calculation.

Parameter Actions

Dec 23, 2022 Tara Robinson | www.thedataschool.co.uk

This blog looks at an example of a parameter action and how to recreate this.

Introduction of XML

Dec 23, 2022 Stanley Chan | www.thedataschool.co.uk

Yesterday I was doing Alteryx weekly challenge #37, which required me to parse the XML formatted text. Obviously, it demands the usage of the XML parse tool, which I have never tried before! Good chance to learn it. But I don’t even know what XML ...

How to unable highlighting on tableau

Dec 23, 2022 Eugenia Losada Gamst | www.thedataschool.co.uk

When making my final dashboard look nice, I kept getting really annoyed with the highlighting actions tableau comes with automatically set, so after a decent amount of tableau exploring, I found a way do disable throughout.

How to move dimension Labels from Bottom to the Top

Dec 23, 2022 Michael Apau | www.thedataschool.co.uk

Have you ever been in a situation where your view has dimension labels at the bottom but you preferred it at the top? Its simple in just 3 steps.

How to make a radial bar chart

Dec 23, 2022 Archie Boswell | www.thedataschool.co.uk

Step-by-step guide to make a radial bar chart.

How to build a dynamic control chart in Tableau

Dec 23, 2022 Edward Gay | www.thedataschool.co.uk

The control chart is used to study how a process changes over time and allows us to identify any significant outliers in our data. Here is a guide on how to build a dynamic control chart in Tableau.

How to Show All Empty Value Headers in a Discrete Dimension When Filteri...

Dec 23, 2022 Stephen Moyse | www.thedataschool.co.uk

How to Show All Empty Value Headers in a Discrete Dimension When Filtering in Tableau

How To Take off the 0's from the Rank Axis

Dec 23, 2022 Michael Apau | www.thedataschool.co.uk

Ranking dimensions is a common practice. When using ranks, we tend to have a zero in it. You are ‘safe’ when you want to hide your axis but what if you must show that axis? Good news is that these zeros can be taken off in two simple ways.

How To Create a 45 degree line for a Scatter Plot

Dec 23, 2022 Michael Apau | www.thedataschool.co.uk

In the creation of a scatter plot, we sometimes desire to create a 45 degree line instead of using our usual trend lines for the analysis. In this blog, I will show how that can be done.

Drilldown set action and parameter actions

Dec 23, 2022 Tara Robinson | www.thedataschool.co.uk

This blog is going to show two different ways on how you can do a drilldown using either set actions or parameter actions.

Did you know about the new PROPER string function in 2022.4?

Dec 23, 2022 Michael Apau | www.thedataschool.co.uk

Tableau 2022.4 has introduced a new string function called PROPER which allows us to convert our text string to proper title casing by capitalizing the first letter of each word while lower casing all other letters.

Alteryx Fundamentals: Input/ Output Data Tool

Dec 23, 2022 Anita Longa | www.thedataschool.co.uk

Input Data Tool

A Beginners Guide to Writing Calculations

Dec 23, 2022 Curtis Paterson | www.thedataschool.co.uk

If you’re like me and didn’t have any experience writing calculations before joining The Data School, I’m sure you’re used to seeing errors and red squiggly lines. This is a beginner’s guide to writing calculations, whether it’s creating calculate...

Let’s show quarterly sales with end-user flexibility

Dec 23, 2022 Donna Coles | donnacoles.home.blog

It was Sean’s final #WOW2022 challenge of the year, and he set this task to provide alternative options for visualising time series across dimensions with high cardinality. I had a play with Sean’s viz before I started tackling the challenge and n...

How to Calculate Customer Churn Rate in Tableau

Dec 22, 2022 VizWiz (noreply@blogger.com) | www.vizwiz.com

In this tip, I’m show you how to calculate the 3-month and 6-month churn rate in Tableau. To calculate churn rate, all you need to do is:1. Create 4 calculations2. Follow the 8 simple steps to build the viewCustomer churn rate is the % of customer...

analysis,calculatedfield,change,churnrate,customerchurnrate,howto,percentage,retention,tableau,tip,variance

#Throwback Thursday - Week 7 at The Data School

Dec 22, 2022 Serena Purslow | www.thedataschool.co.uk

Read my weekly reflection on life at the Data School, in the run up to Christmas.

How to Create an Interactive Reference Line

Dec 22, 2022 Curtis Paterson | www.thedataschool.co.uk

Tableau allows us to create reference lines, bands, distributions and box plots on our continuous axes in order to help highlight certain areas of our data. These features can be especially useful when we combine them with calculated fields and ac...

Year in Review / Top 10 Blog Posts of 2022

Dec 22, 2022 Austin Meyer | playfairdata.com

What an exciting year 2022 has been! As we reflect on our top 10 blog posts, it’s difficult not to…The post Year in Review / Top 10 Blog Posts of 2022 appeared first on Playfair Data.

Announcements,Tips&Tricks

Publishing workbooks to Tableau Server through Alteryx

Dec 21, 2022 Finn Charlton | www.thedataschool.co.uk

Alteryx and Tableau have a fantastic working relationship, with easy integration in a lot of cases. Alteryx can also work well with Tableau server, where through the Tableau Server API users can perform many tasks. One task that is not so simple, ...

TableauCalculations

High Cardinality vs Low Cardinality

Dec 21, 2022 Eamonn Woodham | www.thedataschool.co.uk

When talking about data, the cardinality of a column refers to the number of distinct values that the column can take on. A column with high cardinality has a large number of distinct values, while a column with low cardinality has a small number ...

Data,CRON,python,Snowflake,UDF

Choosing colors for your dashboard

Dec 21, 2022 Boglarka Lipka | www.thedataschool.co.uk

Color psychology is the study of how different colors affect our behavior, emotions, and decision-making. It is a branch of psychology that investigates the psychological effects of color on humans and is used in fields such as marketing, design, ...

Data,CRON,python,Snowflake,UDF

Why Aggregations Are Important in Tableau Calculations

Dec 21, 2022 Eric Parker | onenumber.biz

Aggregations are functions which allow you to consolidate numerous rows of values into a single output. SUM, AVG, MIN, MAX, COUNT and COUNTD are some of the most used aggregations in Tableau.

TableauCalculations

InterWorks Causes: Food Insecurity in Oklahoma

Dec 21, 2022 Robby White | interworks.com

Giving back is a major component of the InterWorks philosophy. Being deliberate and encouraging employees to spend time in the community to help organizations and causes they are passionate about is equally important as growing our business. Above...

Culture,Oklahoma,philanthropy,Service,volunteering

Text and titles in Tableau dashboards and visualizations

Dec 20, 2022 Elena Raluca Mazareanu | www.thedataschool.co.uk

The main goal of data visualizations is to accurately and efficiently convey information but why do data visualizations require texts and titles? The text makes a difference in conveying your observations, helps you to describe how to interpret a ...

Data,CRON,python,Snowflake,UDF

Preparation for the Alteryx Core Certification - What do the tools do?

Dec 20, 2022 Kate Joyce | www.thedataschool.co.uk

Today, DS37 did some preparation for the Alteryx Core Certification. We were tasked with making a presentation of some of the tools we will be asked about. What do they do?

Data,CRON,python,Snowflake,UDF

How to use the Text Input tool in Alteryx

Dec 20, 2022 Kaitlin MacDonnell | www.thedataschool.co.uk

Text input is a useful tool for experimenting with different tools using a small data sets. The data input from the Text Input tool saves within the workflow, so you can share the workflow without having to provide an input data file.

Data,CRON,python,Snowflake,UDF

How to make a Reset Filters button in Tableau

Dec 20, 2022 Edward Gay | www.thedataschool.co.uk

Sometimes in dashboards you may end up having too many filters on and a reset button can be useful to revert your dashboard back to it’s original state. Here’s a guide on how to create a reset filters button in Tableau.

Data,CRON,python,Snowflake,UDF