Paris Olympics 2024 What medals did each country win each day

Sep 14, 2024 Donna Coles | donnacoles.home.blog

For this week’s #WOW2024 challenge, I asked the community to rebuild this unit chart depicting the medals won each day by country. I built this out while the Olympics was on, curating the data myself, so there is a chance it may not match ‘officia...

WorkoutWednesday,WOW2024,CustomShapes,DualAxis,INDEX,Reverseaxis,SIZE,TableCalcs,UnitChart,Week37

Optimizing the SQL Performance - Part 1

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

In the previous blog, I compared the difference in the order of writing SQL queries and the order of execution in SQL (link). Acknowledge the execution order in SQL is significant and helpful because the user will know how the SQL queries execute ...

Data,analytics,data,videogames

How I Played the Long Game with InterWorks

Sep 13, 2024 Hilary Hunt | interworks.com

I’m writing this post after all of eight days on the InterWorks payroll, but I’m not exaggerating when I say that walking into the office already feels like a homecoming. I learned about InterWorks a few years ago when I got involved at my local…T...

Culture,onboarding,recruiting

Maximizing Data Insights with Bullet Graphs A Compact Visualization Tool

Sep 12, 2024 Takhmina Pirmahmadova | www.thedataschool.co.uk

Given the variety of chart options available, it’s important to choose one that conveys the message most effectively. For performance-based questions in organizations, a Bullet Graph is an excellent choice for tracking progress against multiple me...

Data,RankDense,Tableau

Alteryx 11 Steps to Create an Iterative Macro for Pagination

Sep 12, 2024 Kate Crawford | www.thedataschool.co.uk

There are four Macro types in Alteryx. This post introduces the Iterative Macro, which loops through a flow based on a condition.

Data,analytics,data,videogames

Lateral Thinking in Games and Data

Sep 12, 2024 Ben Bausili | interworks.com

Or, What Nintendo’s Game Boy has to do with Analytics  Back before the success of the Nintendo Switch or the motion-controller craze of the Nintendo Wii, there was a device that encapsulated a central driving philosophy of Nintendo and was key to ...

Data,analytics,data,videogames

What is CICD How can Azure DevOps Help

Sep 11, 2024 Edward Hayter | www.thedataschool.co.uk

What is CI/CD?

Data,RankDense,Tableau

The Highlights Are On But Nobodys Home

Sep 11, 2024 Vivian Ng | www.thedataschool.co.uk

Today, I’ll be talking about how to highlight all your marks in a visualization (also known as removing unwanted highlighting or disabling Tableau’s default highlighting). Before I describe the process, let me explain what I mean by Tableau’s defa...

Data,RankDense,Tableau

Alteryx 11-ish Steps to Create an Iterative Macro for Pagination

Sep 11, 2024 Kate Crawford | www.thedataschool.co.uk

1) Build a Standard Workflow.

Data,RankDense,Tableau

Mutation Testing An Unknown Known Solution in Software Development

Sep 11, 2024 Matthew Orr | interworks.com

We All Suck at Something I want to let you in on a journey I’ve been on lately, just in case it can be as profound for you as it has been for me. Picture this: You’ve been in auto racing for decades. You were…The post Mutation Testing: An Unknown ...

Data,MutationTesting

Hardening Snowflake Security with Network Rules and Policies

Sep 11, 2024 Chris Hastie | interworks.com

An important step towards ensuring the security of your Snowflake account(s) is the appropriate use of network rules and policies to prevent unauthorised access. These policies are leveraged to ensure that access is only allowed through restricted...

Data,Snowflake

A Use Case for Rank Dense in Tableau

Sep 10, 2024 Robby White | interworks.com

Oftentimes, I find myself in training or enablement sessions, showing the full list of possible functions available to use in Tableau. It’s quite a list of possibilities that starts with ABS (for the absolute value of an integer) and runs through ...

Data,RankDense,Tableau

The Softer Side of Data Visualization Training Course

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

Ken and I are known for our technical abilities within Tableau. I mean, out of 400 blog posts on our website, I’d say that 390 of them are directly related to Tableau. But we’ve been building charts and dashboards for a long, long time...

DataViz,Training

Power BI vs. Tableau

Sep 8, 2024 Marcus Oberdiek | www.thedataschool.co.uk

Ease of use and data visualization

WorkoutWednesday,WOW2024,DualAxis,Gantt,Line,Path,Scaffold,Stepped,Waterfall,Week36

Can you build a Measure Names Waterfall

Sep 8, 2024 Donna Coles | donnacoles.home.blog

I’ve been on my holibobs, so haven’t blogged a solution for a few weeks. It’s been a bit of a struggled to get my head re-engaged to be honest, as I’m sure you can all relate to. Anyway this week’s challenge was set by Sean, to produce a waterfall...

WorkoutWednesday,WOW2024,DualAxis,Gantt,Line,Path,Scaffold,Stepped,Waterfall,Week36

3 Ways to Apply Python Script in Tableau Desktop

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

Tableau users usually apply built-in functions to calculate, filter, and retrieve data. However, in some complicated problems, the built-in function in Tableau may not be useful in solving the problem. We can consider using the Python script throu...

What did it take to get into DS46

Sep 5, 2024 Robbin Vernooij | www.thedataschool.co.uk

DS46 has just started their journey at the Data School. A perfect time to look at what it took for them to get in!

Git GitHub and GitHub Desktop for Beginners

Sep 5, 2024 Zoe Reed | www.thedataschool.co.uk

This blog aims to clarify the differences between Git, GitHub and GitHub Desktop, including how they can be used together to manage code both on your local machine and on GitHub.

Context Filters and why do we need them

Sep 5, 2024 Rory Moxom | www.thedataschool.co.uk

When covering an introduction to Tableau Desktop there was one feature that jumped out that would really have helped if I knew about it before my Data School Application!

Unit Testing In Data Engineering dbts latest update

Sep 4, 2024 Edward Hayter | www.thedataschool.co.uk

What is Unit Testing

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.