Making a Candlestick Chart

Sep 4, 2024 Kealan Daly | www.thedataschool.co.uk

A candlestick chart can be a useful way of displaying two values side-by-side while comparing their difference. Making them in Tableau requires some trickery involving measure names and measure values. In this post I will use the Superstore sample...

From databases to data lakehouses

Sep 4, 2024 Maria Maske | www.thedataschool.co.uk

Welcome to my first blog post as a Data School Consultant. The aim of these blog posts is to help us reflect on what we have learned and experienced over the weeks. In our first week at the begginning of august, we have already learned many exciti...

Authentic Empathy at Work

Sep 4, 2024 Liz Boika | www.thedataschool.co.uk

Getting What You Want and Being Nice While Doing It

Alteryx vs. Tableau Prep

Sep 4, 2024 Liz Boika | www.thedataschool.co.uk

Getting the Most Out of Your Data Preparation Tools

10 Questions To Prepare for the Tableau Data Analyst Certification

Sep 4, 2024 Ollie Linley | onenumber.biz

Tableau’s Data Analyst Certification can be a tricky one to prep for.

Certification

InterWorks Blog Roundup August 2024

Sep 4, 2024 Mark Cordeiro | interworks.com

Welcome, dear readers, to the August 2024 Blog Roundup. Up here in the Northern Hemisphere, kids are back and school and the heat of the summer has finally broken. Fall’s on the horizon (until Indian Summer shows up in a week or two and we’re…The ...

Data

Tableaus Order of Operations Context Filters

Sep 3, 2024 Thomas Duong | www.thedataschool.co.uk

Recently, I was working with a dataset on top football league scorers and ran into an interesting challenge. I wanted to analyse which players scored the most goals in a given year.

Tableau Server Version Control

Sep 3, 2024 Jules Claeys | www.thedataschool.co.uk

When working on any project, the ability to revert back to a previous instance is essential. Since Server version 9.3, version control exists on tableau server and permits the user to view or download previous editions of a workbook.

Order of Operations and Order of Execution in SQL

Sep 3, 2024 Le Luu | www.thedataschool.co.uk

In Tableau, there is a table of the order of operation which tells the users the execution order in Tableau. The users will decide when to apply the filter based on that table. In SQL, the users usually apply some SQL clauses to write the query to...

How to Use MIN_BY MAX_BY in Snowflake

Sep 3, 2024 Sripriya Vemula | interworks.com

If you are familiar with SQL, you would be familiar with the concept of aggregate functions. For those who are still a bit fuzzy on what these aggregate functions intend to do, here’s a quick couple of quick examples: When you want to find the…The...

Data,Snowflake

A Walk Through My Process of Building 4 Makeover Monday Dashboards

Sep 3, 2024 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

     I started the 2024 year by getting involved with Makeover Monday. Makeover Monday is an incredible project that has given so much to our community. In 2025, Makeover Monday was relaunched with three incredible new leaders (Irene D...

Tableau

How to Create a WinLoss Sparkline

Aug 30, 2024 VizWiz (noreply@blogger.com) | www.vizwiz.com

A win/loss sparkline is a tiny, horizontal chart that visually represents a series of binary outcomes, typically wins and losses. It’s often used in sports, sales, or any context where success or failure can be quantified.How it works:1. Simple re...

binary,boolean,howto,loss,profit,sign,sparkbars,sparkline,tableau,tip,trends,tutorial,win,winlosssparkline

Modularizing SQL using dbt

Aug 30, 2024 Edward Hayter | www.thedataschool.co.uk

The following blog introduces the principles of modularization in software engineering more generally before focusing on how these principles can be applied to SQL with the help of dbt.

Alteryx vs. Tableau Prep

Aug 30, 2024 Liz Boika | www.thedataschool.co.uk

Getting the Most Out of Your Data Preparation Tools

Tableau to Inbox

Aug 29, 2024 Jules Claeys | www.thedataschool.co.uk

Using tableau dashboard actions it is possible to prepare an email, fully ready to send in two clicks. This is thanks to the mailto: links. These links are just URLS which open your default email application and starts sending an email. If you wan...

Design For Non-Designers

Aug 29, 2024 Liz Boika | www.thedataschool.co.uk

Part 1: The Basics

A Plot to Learn

Aug 29, 2024 Vivian Ng | www.thedataschool.co.uk

…a dot strip plot, that is!

Hello Data

Aug 28, 2024 Marcus Oberdiek | www.thedataschool.co.uk

Whew, here we go. My first blog entry on my journey to become a Data School Consultant . I have been waiting with great anticipation for the day that it finally starts. Another new chapter in my life.

3 Ways to Fix Null Values

Aug 28, 2024 Nick Cassara | playfairdata.com

Have you ever experienced this situation or a similar one? You are working with your data, building out some sort…The post 3 Ways to Fix Null Values appeared first on Playfair Data.

Alteryx,DataPrep,Fundamentals,TipsTricks

Understanding SQL Flavors Why Different SQL Dialects Exist and Their Imp...

Aug 27, 2024 Jessica Kwan | www.thedataschool.co.uk

As mentioned in my previous blog, SQL provides a common foundation established by ISO and ANSI standards. However, over the years, various organizations have developed their own database management systems to address specific needs or offer additi...

Data,DPC,Matillion

Concurrency with Unlimited Scale in Matillions Data Productivity Cloud

Aug 27, 2024 Fadi Al Rayes | interworks.com

Ever found yourself stuck in development limbo, waiting for a job to finish, only to realize you might need to tweak it again? It’s one of the less enjoyable parts of being a data engineer. But what if I told you there’s a way to…The post Concurre...

Data,DPC,Matillion

Logical Functions in Tableau

Aug 26, 2024 Thomas Duong | www.thedataschool.co.uk

Logical functions in Tableau enable conditional evaluations to create calculated fields that return specific values based on defined criteria. In this post, I will explore functions such as IF, ELSEIF, IIF, OR, AND, ZN, IFNULL, ISNULL, IN, CASE an...

Data,AI,leadership,Thunder

Being the Exception

Aug 26, 2024 Ben Bausili | interworks.com

“If you want an exceptional outcome, you must be willing to be the exception.” wrote Sam Presti, the General Manager of the Oklahoma City Thunder. It was the summer of 2019 in an article penned to fans after trading away franchise cornerstones Rus...

Data,AI,leadership,Thunder

Refreshing My SQL Skills A Journey Through the Fundamentals

Aug 23, 2024 Jessica Kwan | www.thedataschool.co.uk

As part of my personal development, I recently decided to take a refresher on SQL by testing out a Datacamp subscription. The Associate Data Analyst in SQL track, Associate Data Engineer in SQL track , and SQL fundamentals all start with an Introd...

Dashboard Design Tips

Aug 23, 2024 Joe O'Connor | www.thedataschool.co.uk

Things to consider when designing a dashboard.

WOW2023 Week 42 Proportional Brushing with Multi-Selection

Aug 22, 2024 Kate Crawford | www.thedataschool.co.uk

This Workout Wednesday was created by Kyle Yetter to practice multi-selection features. Similar to Kyle, I have worked on projects where the client wants to engage with a combination of fields to gain insights to a specific customer segment. Propo...

ChartTypes,Design,Figma,Intermediate

Statsbomb Event data JSON GitHub Alteryx

Aug 22, 2024 Tom Gould | www.thedataschool.co.uk

Leading football data provider Statsbomb periodically release free data to the public for football fans to dive in to and use for their own analysis and personal projects. Free data releases are often related to recent tournaments, for example 202...

ChartTypes,Design,Figma,Intermediate

Sorting Stacked Bar Charts Using Set Actions.

Aug 22, 2024 Michael Apau | www.thedataschool.co.uk

In this write up, I showed how to sort stacked bar charts using parameter action. I did this because I could not wrap my head around sets and set actions at the time so parameters were always my go to.

ChartTypes,Design,Figma,Intermediate

Feeding Daily Air Quality Data from an API to Tableau Pulse

Aug 22, 2024 Salome Grasland | www.thedataschool.co.uk

In this blog post, I’ll walk you through the process of creating an air quality indicator using data from the EPA API, cleaning it in Tableau Prep, and visualizing the results in Tableau Pulse. 

ChartTypes,Design,Figma,Intermediate

DS Introduction to Power BI

Aug 22, 2024 Rory Moxom | www.thedataschool.co.uk

Week 3 Day 2 of The Data School was our first introduction as a cohort to Power BI. Fortunately I have had some basic experience with Power BI which certainly helped, but there were some cool tips and tricks that I’d never come across before!

ChartTypes,Design,Figma,Intermediate

Using Table Calculations for Threshold Analysis.

Aug 21, 2024 Michael Apau | www.thedataschool.co.uk

I recently bumped into a tableau problem which explicitly needed to use Table Calculations in answering these three questions using Superstore data.

TableauDates

Use Cases for Dynamic Zone Visibility in Tableau

Aug 21, 2024 Kate Crawford | www.thedataschool.co.uk

What is DZV?

TableauDates

Connecting dbt to Microsoft SQL Server

Aug 21, 2024 Edward Hayter | www.thedataschool.co.uk

Introduction

TableauDates

Custom Date Filter for Aggregated and Non-Aggregated Measures in Tableau

Aug 21, 2024 Eric Parker | onenumber.biz

Creating custom date filters in Tableau takes some creativity and ingenuity. They can be especially tricky when they are used to control both aggregated and non-aggregated measures. Tableau is particular about how aggregated formulas are written.

TableauDates

Using Table Calculation to find a point on a Pareto Chart.

Aug 20, 2024 Michael Apau | www.thedataschool.co.uk

I recently created a Pareto chart and in the requirements, I had to indicate the 80% threshold of sales so that the user could trace it to the percentage of products which constituted that sales. I found table calculations handy in doing this and ...

Data,DPC,Matillion

Designing and Building a Basic Dashboard

Aug 20, 2024 Joe O'Connor | www.thedataschool.co.uk

Looking at the process of designing and preparing data, and building a basic dashboard.

Data,DPC,Matillion

An Introduction to PowerQuery

Aug 20, 2024 Kealan Daly | www.thedataschool.co.uk

Today we had our first introduction to Power BI. Although on the surface it can be quite intimidating to learn a new piece of software, most of the same principles of data preparation you would find in other pieces of software are included here (a...

Data,DPC,Matillion

Demystifying Variables in Matillion DPC

Aug 20, 2024 Steve Taylor | interworks.com

Variables are a fundamental part of all programming languages, giving developers a flexible object in which they can store, update and retrieve data. What makes them extra useful in DPC is that the value of a variable can be set and updated using ...

Data,DPC,Matillion

Numerical Functions in Tableau

Aug 19, 2024 Kealan Daly | www.thedataschool.co.uk

Today we learned about calling functions under a variety of categories, namely string functions, logical functions, numerical functions and datetime functions. In this blog I will walk through some common numerical functions that may prove useful ...

Date Calculations in Tableau

Aug 19, 2024 Georgia Webb | www.thedataschool.co.uk

Tableau has lots of useful calculations for date fields, here are a few:

Data School Week 1 Star Schemas

Aug 19, 2024 Georgia Webb | www.thedataschool.co.uk

Star schemas are one of the primary types of data warehouse schemas. 

Calculations and Functions

Aug 19, 2024 Joe O'Connor | www.thedataschool.co.uk

What are calculations and functions and why do we use them in data visualisation software like Tableau?

A Guide to Measure Names and Measure Values

Aug 19, 2024 Kate Crawford | www.thedataschool.co.uk

Knowing the difference between measure names and measure values is helpful to making more complex charts in Tableau. The Data pane generates these fields, which can be used in different ways:

Understanding INCLUDE and EXCLUDE LODs

Aug 19, 2024 Ken Flerlage (noreply@blogger.com) | www.flerlagetwins.com

 There are many articles, communityforums, blog posts, videos, etc. on Tableau’s level of detail expressions(LODs). In fact, Ken wrote a great one sharing 20uses for LOD calcs. But most of the content is focusedon the most common one, FIXED, even ...

How-To,Tableau

Using Sets in Tableau

Aug 17, 2024 Thomas Duong | www.thedataschool.co.uk

Sets in Tableau are super handy when you want your analysis to stay dynamic and up-to-date. Unlike groups, which are fixed and don’t change once you create them, sets can automatically adjust based on the latest data.