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.

How to Build a Dumbell Chart

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

Ever wondered how to build a dumbbell chart? Dumbbell charts effectively highlight differences between two data points across multiple categories, making it easier to visualise changes and compare values in a clear, concise format. On top of that ...

Dashboard Design - Fundamental Dos and Donts

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

Creating a Tableau dashboard that’s both effective and easy to use is all about smart design choices. You want your dashboard to not only display data but also make it easy for users to understand and interact with it. Here are some key things I h...

Zoom In Quadrant on Tableau Desktop Mastering the Scatterplot

Aug 16, 2024 Thiago Santos | www.thedataschool.co.uk

Scatterplots are a powerful tool for visualising the relationship between two variables. They’re particularly useful when you want to compare measures and uncover patterns or correlations. But what happens when your scatterplot is overcrowded with...

What Beyonce and Sandwiches taught me about Data Ecosystems

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

Like most beyhive in tech, I often find myself “right-click inspecting” code on beyonce.com. Instead of looking for a tour page this time, I went to the HTML header to find potential data sources that Bey and the awesome team at Parkwood Entertain...

All the different names...

Aug 16, 2024 Tim Jeffries | www.thedataschool.co.uk

I was having a lovely conversation with a colleague a few days ago describing how well a weekly Client Project had gone - I’d been doing the data prep, and there was a wonderful moment when despite it having looked awful all week, I finally presse...

How Popular is Your Birthday

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

I love a chart where you don’t need to write any commentary to understand the chart or to understand the analysis. This is one of those charts.

birthday,births,dataanalysis,heatmap,heatmap,popular,rank,tableau

Data Ingestion The essential First step in building a robust Data Pipeline

Aug 15, 2024 Jyoti Gupta | www.thedataschool.co.uk

In 2020, the world generated a staggering 64.2 zettabytes of data, and by 2025, this number is expected to soar to 181 zettabytes (source Statista.com). To put this into perspective, 1 zettabyte equals 1021 byte, highlighting the sheer volume of d...

Planning a workflow

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

Today we attempted to prepare data on the Forbes’ Top 10 paid athletes for analysis by compiling top ten from 2012 to 2014 (https://en.wikipedia.org/wiki/Forbes_list_of_the_world%27s_highest-paid_athletes).

Moving Quadrants on a Scatter Plot

Aug 14, 2024 Alfie King | www.thedataschool.co.uk

With scatter plots its always useful to see trends, however, sometimes we want to see how the points on the scatter plot relate to other scatter plots. Do to this the best way is using quadrants. In this blog we can see how to make these quadrants...

How to build a tournament bracket in Tableau

Aug 14, 2024 Dan Wade | www.thedataschool.co.uk

In 2023, after learning how to make dendograms in Tableau, I had the idea of taking this a step further and making a tournament bracket for the Women’s World Cup which was on at the time. The finished product didn’t come out as I’d expected, but i...

DS46 Week 2 Makeover Monday Design

Aug 14, 2024 Eden Thiede-Palmer | www.thedataschool.co.uk

On Monday DS46 was tasked with designing a dashboard based on the 2024 Week 4 Makeover Monday on the highest paid athletes of 2023.

Maturing Analytics The Road to AI

Aug 14, 2024 Ben Bausili | interworks.com

Welcome back to our journey in maturing analytics. We’ve gone from identifying the actual job to be done to many of the methods and tools you’ll use to deliver on it. In this final installment, we’re going to tackle the elephant in the room: artif...

Data,AI,analytics

How to Setup a Data Extraction Python Project

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

I have started a project where I want to extract source data for a Customer Relations Management (CRM) software and load the raw data into Snowflake for transformation and then reporting. What I found a bit intimidating starting on this project wa...

Data

Groups Vs Sets in Tableau

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

When would you use a group or a set in Tableau?

Creating a dumbbell chart

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

Today we tried a Workout Wednesday challenge and tasked with creating a dumbbell chart (https://workout-wednesday.com/2022w32tab/).

Data Mesh An Independent View

Aug 13, 2024 Mike Oldroyd | interworks.com

The Quick Version The Data Mesh architecture provides a credible blueprint for managing data at scale. It offers a solution for organisations that are simply too large or complex to be able to centralise all of their data within a single enterprise...

Data

Introduction to Viz design with athlete earnings.

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

Week 2 at The Data School is all related to the visual elements of dashboard design. This included nailing down what charts work best in different situations, as well as some visual best practice.

The Latest With Tableau Pulse Make It Work for You

Aug 12, 2024 Sripriya Vemula | interworks.com

If you attended the latest Tableau Conference earlier this spring, or if you’ve spent any time considering the feasibility of a migration to Tableau Cloud, you may be familiar with Tableau Pulse. Tableau Pulse leverages the capabilities of Tableau...

Data,Tableau,TableauPulse

Measuring the Success of Data and Analytics A Quick Start Guide

Aug 12, 2024 Ben Bausili | interworks.com

In the realm of analytics, measuring success can be a complex endeavor. It’s crucial to differentiate between evaluating the success of your entire analytics platform or practice and measuring the success of individual dashboards, initiatives or p...

Data,dataanalytics

Data Dance Combining AI Generated Music with Tableau guest blog post by ...

Aug 12, 2024 Kevin Flerlage (noreply@blogger.com) | www.flerlagetwins.com

      This is a guest blog post from Heather Cox based on one of the most incredible Tableau Public vizzes I have ever seen - her TableauVision Song Contest. This viz utilizes AI-generated songs based on Tableau features and implements...

Tableau

How to Create Multiselect Parameters in Tableau

Aug 10, 2024 Felicia Styer | playfairdata.com

Binary Parameters are a new technique that allows you to store multiple Boolean selections in one parameter, essentially creating a…The post How to Create Multiselect Parameters in Tableau appeared first on Playfair Data.

Advanced,Engineering,Innovation,TableauDesktop,UserExperience

Why Do We Prep Data

Aug 9, 2024 Thiago Santos | www.thedataschool.co.uk

What is Data Prep and Why Do We Prep Data? Imagine walking into a bedroom that’s completely cluttered. Clothes are strewn all over the floor, shoes are scattered under the bed, and you can’t quite remember where you left that one favourite shirt. ...

Data

Week 1 Friday Project

Aug 9, 2024 Eden Thiede-Palmer | www.thedataschool.co.uk

Client: TIL

Reflective Logs First Project

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

Today I completed my first Friday project! It was initially a daunting prospect to be given a briefing and devise a plan to provide a suitable outcome. As I worked through the task, however, I found the insights gained and lessons learned through ...

Data

Reflective Log - DS 46 Week 1 Project

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

Reflective Log for Data Preparation Project