Tableau Aggregator

Kirk Munroe: 4 Common Tableau Data Model Problems…and How to Fix Them

Jan 3, 2023 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

Kevin and I are happy to have Kirk Munroe join us for the first in a series about data modeling with Tableau. Kirk lives in Halifax, Nova Scotia, Canada and is a business analytics and performance management expert. He has held leadership roles in...

How-To,Series-DataModeling,Tableau,TableauPrep

SQL Clauses

Jan 2, 2023 Tara Robinson | www.thedataschool.co.uk

Previously I wrote a bl0g on the main operation order for SQL. This was a walkthrough of the basic operations needed. This blog will be looking more at clauses that may help with more advanced problems.

Intro to Dynamic Zone Visibility in Tableau (The Easy Way) - Part 1

Jan 2, 2023 Kate Joyce | www.thedataschool.co.uk

In this blog I will go through a beginners guide to what dynamic zone visibility is and how to use it.

Building the Paramount+ Dashboard

Jan 2, 2023 Morgan A Rennie | www.thedataschool.co.uk

A build log exploring the process behind building a Paramount+ dashboard over the Christmas period - utilising hand-drawn plans, Alteryx workflows, custom colour palettes, and Tableau.

Tableau Calculations: How do they work?

Jan 1, 2023 Shahbaz Khan | www.thedataschool.co.uk

In this blog we are going to talk about the 3 different types of calculations in tableau what they are and how you can go about using them. So what are the 3 types of calculations:

Making Hexbin density maps in Tableau

Dec 31, 2022 Ross Killington | www.thedataschool.co.uk

In this blog I will be teaching you step by step how to produce the following Hexbin map using data for rat sightings in New York:

remember to have FUN in Tableau!

Dec 30, 2022 Bianca Ng | www.thedataschool.co.uk

As 2022 comes to an end, I’d like to end with a blog post reflecting on how I’ve gotten here.

Spatial,Intersects,Tableau

Web scraping in Alteryx

Dec 30, 2022 Lucas Krokatsis | www.thedataschool.co.uk

Web scraping is a useful technique for extracting data from websites in an automated fashion. It can be particularly useful for businesses that need to gather large amounts of data from websites for analysis and decision making. However, web scrap...

Spatial,Intersects,Tableau

Understanding Attribute in Tableau

Dec 30, 2022 Diaraye Barry | www.thedataschool.co.uk

Attribute function is a type of aggregation in Tableau that works on dimensions fields. It works by returning a value for an expression if it only has a single value for all the rows in the group (excluding nulls). If there are multiple values in ...

Spatial,Intersects,Tableau

The Art of Presenting

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

Here at the Data School we are trained as Tableau and Alteryx Consultants, and when we come out of training we are not only experienced with both tools but also consultants in our own rights as we have picked up a lot of skills that help our consu...

Spatial,Intersects,Tableau

Tableau Table Calculation

Dec 30, 2022 Diaraye Barry | www.thedataschool.co.uk

Tableau’s definition of a table calculation: ‘A table calculation is a transformation you apply to the values in a visualisation’. A table calculation is a calculation that is applied to aggregated measure.

Spatial,Intersects,Tableau

Preparing for PM Week

Dec 30, 2022 Elaine Yuan | www.thedataschool.co.uk

Next week is my week to serve as project manager (PM) and I am excited (and a little bit nervous)! I have been looking forward to being a PM since the mock client project with Tom Nook. I had many ideas to organize the client project, especially a...

Spatial,Intersects,Tableau

Intro to Tableau Date Functions

Dec 30, 2022 Diaraye Barry | www.thedataschool.co.uk

In this blog, we are going to be covering the 5 most common Tableau date functions: 2022-12-30PART, 2022-12-30NAME, 2022-12-30TRUNC, 2022-12-30ADD and 2022-12-30DIFF.

Spatial,Intersects,Tableau

How to use country shapes as Contextual Numbers

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

How to make the shape of a country a contextual number.

Spatial,Intersects,Tableau

How to Automatically Deselect In Tableau - Stopping That Blue Highlight ...

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

Here’s How to Stop That Blue Highlight Effect Upon Mark Selection

Spatial,Intersects,Tableau

Football Radar charts

Dec 30, 2022 Lucas Krokatsis | www.thedataschool.co.uk

If you’re a fan of football you have probably come across radar charts in some shape or form. They are a very popular method of visualising multiple data points in one easy manner for quick comparison. They’ve made their way onto FIFA and football...

Spatial,Intersects,Tableau

Containers Part 2

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

So in my last blog about containers I promised I would do a second part which shows a demonstration on how to use them through using gifs to show i created this.

Spatial,Intersects,Tableau

Can you create a waffle chart?

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

Kyle Yetter ended the #WOW2022 year with this challenge, to create a waffle chart. I haven’t built one for a while, so needed a quick google to refresh my memory. You’ll need a ‘template’ data source which defines the grid pattern layout, and what...

Url to show Image in Tableau

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

Sometimes data contains URL’s which might link to an image or a website. For this we can add an action to our dashboards or even workbooks so that when you select a URL it displays the image (or website).

SQL order of operation

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

Below shows the order of operation for SQL. I will go through each of these with an example so you can see what the results are from doing this. This is in Snowflake. SELECT FROM WHERE GROUP BY HAVING ORDER BY

How to Make a Trellis Chart/Small Multiples

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

A Trellis Chart or Small Multiple charts in Tableau are a great way of showing trends across different subsets of a dataset, and here’s how you make it:

Creating a Custom Categorical Colour Palette in Tableau

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

A guide on how to create a custom categorical colour palette in Tableau.

Containers 101: Horizontal and Vertical Containers

Dec 29, 2022 Elaine Yuan | www.thedataschool.co.uk

I wish I knew about layout containers sooner to organize my dashboards. It’s embarrassing to admit, but I used a translucent ruler in designing my first application visualization. Once I found the Layout pane in the sidebar, I carefully dragged ea...

Colour Theory and Formats

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

A guide to colour theory, including a discussion on the important aspects to consider when designing a dashboard. This post also includes a breakdown of the colour models that Tableau uses to convey different colours.

Changing the Animation Speed Within Tableau

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

Have you ever disliked the way animations in Tableau instantly changes the view, almost jump-scaring the person looking at your viz?

An Introduction to Data Architecture

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

Data architecture is a term used to cover both the policies, rules, standards, and models that govern data collection and how data is stored, managed, processed and used within an organization. It sets the blueprint for data and the way it flows t...

Alteryx Weekly Challenge - 296

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

In preparation for my Alteryx Core Credential, I have completed a series of Alteryx weekly challenges. I figured the best way to test my knowledge is to create a beginner-friendly guide to completing Alteryx Weekly Challenge 296.

Add a label above every horizontal bar in Tableau

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

Hi, today I would like to share a trick I learned, which is to add a label above every horizontal bar in Tableau.

A Step by Step Guide to an Alteryx Challenge

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

In preparation for my second attempt at the Alteryx Core Certification tomorrow I have been working through Alteryx challenges. On the Alteryx community page, there are useful ‘Labels’ for the list of weekly challenges, so you can filter by diffic...

The basics of regex

Dec 28, 2022 Lucas Krokatsis | www.thedataschool.co.uk

Given that I have an upcoming learn what the Dataschool learns session in which I need to design a lesson teaching web scraping in Alteryx, I needed to learn some basics of regex in order to do this so I thought it would be worthwhile to write a b...